subnetmarco/pgmcp

Score: 37.7 Rank #3297

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

Overview

subnetmarco/pgmcp is a Go MCP server. An MCP server to query any Postgres database in natural language. Topics: agent, agentic-ai, ai, analytics, artificial-intelligence, kong, mcp, mcp-server, postgres, postgresql, data-analysis, database.

Ranked #3297 out of 25632 indexed tools.

Ecosystem

Go NOASSERTION

agentagentic-aiaianalyticsartificial-intelligencekongmcpmcp-serverpostgrespostgresqldata-analysisdatabase

Signal Breakdown

Stars 525

Freshness 5mo ago

Issue Health 80%

Contributors 1

Dependents 0

Forks 59

Description Good

License NOASSERTION

How to Improve

Description low impact

Expand your description to 150+ characters for better discoverability

License low impact

Add an MIT or Apache-2.0 license to signal trust and enable adoption

Freshness high impact

Last commit was 171 days ago — a recent commit would boost your freshness score

Badge

Markdown

[![AgentRank](https://agentrank-ai.com/api/badge/tool/subnetmarco--pgmcp)](https://agentrank-ai.com/tool/subnetmarco--pgmcp)

HTML

<a href="https://agentrank-ai.com/tool/subnetmarco--pgmcp"><img src="https://agentrank-ai.com/api/badge/tool/subnetmarco--pgmcp" alt="AgentRank"></a>

Details

Stars: 525
Forks: 59
Open Issues: 1
Closed Issues: 4
Contributors: 1
Dependents: —
Language: Go
License: NOASSERTION
Last Commit: 5mo ago

Matched Queries

"mcp server""mcp-server"

From the README

# PGMCP - PostgreSQL Model Context Protocol Server

PGMCP connects AI assistants to **any PostgreSQL database** through natural language queries. Ask questions in plain English and get structured SQL results with automatic streaming and robust error handling.

**Works with**: Cursor, Claude Desktop, VS Code extensions, and any [MCP-compatible client](https://modelcontextprotocol.io/)

## Quick Start

PGMCP connects to **your existing PostgreSQL database** and makes it accessible to AI assistants through natural language queries.

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

### Basic Usage

```bash
# Set up environment variables
export DATABASE_URL="postgres://user:password@localhost:5432/your-existing-db"
export OPENAI_API_KEY="your-api-key"  # Optional

# Run server (using pre-compiled binary)
./pgmcp-server

# Test with client in another terminal
./pgmcp-client -ask "What tables do I have?" -

Read full README on GitHub →

View on GitHub →

Are you the maintainer? Claim this listing