Postgresql MCP Ddz

@fanzhenddz

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

fanzhenddz

提交者

Z DD

关于 Postgresql MCP Ddz

PostgreSQL MCP Server

#postgresql

Postgresql MCP Ddz 配置

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

{
  "mcpServers": {
    "postgresql-mcp-ddz": {
      "command": "npx",
      "args": [
        "postgresql-mcp-ddz"
      ],
      "env": {
        "POSTGRES_HOST": "127.0.0.1",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "postgres",
        "POSTGRES_PASSWORD": "your_password",
        "POSTGRES_DB": "your_database"
      }
    }
  }
}

Postgresql MCP Ddz 工具

Connect to a PostgreSQL database

Execute a SELECT query and return results

Execute an INSERT, UPDATE, or DELETE query

List all tables in the database

Get the structure of a specific table

Analyze SQL query performance using EXPLAIN

Execute a SHOW statement (e.g., SHOW STATUS, SHOW VARIABLES)

概览

What is Postgresql Mcp Ddz?

Postgresql Mcp Ddz is a PostgreSQL database operation server built on the Model Context Protocol (MCP). It enables AI assistants to interact with PostgreSQL databases through a standardized interface, supporting query execution, data modification, schema inspection, and performance analysis.

How to use Postgresql Mcp Ddz?

Install with npm install postgresql-mcp-ddz or run directly via npx postgresql-mcp-ddz. Configure automatic database connection by setting environment variables (POSTGRES_HOST, POSTGRES_PORT, POSTGRES_USER, POSTGRES_PASSWORD, POSTGRES_DB) in your MCP client, or use the connect_db tool to connect manually. Once connected, invoke tools like query, execute, list_tables, describe_table, explain, and show_statement to interact with the database.

Key features of Postgresql Mcp Ddz

Execute parameterized SELECT queries
Perform INSERT, UPDATE, and DELETE operations
List database tables and view table structures
Analyze query performance with EXPLAIN
Supports both environment variable and manual connection

Use cases of Postgresql Mcp Ddz

AI assistants querying live PostgreSQL databases
Automated data entry and modification workflows
Schema exploration for database documentation
Performance tuning by analyzing query plans

常见问题

What is the difference between the `query` and `execute` tools?

`query` executes SELECT, SHOW, EXPLAIN, and WITH statements only. `execute` handles INSERT, UPDATE, and DELETE operations.

How do I connect to a database?

Set `POSTGRES_HOST`, `POSTGRES_PORT`, `POSTGRES_USER`, `POSTGRES_PASSWORD`, and `POSTGRES_DB` environment variables for automatic connection, or use the `connect_db` tool with the same parameters.

What is the runtime requirement for Postgresql Mcp Ddz?

It requires Node.js and npm (or npx) to install and run the server.

How are database credentials protected?

Credentials are passed only at runtime via environment variables or the `connect_db` tool parameters; the server does not persist them.

Can I use this server without environment variables?

Yes. Omit the environment variables and use the `connect_db` tool manually to connect each session.

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

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Chroma MCP Server

chroma-core

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

569

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

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