Advertise
MCP.so
Sign In
P

Postgresql MCP Ddz

@fanzhenddz

Repository

Basic information

Category

Databases

Transports

stdio

Author

fanzhenddz

Submitted by

Z DD

About Postgresql MCP Ddz

PostgreSQL MCP Server

#postgresql

Postgresql MCP Ddz 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"
      }
    }
  }
}

Postgresql MCP Ddz tools

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)

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

Frequently asked questions

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.

Comments

More Databases MCP servers

Postgres Mcp

crystaldba

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

3.0K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Chroma MCP Server

chroma-core

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

569

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637
Advertise