关于
The PostgreSQL MCP Server acts as a secure intermediary, seamlessly connecting Claude Code with your PostgreSQL databases. Designed with a security-first approach, it empowers AI agents to perform extensive database exploration and analysis without the risk of data modification. Developers can leverage its capabilities to list databases, explore schemas, describe tables, execute read-only queries, and analyze query performance, making it an indispensable tool for AI-driven data insights, reporting, and development workflows within the Claude Code environment.
主要功能
- Execute read-only SQL queries (SELECT and WITH statements only)
- Explore database schemas, including databases, schemas, tables, and columns
- Analyze query performance using execution plans (EXPLAIN QUERY)
- Retrieve detailed table statistics (row count, size, indexes)
- Security-first design with parameterized queries and connection validation
- 0 GitHub stars
使用案例
- Integrating secure PostgreSQL database access into Claude Code projects
- Enabling AI agents to explore database schemas and metadata for data understanding
- Executing read-only SQL queries and analyzing performance within an AI development workflow