Postgres Multi-Schema

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.