PostgreSQL Multi-Schema MCP Server

@HarjjotSinghh

代码仓库主页

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

HarjjotSinghh

关于 PostgreSQL Multi-Schema MCP Server

A Model Context Protocol server that provides read-only access to PostgreSQL databases with enhanced multi-schema support.

#postgres #mcp #postgresql #model-context-protocol #mcp-server

PostgreSQL Multi-Schema MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-server-postgres-multi-schema": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-postgres-multi-schema",
        "postgresql://localhost/mydb"
      ]
    }
  }
}

PostgreSQL Multi-Schema MCP Server 工具

Run a read-only SQL query

概览

What is PostgreSQL Multi-Schema MCP Server?

A Model Context Protocol server that provides read-only access to PostgreSQL databases with enhanced multi-schema support. It allows LLMs to inspect database schemas across multiple namespaces and execute read-only queries while maintaining schema isolation.

How to use PostgreSQL Multi-Schema MCP Server?

Run the server via npx -y mcp-server-postgres-multi-schema <database-url> [schemas], where schemas is an optional comma-separated list (defaults to public). For Claude Desktop, add an entry to claude_desktop_config.json under mcpServers with the command and arguments.

Key features of PostgreSQL Multi-Schema MCP Server

Multi-schema support via command-line configuration
Schema isolation with strict access control
Cross-schema discovery with unified table view
Metadata security filtering system catalogs
Read-only query execution within READ ONLY transactions
Automatic table schema discovery per authorized schema

Use cases of PostgreSQL Multi-Schema MCP Server

Let an LLM browse and query databases with multiple schemas (e.g., public, analytics, staging)
Provide read-only database access for AI assistants without write risk
Enable cross-schema data discovery for documentation or analysis
Use in Claude Desktop to interact with PostgreSQL data via natural language

常见问题

What schemas does the server expose?

The server exposes only the schemas specified via the command-line argument. If none are given, it defaults to the `public` schema.

What type of queries can I execute?

Only read‑only SQL queries are allowed. All queries run inside a `READ ONLY` transaction, preventing any writes.

How do I configure the server with Claude Desktop?

Add an `mcpServers` entry in `claude_desktop_config.json` with command `npx -y mcp-server-postgres-multi-schema` and arguments including the database URL and optional schema list.

Does the server expose system tables?

No. The server filters system catalogs to expose only user-defined tables in the authorized schemas.

Is the server limited to a single schema?

No. You can pass a comma-separated list of schemas (e.g., `public,analytics,staging`) to access multiple namespaces.

数据库分类下的更多 MCP 服务器

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl