Postgresql Mcp Ddz

@fanzhenddz

About Postgresql Mcp Ddz

PostgreSQL MCP Server

Config

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

{
  "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"
      }
    }
  }
}

Tools

No tools detected

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

FAQ from Postgresql Mcp Ddz

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.

Frequently asked questions

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.

Comments

Basic information

More Databases MCP servers

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

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