pgmcp
Active·★ 530·NOASSERTION·Updated 2026-05-26
★ Data Processing★ API Integration
An MCP server to query any Postgres database in natural language.
PGMCP connects AI assistants to any PostgreSQL database through natural language queries. It provides secure read-only access, automatic streaming, and supports multiple output formats. It works with various MCP-compatible clients like Cursor and Claude Desktop.
#agent#agentic-ai#ai#analytics#artificial-intelligence#data-analysis#database#kong
01
Features
01Natural Language to SQL
02Automatic Streaming
03Safe Read-Only Access
04Text Search
05Multiple Output Formats
02
Compatibility
Linux
Linux (Binary)
Verified via docs
macOS
macOS (Binary)
Verified via docs
Windows
Windows (Binary)
Verified via docs
Docker
Docker
Verified via docs
Kubernetes
Kubernetes
Verified via docs
03
Quick start
1
$ docker run -e DATABASE_URL='postgres://user:pass@host:5432/db' -p 8080:8080 ghcr.io/subnetmarco/pgmcp:latest
04
Use cases
↳Query database using natural language
↳Search across all text columns
↳Integrate with MCP clients like Cursor and Claude Desktop
05
Alternatives
openagent★ 5.1k
⚡️AI Cloud OS: Open-source enterprise-level AI knowledge base and MCP (model-context-protocol)/A2A (agent-to-agent) management platform with admin UI, user management and Single-Sign-On⚡️, supports ChatGPT, Claude, Llama, Ollama, HuggingFace, etc., chat bot demo: https://ai.casibase.com, admin UI demo: https://ai-admin.casibase.com
awesome-claude★ 250
HeyClaude is a curated registry and distribution surface for Claude and AI-workflow assets: agents, MCP servers, skills, commands, hooks, rules, guides, tools, jobs, Raycast feeds, static data exports, and an npm MCP package.
design-extract★ 3.0k
Extract any website's complete design system with one command. DTCG tokens, semantic+primitive+composite, MCP server for Claude Code/Cursor/Windsurf, multi-platform emitters (iOS SwiftUI, Android Compose, Flutter, WordPress), Tailwind v4, Figma variables, shadcn/ui, CSS health audit, WCAG remediation, Chrome extension. MIT, Playwright, Node 20+.
Related searches
Comments
Log in to leave a comment
- PParker PatelMay 2, 2026
Setup was straightforward, production-grade config and running in minutes. The maintainers are responsive to issues.
- JJamie GarciaApr 27, 2026
Postgres via MCP is exactly the right abstraction. The robust performance is impressive for an open-source tool.
- SShawn ClarkApr 17, 2026
Database via MCP is exactly the right abstraction. Works reliably in production environments.
- LLane KimApr 11, 2026
Dropped this into flexible pipeline and it just worked. Would recommend for flexible use cases.