Advertise
MCP.so
Sign In

PostgreSQL MCP Server (MCP)

@VivekMalipatel

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

VivekMalipatel

About PostgreSQL MCP Server

FastMCP Based MCP Server to Control Postgres

#postgresql#mcp#database#ai-integration

PostgreSQL MCP Server config

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

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

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

Frequently asked questions

1

What transport does PostgreSQL MCP Server use?

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

2

What are the runtime requirements?

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

3

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.

4

What dependencies are required?

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

5

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K
Advertise