Pgmcp

About Pgmcp

PGMCP is an open-source Model Context Protocol (MCP) server that connects AI assistants to any PostgreSQL database, enabling users to query databases using natural language and receive structured SQL results. It features robust error handling, automatic streaming, comprehensive security (read-only enforcement, input validation, transaction isolation), multiple output formats (table, JSON, CSV), and compatibility with various clients such as Cursor, VS Code extensions, Claude Desktop, and any MCP-compatible client. The tool is ideal for developers or organizations seeking to allow AI-driven querying of their existing PostgreSQL databases without modifying schemas or exposing write permissions.