HarjjotSinghh_mcp-server-postgres-multi-schema
If you are the rightful owner of HarjjotSinghh_mcp-server-postgres-multi-schema and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol server providing read-only access to PostgreSQL databases with enhanced multi-schema support.
The PostgreSQL Multi-Schema MCP Server is designed to facilitate read-only access to PostgreSQL databases, with a focus on supporting multiple schemas. This server allows Language Model Models (LLMs) to explore database schemas across various namespaces and execute read-only queries while ensuring schema isolation. By explicitly specifying which schemas to expose, the server maintains strict access control, ensuring that only authorized schemas are accessible. It offers a unified view of tables across multiple schemas, while still respecting schema boundaries, and filters system catalogs to only reveal user-defined tables within the specified schemas. This makes it an ideal solution for environments where data security and schema isolation are paramount.
Features
- Multi-Schema Support: Allows explicit specification of schemas to expose through command-line configuration.
- Schema Isolation: Ensures strict access control to only authorized schemas listed during server startup.
- Cross-Schema Discovery: Provides a unified view of tables across multiple schemas while maintaining schema boundaries.
- Metadata Security: Filters system catalogs to expose only user-defined tables in specified schemas.
- Read-Only Transactions: All queries are executed within a READ ONLY transaction to ensure data integrity.
Tools
query
Execute read-only SQL queries against the connected database.