pgmcp

Why we included this project

PGMCP is an MCP server that lets AI assistants query an existing PostgreSQL database in plain English. If your team already works with Cursor, Claude Desktop, or VS Code extensions, you can point it at your current schema and ask questions like 'who are the top customers?' without writing SQL or changing the database. Results come back as tables, JSON, or CSV. The read-only enforcement and input validation are the details that matter if you are nervous about letting an agent near production data, and the schema cache plus auto-pagination keep large result sets manageable. It also handles free-text search across all columns and mixed-case table names, which is a common annoyance with real-world schemas. Teams that want a self-hosted data access layer for their AI tools, rather than a full BI dashboard, will find this a practical fit.