Postgres MCP Server

An MCP (Model Context Protocol) server that gives Claude Code direct access to your PostgreSQL database. Enables schema exploration, safe query execution, and AI-powered migration generation directly from your Claude Code environment.

Features

• Schema introspection — list tables, columns, indexes, and constraints
• Safe query execution — read-only queries with configurable timeout
• Migration generation — generate SQL migrations from natural language descriptions
• Connection pooling — efficient connection management via pg-pool

Security

• All queries run inside a read-only transaction by default
• Write operations require explicit --allow-writes flag
• Connection strings are never logged or exposed

Available Tools

Tool	Description
list_tables	List all tables in the database
describe_table	Get column details for a table
run_query	Execute a read-only SQL query
generate_migration	Generate a migration from a natural language description

Configuration

Add to your Claude Code MCP settings:

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