PostgreSQL MCP Server
Supports UIby helloworld-zy
Production-grade MCP server that converts natural language to secure SQL queries for PostgreSQL databases.
What it does
Provides a secure interface for AI agents to interact with PostgreSQL databases using natural language, featuring automatic SQL generation, safety validation, and result verification.
Tools
- NL-to-SQL: Translates natural language questions into optimized PostgreSQL queries.
- Schema Inspector: Automatically caches and manages database schema for LLM context.
- Result Validator: AI-powered validation of query results with confidence scoring.
Installation
{
"mcpServers": {
"postgres": {
"command": "uv",
"args": [
"--directory",
"/absolute/path/to/pg-mcp",
"run",
"python",
"main.py"
],
"env": {
"DATABASE_HOST": "localhost",
"DATABASE_NAME": "your_database",
"DATABASE_USER": "your_user",
"DATABASE_PASSWORD": "your_password",
"OPENAI_API_KEY": "sk-your-api-key-here"
}
}
}
}
Supported hosts
- Claude Desktop
Quick install
git clone https://github.com/helloWorld-zy/pg-mcp-rev && cd pg-mcp-rev && uv syncInformation
- Pricing
- free
- Published
- 6/13/2026
- stars
- 0
Categories
Choose your AI client and follow the steps below.
Claude Desktop
Add the configuration to claude_desktop_config.json with your DB credentials and OpenAI API key.Related Apps
DiffSitter MCP
MCP ServerAI-powered structural code navigation using tree-sitter ASTs for semantic understanding across 14+ languages.
OpenAI Apps SDK Examples
MCP AppOfficial example gallery of interactive MCP widgets for ChatGPT — 3D viewers, maps, carousels, shopping carts, and more.
Human MCP
MCP ServerGive AI agents human-like senses: visual analysis, image/video generation, speech synthesis, browser automation, and advanced reasoning — 29 MCP tools in one se
Shopify MCP Server
MCP ServerDirect interaction with Shopify store data via GraphQL API for managing products, customers, and orders.
Git MCP Server
MCP ServerFull-featured Git MCP server exposing 28 tools for AI agents to clone, commit, branch, diff, merge, rebase, and more via STDIO or Streamable HTTP.
CodexPotter
MCP ServerAutonomous reconciliation loop that drives Codex to align your codebase with instructed states.
Smart Coding MCP
MCP ServerSemantic code search for AI assistants using local embeddings — find code by meaning, not just keywords.
Snowflake MCP Server
MCP ServerDirect Snowflake database interaction via MCP, enabling AI to run SQL queries, explore schemas, and manage data insights.