Advertise
MCP.so
Sign In

PostgreSQL Multi-Schema MCP Server

@HarjjotSinghh

RepositoryHomepage

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

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

PostgreSQL Multi-Schema 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"
      ]
    }
  }
}

PostgreSQL Multi-Schema MCP Server tools

1

Run a read-only SQL query

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

Frequently asked questions

1

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.

2

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.

3

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.

4

Does the server expose system tables?

No. The server filters system catalogs to expose only user-defined tables in the authorized schemas.

5

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

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Elasticsearch MCP Server

elastic

685
Advertise