PostgreSQL Multi-Schema MCP Server

@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

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.

Frequently asked questions

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

Basic information

More Databases MCP servers

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi