PgProd

소개

PgProd is a robust Model Context Protocol (MCP) server designed to offer secure, read-only access to PostgreSQL databases. It establishes connections through encrypted SSH tunnels, ensuring data privacy and integrity. The server enforces read-only transactions, implements efficient connection pooling, and includes a 15-second query timeout to prevent runaway operations. It provides a comprehensive suite of tools for querying, schema inspection, data analysis, and relationship discovery, making it ideal for controlled database interaction without risking data modification.

주요 기능

• 0 GitHub stars
• Comprehensive tools for SQL querying, table listing, and schema description.
• Strict read-only transaction enforcement for all queries.
• Secure SSH Tunneling for encrypted database connections.
• Efficient database connection pooling and 15-second query timeouts.
• Robust shared SSH tunnel management with automatic reconnection.

사용 사례

• Enabling safe schema inspection and data querying for developers on production environments.
• Integrating secure, limited database access into applications or services requiring data insights without write capabilities.
• Providing controlled, read-only access to PostgreSQL databases for analytical tools or reporting.