Browse
→ Data & Storage
→ PostgreSQL Inspector MCP
PostgreSQL Inspector MCP
Inspects PostgreSQL schemas, relationship dictionaries and database health, with read-only SQL and query-plan tools. Supports local stdio and API-key-protected Streamable HTTP. Use a least-privilege database role and protect returned rows. Optional request debugging logs tool inputs and results; health and metrics endpoints remain public in HTTP mode. Public source repository created November 10, 2026 (UTC).
MCP unverified
Integration
| Transport | stdio |
| Auth | none |
| Endpoint | uv run start --transport stdio |
| Install | Review the source and uv project requirements, configure an approved PostgreSQL database with a read-only role and private connection settings, then register uv --directory /path/to/pg_inspector run start --transport stdio; keep request debugging off for sensitive data and review separate API-key and network controls before enabling HTTP |
Use Cases
| 01 | Discover foreign-key join paths |
| 02 | Inspect an expensive query plan |
| 03 | Review database health warnings |
Tags
postgresql schema-inspection query-plans database-health
Machine-readable: /api/servers.json
· JSON-LD schema embedded in <head>