1
claude mcp add postgres \
2
  --command docker \
3
  --args "run -i --rm -e DATABASE_URL postgres-mcp" \
4
  --env DATABASE_URL="postgresql://user:password@localhost:5432/mydb"

1
claude mcp add postgres \
2
  --env DATABASE_URL="postgresql://user:password@localhost:5432/mydb" \
3
  -- npx -y @modelcontextprotocol/server-postgres

1
claude mcp add neon \
2
  --transport http \
3
  neon https://mcp.neon.tech/YOUR_NEON_API_KEY/v1/mcp

1
$ claude "What's our MRR trend for the last 6 months?"
2

3
Agent:
4
  1. Inspects: subscriptions, payments tables
5
  2. Runs: SELECT date_trunc('month', created_at) as month,
6
            SUM(CASE WHEN status = 'active' THEN amount ELSE 0 END) as mrr
7
           FROM subscriptions
8
           WHERE created_at > NOW() - INTERVAL '6 months'
9
           GROUP BY 1 ORDER BY 1
10
  3. Returns: "MRR trend:
11
     Dec 2025: $42,150
12
     Jan 2026: $44,820 (+6.3%)
13
     Feb 2026: $47,300 (+5.5%)
14
     Mar 2026: $49,110 (+3.8%)
15
     Apr 2026: $52,440 (+6.8%)
16
     May 2026: $54,200 (partial month)"

1
$ claude "I need to build an API endpoint for user profiles.
2
   What does the database look like?"
3

4
Agent:
5
  1. Queries: list_tables → users, profiles, addresses, preferences
6
  2. Describes: users(id, email, created_at, status)
7
                profiles(user_id, display_name, avatar_url, bio)
8
  3. "The data model uses a 1:1 relationship between users and profiles.
9
     I'll generate the API endpoint with the correct joins."

1
$ claude "We just ran the schema migration. Verify the data integrity."
2

3
Agent:
4
  1. Compares: row counts before and after
5
  2. Checks: foreign key constraints, null percentages
6
  3. Validates: no orphaned records
7
  4. Reports: "Migration clean. 15,342 users migrated.
8
     0 orphaned profiles. All foreign keys valid."

1
$ claude "Find slow queries and suggest indexes"
2

3
Agent:
4
  1. Queries pg_stat_activity and pg_stat_statements
5
  2. Analyzes: "The `orders` table query filters by `status`
6
     but has no index on that column. Also, `user_email` lookups
7
     are doing sequential scans."
8
  3. Suggests: "Create these indexes:
9
     - CREATE INDEX idx_orders_status ON orders(status);
10
     - CREATE INDEX idx_users_email ON users(email);"

1
# Never! This connects with full write access
2
DATABASE_URL="postgresql://admin:super_secret@prod-db:5432/production"

1
# Create a read-only user first
2
CREATE USER mcp_reader WITH PASSWORD 'secure' LOGIN;
3
GRANT pg_read_all_data TO mcp_reader;
4

5
# Then use it
6
DATABASE_URL="postgresql://mcp_reader:secure@localhost:5432/mydb?sslmode=require"