Connects Claude to PostgreSQL 12-18 with 278 tools spanning schema introspection, query execution, migration tracking, and extension support for pgvector, PostGIS, pg_cron, and others. The standout feature is Code Mode, which runs multi-step operations inside a V8 isolate to cut token overhead by up to 90% instead of chaining dozens of individual tool calls. Ships with OAuth 2.1 authentication, granular scopes, deterministic error translation to prevent AI hallucinations, and 24 resources that surface real-time health metrics and replication stats. You also get 21 built-in prompts for query tuning and schema design. Reach for this when you need enterprise-grade PostgreSQL access with proper audit trails, connection pooling, and semantic diffing before restoring data.
claude mcp add --transport stdio io.github.neverinfamous-postgres-mcp-server uvx postgres-mcp-server