PgProd
0
Provides secure, read-only access to PostgreSQL databases via an SSH tunnel, enforcing query timeouts and connection pooling.
About
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.
Key Features
- 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.
Use Cases
- 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.