MCP.so
Sign In

PostgreSQL MCP Server (Model Context Protocol)

@VivekMalipatel

Repository

About PostgreSQL MCP Server (Model Context Protocol)

FastMCP Based MCP Server to Control Postgres

#postgresql#mcp#database#ai-integration

Basic information

Category

Databases

License

MIT

Runtime

python

Transports

stdio

Publisher

VivekMalipatel

Config

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

{
  "mcpServers": {
    "Postgres_MCP_Server": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        ".mcp"
      ]
    }
  }
}

Tools

No tools detected

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 Server?

A FastMCP-powered Model Context Protocol server that gives AI assistants (Claude, Cursor, etc.) full, structured access to a PostgreSQL database — no SQL knowledge required from the user.

How to use PostgreSQL MCP Server?

Clone the repository, create a virtual environment, install dependencies from requirements.txt, and configure a .env file with database credentials. Then connect an MCP-compatible client (e.g., Claude Desktop) by adding the provided JSON block to its MCP config file. Alternatively, run manually with python postgres_mcp_server.py.

Key features of PostgreSQL MCP Server

  • Exposes database as MCP Resources (read-only) and MCP Tools (read/write)
  • Parameterised queries throughout — no SQL injection
  • Structured stdout logs on every tool/resource call
  • Schema inspection: list tables, column definitions
  • Read/write/DDL operations via tools
  • Raw SQL execution via the execute_query tool

Use cases of PostgreSQL MCP Server

  • AI assistant querying database in natural language
  • Automated schema exploration and data preview
  • Performing insert, update, delete operations through conversational interface
  • Creating and dropping tables via AI assistant

FAQ from PostgreSQL MCP Server

What transport does PostgreSQL MCP Server use?

The server uses stdio transport (MCP protocol over standard input/output).

What are the runtime requirements?

Python 3.8+ and a PostgreSQL server (local or remote) with the uv package runner (recommended) or pip.

How are database credentials configured?

Via a .env file with POSTGRES_HOST, POSTGRES_PORT, POSTGRES_DB, POSTGRES_USER, and POSTGRES_PASSWORD, or directly in the client config's env block.

What dependencies are required?

mcp[cli], asyncpg, psycopg2-binary, python-dotenv, httpx, uvicorn, and uv.

What are the limits on data access?

The postgres://data/{table_name} resource returns only the first 100 rows as a safe preview. Other tools allow configurable limits.

Comments

More Databases MCP servers

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

MongoDB Lens

furey

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

204

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K