PGMCP

Data and operations teams that want to query an existing PostgreSQL database in plain language.

Use it now Want it running at your company?

Recommendedour rating
542gitHub stars
Not statedlicence
5 months agolast update

Use it now

git clone https://github.com/subnetmarco/pgmcp.git

Open the original ↗

Third party software. By copying, downloading or installing it you accept the Academy legal notice: you are responsible for reviewing its code and permissions before use.

View README.md on GitHub ↗

What it does

An MCP server that connects AI assistants to a PostgreSQL database so you can ask questions in plain language and get structured SQL results. It streams results automatically and works in read-only mode. It runs with Cursor, Claude Desktop and other MCP clients.

Use cases

01Ask which customer has placed the most orders
02List the tables in a database
03Get query results as a table

Questions about
PGMCP.

What is PGMCP used for?

Data and operations teams that want to query an existing PostgreSQL database in plain language. An MCP server that connects AI assistants to a PostgreSQL database so you can ask questions in plain language and get structured SQL results. It streams results automatically and works in read-only mode. It runs with Cursor, Claude Desktop and other MCP clients.

How do I install PGMCP?

Run this in your terminal: git clone https://github.com/subnetmarco/pgmcp.git

Is PGMCP open source?

The code is on GitHub (subnetmarco/pgmcp). Check the licence in the repository before using it at work.

Is PGMCP safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.

Related resources

Read the guide: AI data analysts: ask your data ↗