PostgreSQL Multi-Schema MCP Server

Name: PostgreSQL Multi-Schema MCP Server
Author: HarjjotSinghh

@HarjjotSinghh

About 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

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

Execute read-only SQL queries against the connected database

Overview

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.

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.

Comments

More Databases MCP servers

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245