A comprehensive PostgreSQL integration that exposes 278 tools spanning schema introspection, data manipulation, and performance monitoring. The standout feature is Code Mode, which runs multi-step database operations inside a V8 isolate to drastically cut token consumption on complex workflows. You get deterministic error translation to prevent AI hallucinations, OAuth 2.1 authentication with granular scopes, and first-class support for extensions like pgvector, PostGIS, and pg_cron. Ships with 24 resources for real-time metrics and 21 AI-optimized prompts for query tuning. Reach for this when you need an AI agent to perform production-grade database work with audit trails, migration tracking, and semantic diffing built in.
claude mcp add --transport stdio io.github.neverinfamous-postgres-mcp uvx postgres-mcp