Enables read-only access to PostgreSQL databases with enhanced multi-schema support for Model Context Protocol.
Sponsored
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
01Multi-Schema Support: Expose specific schemas through command-line configuration.
02Schema Isolation: Restrict access to authorized schemas only.
03Metadata Security: Filter system catalogs to only expose user-defined tables in specified schemas.
04Read-Only Queries: Execute SQL queries within a READ ONLY transaction.
052 GitHub stars
06Cross-Schema Discovery: Provide a unified view of tables across multiple schemas.
Use Cases
01Provide a unified view of tables across different schemas for data exploration.
02Allow LLMs to inspect database schemas across multiple namespaces in a secure manner.
03Enable read-only querying across multiple database schemas while maintaining isolation.
