PostgreSQL

PG-MCP is a PostgreSQL Model Context Protocol server that enables AI agents to discover, connect to, query, and understand PostgreSQL databases through a resource-oriented architecture. It extends the reference Postgres MCP implementation with multi-database support, rich catalog information extraction, extension context for PostGIS and pgVector, query execution plan analysis, and robust connection management. The server exposes database schema resources, data access capabilities, and specialized tools for executing read-only SQL queries, all while maintaining security through connection ID abstraction and read-only transaction enforcement. Built with Python 3.13 and asyncpg, it's particularly valuable for developers and data analysts who need AI assistants to interact with PostgreSQL databases without exposing sensitive connection details.