postgres

Provides direct PostgreSQL database access for queries, schema inspection, and data manipulation via DATABASE_URL connection string. Runs locally as a subprocess.

PostgreSQL

database

Add to Your Project

Copy this JSON into your .mcp.json to enable this server

Add to your .mcp.json:

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres@latest"
      ],
      "env": {
        "POSTGRES_CONNECTION_STRING": "${POSTGRES_CONNECTION_STRING}"
      }
    }
  }
}

Security Considerations

Review these signals before enabling this server

External connections

This server connects to external services. Review the URLs it accesses before enabling.

Details

Server configuration and connection parameters

Commandnpx

Access Levelwrite

Arguments

Command-line arguments passed to the server process

-y@modelcontextprotocol/server-postgres@latest

Environment Variables

Environment variables set when the server starts

POSTGRES_CONNECTION_STRING=${POSTGRES_CONNECTION_STRING}

Capabilities

Declared capabilities of this MCP server

data

Stats

LanguageJavaScript

Parent stars24

Parent forks3

MaintenanceExcellent

Last CommitJul 19, 2026

Actions

Stats

Actions