MCPg

MCPg is a robust, production-grade Model Context Protocol (MCP) server designed specifically for PostgreSQL. It empowers AI agents to safely inspect, query, operate, and tune a Postgres database using a comprehensive suite of over 250 tools. These tools cover everything from catalog introspection, natural-language SQL, and hybrid search to DBA-grade operations like health checks, index tuning, and migrations. Built with production environments in mind, MCPg emphasizes safety with read-only defaults and AST validation, offers deep PostgreSQL-native integration without ORM abstraction, and includes critical features like connection pooling, multi-tenancy, read-replica routing, and built-in observability with Prometheus metrics.

主な機能

ユースケース