Show HN: Cloud-Ready Postgres MCP Server
a year ago
- #Database Tools
- #PostgreSQL
- #AI Agents
- PG-MCP is a server implementation of the Model Context Protocol (MCP) for PostgreSQL databases.
- It provides a comprehensive API for AI agents to interact with PostgreSQL databases.
- Key features include multi-database support, rich catalog information, and query explanation tools.
- Built-in contextual information for PostgreSQL extensions like PostGIS and pgvector.
- Includes tools for connection management, query execution, and schema exploration.
- Supports read-only mode by default with secure connection handling.
- Can be deployed using Docker Compose or run directly with Python.
- Includes test scripts and a Claude-powered natural language to SQL conversion tool.
- Built on MCP, FastMCP, asyncpg, and YAML for extension context.
- Contributions welcome for additional extensions and features.