devopam/MCPg

What it does

devopam/MCPg is a production-grade Model Context Protocol (MCP) server designed to integrate PostgreSQL databases with AI assistants like Claude and ChatGPT. It provides over 100 tools for comprehensive database management, including catalog introspection, AST-validated safe query execution, automatic index tuning, natural language to SQL conversion, and support for advanced PostgreSQL extensions.

How to set up

Installation is straightforward via the MCP protocol. Users can configure MCPg as an MCP server in their AI assistant settings, connecting it to their PostgreSQL instance. The tool supports multiple transport methods including HTTP and stdio, making it compatible with various deployment environments (cloud, local, macOS, Windows, Linux). Detailed configuration instructions are available in the GitHub repository.

Key features

• 100+ database management tools for complete PostgreSQL control
• AST-validated query execution ensuring safe SQL operations
• Automatic index tuning and performance optimization
• Natural language to SQL translation powered by AI
• Native support for pgvector, TimescaleDB, and Apache AGE extensions
• Dual transport support: HTTP and stdio protocols
• Cross-platform compatibility (macOS, Windows, Linux, cloud)
• Production-grade reliability and security