Connects Claude directly to your PostgreSQL databases with the essentials: run queries, inspect schema structure, check query plans with EXPLAIN, and ping database health. Useful when you want Claude to help debug slow queries, explore unfamiliar table structures, or write SQL against your actual schema without copy-pasting DDL back and forth. The stdio transport means it runs locally, keeping your database credentials on your machine. Straightforward tool for anyone who spends time in Postgres and wants an AI that can see what you're working with.
claude mcp add --transport stdio io.github.yawlabs-postgres-mcp uvx postgres-mcp