P

Postgres MCP

Query Postgres with schema-aware natural language

Anthropic·No reviews yet
Repo
Share:

About

Query and manage PostgreSQL databases through natural language. Runs read-only or read-write SQL against your database, inspects schemas, lists tables and columns, and returns results as structured data. Ideal for exploration, ad-hoc analytics, and letting the assistant understand your data model before writing application code.

Example tools

Illustrative tool names — the actual tool set is defined by the server at runtime.

query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table

Screenshots

No screenshots yet.

Install Postgres MCP

Claude Desktop

Add this to claude_desktop_config.json.

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

Cursor

Add this to ~/.cursor/mcp.json.

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

VS Code

Add this to your workspace settings.json.

{
  "mcp.servers": {
    "postgres": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres"
      ]
    }
  }
}

Reviews

Sign in to leave a review.

No reviews yet. Be the first!

Discussion(0)

Sign in to join the discussion.

No comments yet.