PostgreSQL Gateway

关于

The PostgreSQL Gateway acts as a secure intermediary, providing AI agents like Claude Code, Cursor, and VS Code with controlled, read-only access to PostgreSQL databases. It implements the Model Context Protocol (MCP) to standardize interaction, ensuring that AI agents can safely explore database schemas and execute SQL queries without risk of data modification. With features like API key authentication, rate limiting, SQL validation, and automatic row limiting, the gateway offers a robust solution for integrating AI-powered development tools with your relational data sources.

主要功能

• Automatic truncation of large query results (row limiting)
• Search database objects (schemas, tables, columns, indexes, procedures)
• Enforced read-only mode at both SQL parser and PostgreSQL levels
• Execute read-only SQL queries (SELECT, WITH, EXPLAIN, SHOW)
• 0 GitHub stars
• Secure API Key authentication for access control

使用案例

• Connecting AI coding assistants (e.g., Claude Code, Cursor) to PostgreSQL for schema exploration and data retrieval.
• Providing controlled, read-only database access to large language models for data analysis or application development tasks.
• Integrating PostgreSQL database querying capabilities directly into development environments like VS Code via AI agents.