mcp-server-postgres-multi-schema
If you are the rightful owner of 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 that provides 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, specifically focusing on environments with multiple schemas. It allows Language Model Models (LLMs) to inspect and query database schemas across various namespaces while ensuring schema isolation. This server is particularly useful for applications that require a unified view of tables across different schemas without compromising on security and access control. By maintaining strict schema isolation and providing cross-schema discovery, it ensures that only authorized schemas are accessible, and metadata security is upheld by filtering system catalogs to expose only user-defined tables.
Features
- Multi-Schema Support: Explicitly specify which schemas to expose through command-line configuration.
- Schema Isolation: Strict access control to only authorized schemas listed during server startup.
- Cross-Schema Discovery: Unified view of tables across multiple schemas while maintaining schema boundaries.
- Metadata Security: Filters system catalogs to only expose user-defined tables in specified schemas.
Tools
query
Execute read-only SQL queries against the connected database. Input:
sql(string): The SQL query to execute. All queries are executed within a READ ONLY transaction. Schema context maintained through search_path restriction.
