Postgres MCP

What it is

A Go server that sits in front of an existing PostgreSQL database, turns natural-language questions into SQL, and returns the rows. It assumes nothing about your schema and requires no changes to it.

What you get

• ask takes a plain-language question, generates SQL against your schema and returns the result, streaming automatically when the result set is large
• search does free-text search across the database's text columns
• stream handles very large result sets with pagination
• Every query runs in a read-only transaction, so writes and schema changes are blocked outright
• Query timeouts and input validation, so a bad question cannot pin the database
• Mixed-case table names are handled correctly, which is where naive SQL generation usually falls over
• When the generated SQL is wrong it comes back with the offending statement and a suggestion instead of crashing
• A bundled client returns results as a table, JSON or CSV

Requirements

An existing PostgreSQL database and its connection string. SQL generation calls a model, so an API key for it; without one the natural-language path is unavailable. Prebuilt binaries, a container image and Kubernetes manifests are provided, and bearer-token authentication can be switched on for the HTTP endpoint.

Setup effort

Follow the published steps — tar xzf pgmcp_*.tar.gz

Tools you get

3 tools named in the project's documentation. Write queries (INSERT, UPDATE, DELETE) are blocked. Without OPENAI_API_KEY, ask cannot turn English questions into SQL.

Requires

DATABASE_URL in your environment

Optional

OPENAI_API_KEY in your environment