MCPg

•
15
•

Empowers AI agents to safely inspect, query, operate, and tune PostgreSQL databases through a production-grade Model Context Protocol server.

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.

主な機能

01Production-ready features including connection pooling, multi-tenancy, and read-replica routing.
02Safe by default with read-only access, AST validation, and strict identifier handling.
03Comprehensive toolkit for both application data access and DBA operations (250+ tools).
04Deep PostgreSQL-native integration supporting various extensions (e.g., TimescaleDB, pgvector).
05Built-in observability with Prometheus metrics and structured audit trails.
068 GitHub stars

ユースケース

01Enabling AI agents to perform database introspection and schema summarization.
02Assisting with advanced query performance analysis and optimization.
03Automating DBA tasks such as health checks, index tuning, and database migrations.