mcp-postgres-query

MCP server that connects Claude to any PostgreSQL database. Explore schemas, run queries, analyze performance — all through natural conversation.

Built by THRYXAGI.

Install

npm install -g mcp-postgres-query

Or run directly:

npx mcp-postgres-query

Configuration

Set the DATABASE_URL environment variable with your PostgreSQL connection string:

DATABASE_URL=postgresql://user:password@localhost:5432/mydb

Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "mcp-postgres-query"],
      "env": {
        "DATABASE_URL": "postgresql://user:password@localhost:5432/mydb"
      }
    }
  }
}

Claude Code

Add to your .mcp.json:

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["-y", "mcp-postgres-query"],
      "env": {
        "DATABASE_URL": "postgresql://user:password@localhost:5432/mydb"
      }
    }
  }
}

Tools (7)

| Tool | Description | Params | |------|-------------|--------| | query | Execute a SQL query | sql (string), params (optional array) | | list_tables | List all tables in the public schema | none | | describe_table | Get column details (type, nullable, default) | table_name | | list_indexes | List indexes on a table | table_name | | explain_query | Get EXPLAIN ANALYZE plan (safe, rolls back) | sql | | get_table_stats | Row counts and table size | table_name | | get_db_info | Database overview (version, size, table count) | none |

Example Usage

Once connected, ask Claude things like:

• "What tables are in this database?"
• "Describe the users table"
• "SELECT * FROM orders WHERE created_at > '2024-01-01' LIMIT 10"
• "Explain this slow query: SELECT ..."
• "How big is the events table?"

Security Notes

• The query tool executes arbitrary SQL. Connect with a read-only database user for safety.
• The explain_query tool wraps EXPLAIN ANALYZE in a transaction that always rolls back, so it never modifies data.
• Parameterized queries are supported via the params argument to prevent SQL injection.
• Never expose DATABASE_URL in public repositories or logs.

License

MIT