广告合作
MCP.so
登录
P

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

7

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

常见问题

1

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.

2

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.

3

What is the runtime requirement for Postgresql Mcp Ddz?

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

4

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.

5

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 服务器

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

广告合作