pgmcp MCP server

Name: pgmcp
Author: subnetmarco

An MCP server to query any Postgres database in natural language.

What pgmcp does

Summarised from the project README; check the repository for the latest details.

Features

Natural Language to SQL: Ask questions in plain English
Automatic Streaming: Handles large result sets automatically
Safe Read-Only Access: Prevents any write operations
Text Search: Search across all text columns
Multiple Output Formats: Table, JSON, and CSV
PostgreSQL Case Sensitivity: Handles mixed-case table names correctly

Requirements

PostgreSQL database (existing database with your schema)
OpenAI API key (optional, for AI-powered SQL generation)

Repository: subnetmarco/pgmcp
Stars: ★542
Language: Go
Last updated: 2026-05-26
agentagentic-aiaianalyticsartificial-intelligencedata-analysisdatabasekongmcpmcp-serverpostgrespostgresql

How to install pgmcp

No install config was found in this README. See the repository for setup steps, then follow our guides for Claude Desktop, Cursor or VS Code.

Featured in: Best MCP servers for PostgreSQL

Listed on Socketlist – add this badge to your README:

Badge markdown

[![Listed on Socketlist](https://socketlist.pages.dev/badge.svg)](https://socketlist.pages.dev/s/subnetmarco-pgmcp/)

Maintain this project? Get it featured for free during launch →

Compare with codebase-memory-mcp →

Related Databases MCP servers

codebase-memory-mcp by DeusData · ★46616
High-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 langu
Databases

nightingale by ccfos · ★13354
Open-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.
Databases

code-graph-rag by vitali87 · ★5258
The ultimate RAG for your monorepo. Query, understand, and edit multi-language codebases with the power of AI and knowledge graphs
Databases

tabularis by TabularisDB · ★5215
Open-source desktop SQL workspace with 3 built-in database drivers and 16 shipped plugins, including SQL Server, DuckDB, ClickHouse and Redi
Databases

whodb by clidey · ★5037
Where data access meets operational intelligence
Databases

dbhub by bytebase · ★3651
Token conscious database MCP server for Postgres, MySQL, SQL Server, Oracle, MariaDB, SQLite.
Databases

Weekly MCP digest – new and trending MCP servers in your inbox.