postgres-mcp-server

Dhiraj123-star/postgres-mcp-server

3.2

If you are the rightful owner of postgres-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

An Enhanced Model Context Protocol (MCP) server that integrates PostgreSQL with OpenAI GPT-4o-mini for natural language to SQL query execution.

Tools
4
Resources
0
Prompts
0

🚀 Enhanced MCP PostgreSQL Server + AI + FastAPI

An Enhanced Model Context Protocol (MCP) server that connects PostgreSQL with OpenAI GPT-4o-mini, now extended with FastAPI endpoints to enable natural language to SQL query execution via both MCP client and REST API.

🔎 Core Functionality

  • 🤖 AI-Powered SQL Generation Convert natural language queries into safe PostgreSQL SELECT statements using GPT-4o-mini.

  • 🛡 Safe Query Execution Only allows read-only queries (e.g., SELECT, WITH), blocking dangerous operations like DROP, DELETE, UPDATE.

  • 🗂 Schema Awareness Automatically retrieves database schema to give AI context for generating accurate SQL queries.

  • 📊 Formatted Results SQL query results are neatly formatted in a table-like output.

  • 📝 SQL Validation via AI Validate raw SQL queries with AI for syntax correctness, schema compatibility, and performance.

⚡ New Enhancement: FastAPI Endpoints

  • Natural Language Query Endpoint → Convert plain English into SQL and get results.
  • Execute SQL Endpoint → Run raw SQL queries (restricted to safe operations).
  • Get Schema Endpoint → Retrieve schema details for all or specific tables.
  • Validate SQL Endpoint → Validate SQL queries without executing them.

⚙️ Available Tools (MCP + API)

  • natural_language_query → Ask database questions in plain English.
  • execute_sql → Run raw SQL queries (with safety checks).
  • get_schema → Fetch schema details for all or specific tables.
  • validate_sql → Validate SQL queries without execution.

💬 Interactive Client + REST API

  • MCP Client → Use CLI to run tools interactively.
  • FastAPI → Access all tools via RESTful endpoints.

🔄 CI/CD Pipeline Integration

  • GitHub Actions Workflow → Automated builds and tests on every push.
  • Docker Image Build & Push → Publishes latest images to DockerHub (dhiraj918106/...).
  • Deployment Ready → Simple, production-style pipeline to keep images updated.