PostgreSQL MCP Server (Model Context Protocol)

Name: PostgreSQL MCP Server (Model Context Protocol)
Author: VivekMalipatel

@VivekMalipatel

代码仓库

关于 PostgreSQL MCP Server (Model Context Protocol)

FastMCP Based MCP Server to Control Postgres

#postgresql #mcp #database #ai-integration

基本信息

分类

数据库

许可证

MIT

运行时

python

传输方式

stdio

发布者

VivekMalipatel

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.