PostgreSQL Multi-Schema MCP Server

Name: PostgreSQL Multi-Schema MCP Server
Author: HarjjotSinghh

@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

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

node

トランスポート

stdio

公開者

HarjjotSinghh

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

Execute read-only SQL queries against the connected database

概要

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

FAQ from PostgreSQL Multi-Schema MCP Server

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.