广告合作
MCP.so
登录
M

MCP Server for PostgreSQL

@JaviMaligno

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

JaviMaligno

提交者

JaviMaligno

关于 MCP Server for PostgreSQL

MCP server with 14 tools for PostgreSQL database operations. Query databases, explore schemas, analyze tables, list indexes/constraints, and get performance statistics. Features security-first design with SQL injection prevention and read-only mode by default. Works with Claude D

#postgresql#database#sql#mcp

MCP Server for PostgreSQL 配置

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

{
  "mcpServers": {
    "postgres": {
      "command": "postgresql-mcp",
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "your-user",
        "POSTGRES_PASSWORD": "your-password",
        "POSTGRES_DB": "your-database"
      }
    }
  }
}

MCP Server for PostgreSQL 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

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

概览

What is MCP Server for PostgreSQL?

MCP Server for PostgreSQL is a Model Context Protocol server that enables AI assistants to interact with PostgreSQL databases. It provides tools for query execution, schema exploration, performance analysis, and documentation generation, and it works with any MCP-compatible client such as Claude Code or Claude Desktop.

How to use MCP Server for PostgreSQL?

Install via pipx install postgresql-mcp or pip install postgresql-mcp. Configure by setting environment variables like POSTGRES_HOST, POSTGRES_USER, POSTGRES_PASSWORD, and POSTGRES_DB (with POSTGRES_PORT, POSTGRES_SSLMODE, ALLOW_WRITE_OPERATIONS, QUERY_TIMEOUT, and MAX_ROWS as optional). Then add to a client using a command like claude mcp add postgres -s user -e ... -- postgresql-mcp.

Key features of MCP Server for PostgreSQL

  • Execute read‑only SQL queries by default (write operations optional)
  • Explore schemas, tables, views, and functions
  • Describe table structure, indexes, and constraints
  • Get EXPLAIN plans and table statistics
  • SQL injection prevention and credential protection
  • Browsable database structure as MCP resources

Use cases of MCP Server for PostgreSQL

  • Ask an AI assistant to list all tables in a schema or describe a table’s structure
  • Run read‑only queries against a production database without risk of data modification
  • Analyze query performance with EXPLAIN plans and table health statistics
  • Generate a data dictionary or documentation for a database schema

常见问题

1

Is the server read‑only by default?

Yes. Write operations (INSERT, UPDATE, DELETE) are blocked unless the `ALLOW_WRITE_OPERATIONS` environment variable is set to `true`.

2

What are the runtime dependencies?

Python 3.10 or later is required. For development, `uv` and a PostgreSQL instance are needed; production use only needs the installed package.

3

Where is the database data stored?

Data remains in the PostgreSQL database that the server connects to. The server does not store any data locally.

4

Are there any limits on query results?

Yes. By default, a maximum of 1000 rows is returned (`MAX_ROWS`), and queries time out after 30 seconds (`QUERY_TIMEOUT`). These can be configured via environment variables.

5

How does authentication work?

The server connects to PostgreSQL using credentials provided as environment variables (`POSTGRES_USER`, `POSTGRES_PASSWORD`). Passwords are stored using Pydantic’s `SecretStr` and never appear in logs or error messages.

评论

数据库 分类下的更多 MCP 服务器

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

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

NPILayer

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637
广告合作