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 Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412