An MCP for your Postgres DB | POSETTE: An Event for Postgres 2026

Pamela Fox demonstrates how to build MCP servers for PostgreSQL using Python and FastMCP, comparing different tool design approaches—from free-form SQL to structured typed inputs—and analyzing how each affects LLM query accuracy, safety, and efficiency. The talk is for developers integrating LLMs with databases who want to prevent common failure modes like SQL injection, accidental destructive operations, and expensive unbounded queries.