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.