PostgreSQL (reference, archived)

§1What it does

The original reference PostgreSQL server provides read-only queries and table schema resources. It has been moved to the servers-archived repo and is no longer maintained, so consider DBHub or a vendor server for new projects.

§2Setup

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/server-postgres", "postgresql://localhost/mydb"]
    }
  }
}

Snippets adapted from the official documentation. Check the official page for current options and auth requirements.

§3Prompts to try

1. “How many users signed up last month?”Copy
2. “Describe the schema of the orders table.”Copy