pgmcp — MCP Server by subnetmarco

by subnetmarco · MCP Server · ★ 529

Last updated: · Indexed by AgentSkillsHub · Auto-synced every 8h

About pgmcp

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 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 DATABASEURL="postgres://user:password@localhost:5432/your-existing-db" export OPENAIAPIKEY="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?" -format table ./pgmcp-client -ask "Who is the customer that has placed the most orders?" -format

agentagentic-aiaianalyticsartificial-intelligencedata-analysisdatabasekongmcpmcp-server

Quick Facts

Stars529
Forks61
LanguageGo
CategoryMCP Server
Quality Score39.2/100
Open Issues2
Last Updated2026-05-26
Created2025-09-16
Platformsgo, mcp
Est. Tokens~7k

Compatible Skills

These tools work well together with pgmcp for enhanced workflows:

  • hyperterse — semantic(0.36)+rare_topics+same_lang+similar_pop+shared_platform (51%)
  • agent — semantic(0.32)+complementary+rare_topics+similar_pop (50%)
  • openchatbi — semantic(0.30)+complementary+rare_topics+similar_pop (49%)
  • anyquery — semantic(0.23)+rare_topics+same_lang+similar_pop+shared_platform (47%)
  • dbhub — semantic(0.39)+rare_topics+similar_pop+shared_platform (47%)

pgmcp alternative? Top 6 similar tools

Looking for a pgmcp alternative? If you're comparing pgmcp with other mcp server tools, these 6 projects are the closest alternatives on Agent Skills Hub — ranked by topic overlap, star count, and community traction.

  • MCP-PostgreSQL-Ops by call518 · ⭐ 150

    🐘 Give AI assistants full PostgreSQL DBA superpowers — 30+ tools for performance analysis, bloat detection, l

  • wren-engine by Canner · ⭐ 662

    The open context engine for AI agents support 15+ data sources. Built on Rust and Apache DataFusion.

  • pg-aiguide by timescale · ⭐ 1.8k

    MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better Post

  • nocturne_memory by Dataojitori · ⭐ 1.2k

    A lightweight, rollbackable, and visual Long-Term Memory Server for MCP Agents. Say goodbye to Vector RAG and

  • volcano-agent-sdk by Kong · ⭐ 388

    🌋 Build AI agents that seamlessly combine LLM reasoning with real-world actions via MCP tools — in just a few

  • decipher-research-agent by mtwn105 · ⭐ 145

    Turn topics, links, and files into AI-generated research notebooks — summarize, explore, and ask anything.

More MCP Server Tools

Explore other popular mcp server tools:

View all MCP Server tools →

Popular Go Agent Tools

Frequently Asked Questions

What is pgmcp?

pgmcp is An MCP server to query any Postgres database in natural language.. It is categorized as a MCP Server with 529 GitHub stars.

What programming language is pgmcp written in?

pgmcp is primarily written in Go. It covers topics such as agent, agentic-ai, ai.

How do I install or use pgmcp?

You can find installation instructions and usage details in the pgmcp GitHub repository at github.com/subnetmarco/pgmcp. The project has 529 stars and 61 forks, indicating an active community.

What are the best alternatives to pgmcp?

The top alternatives to pgmcp on Agent Skills Hub include MCP-PostgreSQL-Ops, wren-engine, pg-aiguide. Each offers a different approach to the same problem space — compare them side-by-side by stars, quality score, and community activity.

View on GitHub → Browse MCP Server tools