Using LLMs and MCP to Debug PostgreSQL Performance in Rails
A tutorial on automating PostgreSQL performance debugging in Rails using LLMs and the Model Context Protocol (MCP) with a Slack bot interface.
Paweł Urbanek is a senior Ruby/Rust developer specializing in backend performance, distributed systems, cloud infrastructure, and PostgreSQL optimization.
7 articles from this blog
A tutorial on automating PostgreSQL performance debugging in Rails using LLMs and the Model Context Protocol (MCP) with a Slack bot interface.
A tutorial on a custom puts debugging workflow for Rails, inspired by Rust's dbg! macro, using the dbg-rb gem.
A technical guide on discovering and executing a long-tail MEV strategy to profit from imbalanced Uniswap V2 pools using Rust tools.
A guide to discovering niche MEV strategies using a custom Rust CLI tool and Revm for blockchain data analysis.
A technical guide on using the alloy-deadbeef Rust library to generate Ethereum transactions with custom vanity hash prefixes like 0xbeef.
A developer shares their technical journey and lessons learned from building an unprofitable MEV (Maximum Extractable Value) crypto bot using Rust for Ethereum.
A technical guide on optimizing MEV arbitrage smart contracts using Yul and Huff assembly for gas efficiency on the Ethereum EVM.