AI & Automation
Where AI meets database management, from MCP servers to AI DBAs and where the industry is headed.
Safely enable AI Coding Tools to use EXPLAIN ANALYZE on production: Introducing Workbooks in the pganalyze MCP Server
15 October, 2026Connecting AI coding tools to production is typically ill-advised: it's not clear what might happen, and how they might cause availability or other issues. But in practice that often means the feedback loop that AI tools rely on is broken, and requires a lot of manual intervention. In the context of database query optimization, the practical problem becomes "How do I run EXPLAIN ANALYZE on production" for a suggested query rewrite.
Continue reading→pganalyze MCP Server is now in Public Preview
30 April, 2026Like many of you, we see benefits to use AI tools in our database workflows, but at the same time worry about the risks. Pasting query output into a chat box risks leaking customer data, and pointing an agent at a live production connection can lead to worse. The pganalyze MCP Server takes a different approach: it gives the model curated access to the production database statistics pganalyze already collects, with no direct database access required.
Continue reading→The Dilemma of the ‘AI DBA’
11 March, 2026Like many in the industry, my perspective on AI tools has shifted considerably over the past year, specifically when it comes to software engineering tasks. Going from “this is nice, but doesn’t really solve complex tasks for me” to “this actually works pretty well for certain use cases.” But the more capable these tools become, the sharper one dilemma gets: you can hand off the work, but an AI agent won’t ultimately be responsible when the database goes down and your app stops working.
Continue reading→