Advertise
MCP.so
Sign In
P

Postgresql MCP Server

@prasanna00019

Repository

Basic information

Category

Databases

Transports

stdio

Author

prasanna00019

Submitted by

Prasanna H

About Postgresql MCP Server

## Overview

#database

Postgresql MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "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"
      }
    }
  }
}

Postgresql MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Postgresql Mcp?

Postgresql Mcp is an MCP server that delivers intelligent analysis, documentation, and complete CRUD operations for PostgreSQL databases. It combines deterministic schema extraction with AI-powered reasoning and secure data manipulation, enabling users and AI agents to understand and interact with complex database structures.

How to use Postgresql Mcp?

The server exposes 27 tools covering all PostgreSQL operations. Use an MCP client (e.g., Claude Desktop) to connect and invoke tools for schema extraction, query analysis, data management, and monitoring.

Key features of Postgresql Mcp

  • Comprehensive Coverage: 27 tools for all PostgreSQL operations
  • Schema Extraction: Automatically extract tables, columns, and constraints
  • Intelligent Analysis: Detect junction tables and suggest optimal joins
  • AI-Powered Insights: Generate business explanations via Ollama/LLM
  • Complete CRUD Operations: With SQL injection prevention
  • Query Optimization: Execution plan and index analysis
  • Multiple Output Formats: Mermaid diagrams, SVG, PNG, PDF, Markdown

Use cases of Postgresql Mcp

  • Document an existing PostgreSQL database schema automatically
  • Optimize slow queries through execution plan and index analysis
  • Perform safe, parameterized data operations across tables
  • Monitor database statistics, cache metrics, and connection usage
  • Generate visual ER diagrams and relationship flowcharts

Frequently asked questions

1

How many tools does Postgresql Mcp provide?

The server started with 38 tools, was optimized to 19, and then extended to 27 high-value tools covering query optimization, data management, transactions, and monitoring.

2

What security measures are in place?

All CRUD operations use parameterized queries and input validation to prevent SQL injection.

3

Does Postgresql Mcp support transactions?

Yes, it supports atomic multi-operation transactions with rollback capabilities.

4

What output formats are available for diagrams?

Output includes Mermaid ER diagrams, relationship flowcharts, and rendered files in SVG, PNG, PDF, and Markdown.

5

How does AI-powered analysis work?

The server leverages Ollama or another LLM to generate business explanations and recommendations from database schemas and query results.

Comments

More Databases MCP servers

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Elasticsearch MCP Server

elastic

685

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569
Advertise