Browse
→ Data & Storage
→ pgEdge Postgres MCP Server
pgEdge Postgres MCP Server
Production-grade PostgreSQL MCP server that connects AI tools to any Postgres database with full schema introspection, performance metrics, and multi-database support. Pulls detailed information about primary keys, foreign keys, indexes, column types, and constraints. Exposes pg_stat_statements for query optimization. Supports TLS, token auth, and read-only enforcement. Works with Postgres 14+, including community Postgres, Amazon RDS, and pgEdge distributions. Open source under PostgreSQL license. Created by pgEdge.
MCP unverified
Integration
| Transport | stdio |
| Auth | none |
| Endpoint | pgedge-postgres-mcp |
Use Cases
| 01 | Connect Claude Code, Cursor, or any MCP-compatible AI tool directly to PostgreSQL databases for schema exploration, query writing, and migration assistance |
| 02 | Analyze database performance by exposing pg_stat_statements and index usage metrics to AI agents for automated query optimization recommendations |
| 03 | Support multi-database workflows across dev, staging, and production PostgreSQL instances from a single MCP server with full schema introspection and security controls |
Tags
postgres database sql open-source schema-introspection performance multi-database query-optimization
Machine-readable: /api/servers.json
· JSON-LD schema embedded in <head>