Postgresql Mcp

Created By
Prasanna H3 months ago
## Overview This is an MCP (Model Context Protocol) server that provides intelligent analysis, documentation, and complete CRUD operations for PostgreSQL databases. It combines deterministic schema extraction with AI-powered reasoning and secure data manipulation operations to help users and AI agents understand and interact with complex database structures. **Performance Optimized & Extended:** Started at 38 tools, optimized to 19 tools (~50% reduction), then strategically extended to 27 tools with high-value query optimization, data management, transactions, and monitoring capabilities. ### Key Features - **Comprehensive Coverage**: 27 carefully designed tools covering all PostgreSQL operations - **Schema Extraction**: Automatically extract tables, columns, relationships, and constraints - **Intelligent Analysis**: Detect junction tables, implicit relationships, and suggest optimal joins - **AI-Powered Insights**: Leverage Ollama/LLM to generate business explanations and recommendations - **Complete CRUD Operations**: Unified tools for all data manipulation with SQL injection prevention - **Query Optimization**: Execution plan analysis, combined index analysis (suggest + unused detection) - **Data Management**: Import/export (CSV/JSON/SQL), full-text search - **Transaction Support**: Atomic multi-operation transactions with rollback - **Monitoring**: Database statistics, cache metrics, slow queries, connection tracking - **Multiple Output Formats**: - Mermaid ER diagrams (with SVG rendering) - Mermaid relationship flowcharts (with SVG rendering) - Comprehensive Markdown documentation - Visual diagram files (SVG, PNG, PDF) - **Query Assistance**: Smart join type recommendations (INNER vs LEFT) - **Modular Architecture**: Clean, extensible design organized by capability - **Diagram Rendering**: Auto-generate visual database structure diagrams - **Security**: Parameterized queries, input validation, SQL injection prevention
Overview

Overview

This is an MCP (Model Context Protocol) server that provides intelligent analysis, documentation, and complete CRUD operations for PostgreSQL databases. It combines deterministic schema extraction with AI-powered reasoning and secure data manipulation operations to help users and AI agents understand and interact with complex database structures.

Performance Optimized & Extended: Started at 38 tools, optimized to 19 tools (~50% reduction), then strategically extended to 27 tools with high-value query optimization, data management, transactions, and monitoring capabilities.

Key Features

  • Comprehensive Coverage: 27 carefully designed tools covering all PostgreSQL operations
  • Schema Extraction: Automatically extract tables, columns, relationships, and constraints
  • Intelligent Analysis: Detect junction tables, implicit relationships, and suggest optimal joins
  • AI-Powered Insights: Leverage Ollama/LLM to generate business explanations and recommendations
  • Complete CRUD Operations: Unified tools for all data manipulation with SQL injection prevention
  • Query Optimization: Execution plan analysis, combined index analysis (suggest + unused detection)
  • Data Management: Import/export (CSV/JSON/SQL), full-text search
  • Transaction Support: Atomic multi-operation transactions with rollback
  • Monitoring: Database statistics, cache metrics, slow queries, connection tracking
  • Multiple Output Formats:
    • Mermaid ER diagrams (with SVG rendering)
    • Mermaid relationship flowcharts (with SVG rendering)
    • Comprehensive Markdown documentation
    • Visual diagram files (SVG, PNG, PDF)
  • Query Assistance: Smart join type recommendations (INNER vs LEFT)
  • Modular Architecture: Clean, extensible design organized by capability
  • Diagram Rendering: Auto-generate visual database structure diagrams
  • Security: Parameterized queries, input validation, SQL injection prevention

Server Config

{
  "mcpServers": {
    "SchemaIntelligence": {
      "command": "C:\\Users\\user\\.local\\bin\\uv.EXE",
      "args": [
        "run",
        "--frozen",
        "--with",
        "mcp[cli]",
        "--with",
        "psycopg2",
        "--with",
        "ollama",
        "--with",
        "pymermaid",
        "--with",
        "requests",
        "--with",
        "pillow",
        "mcp",
        "run",
        "C:\\Users\\user\\Desktop\\MCP-ToolHub\\PostgreSQL-MCP\\postgresql_server.py"
      ],
      "env": {
        "DB_HOST": "localhost",
        "DB_PORT": "6739",
        "DB_NAME": "MCP",
        "DB_USER": "postgres",
        "DB_PASSWORD": "radha",
        "OLLAMA_BASE_URL": "http://192.168.1.143:11434",
        "OLLAMA_MODEL": "gpt-oss:120b-cloud",
        "DEBUG": "False"
      }
    }
  }
}
Project Info
Created At
3 months ago
Updated At
3 months ago
Author Name
Prasanna H
Star
-
Language
-
License
-
Category

Recommend Servers

View All
Linkpulse

2 days ago
Tavily Mcp
@tavily-ai

JavaScript
a year ago
//beforeyouship — LLM Cost Modeling From Your Editor
@Indiegoing

Query realistic LLM cost models without leaving your editor. beforeyouship models the **true monthly cost** of an LLM app architecture — retries, prompt caching, batch discounts, infra overhead, and 3×/10× growth — across GPT-5.x, Claude, Gemini, DeepSeek, and more. Not a token calculator: a planning tool for the design phase, before you commit to a stack. **No API key needed to try it** — demo mode covers the six free-tier models. A Pro key from [beforeyouship.dev](https://beforeyouship.dev) unlocks the full 18-model catalog. ## What you can ask - "How much will a RAG chatbot cost at 10,000 requests/day?" - "Compare Claude Haiku vs Gemini Flash pricing for my workload" - "What's the cheapest model for a multi-step agent at scale?" - "Show me current per-token prices for Anthropic models" ## Tools ### `estimate_cost` Full cost model for an architecture at a given usage level. Returns Naive / Realistic / Worst Case monthly cost per model, 3×/10× growth scenarios, and an opinionated recommendation with reasoning. ### `get_model_prices` Current per-1M-token pricing — input, output, cached input, batch — with context windows and staleness metadata. ### `list_archetypes` Seven preset architecture patterns (simple chatbot, chatbot with history, RAG pipeline, multi-model router, coding assistant, document processor, multi-step agent) used as starting points for estimates. ## Setup **Claude Code:** ​```bash claude mcp add --transport http beforeyouship https://beforeyouship.dev/api/mcp ​``` **Cursor / other clients** — add a remote server: ​```json { "mcpServers": { "beforeyouship": { "type": "streamable-http", "url": "https://beforeyouship.dev/api/mcp" } } } ​``` Add an `Authorization: Bearer bys_...` header with a Pro key for the full catalog. ## Try it > Estimate the monthly cost of a RAG pipeline at 10,000 requests/day

a day ago