Postgres Multi-Schema
Enables read-only access to PostgreSQL databases with enhanced multi-schema support for Model Context Protocol.
About
This Model Context Protocol server provides a secure, read-only interface to PostgreSQL databases, emphasizing multi-schema support. It allows Large Language Models (LLMs) to inspect database schemas across multiple namespaces and execute read-only queries while maintaining schema isolation. By explicitly specifying which schemas to expose during server configuration, it ensures strict access control and a unified view of tables across different schemas.
Key Features
- Multi-Schema Support: Expose specific schemas through command-line configuration.
- Schema Isolation: Restrict access to authorized schemas only.
- Metadata Security: Filter system catalogs to only expose user-defined tables in specified schemas.
- Read-Only Queries: Execute SQL queries within a READ ONLY transaction.
- 2 GitHub stars
- Cross-Schema Discovery: Provide a unified view of tables across multiple schemas.
Use Cases
- Provide a unified view of tables across different schemas for data exploration.
- Allow LLMs to inspect database schemas across multiple namespaces in a secure manner.
- Enable read-only querying across multiple database schemas while maintaining isolation.
Sponsored