How do I install the mcp pg schema mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

SSyncDev

Start a project

MCP Pg Schema MCP Server

MCP server for getting schema information from a PostgreSQL database

Local serverstdio

What is the MCP Pg Schema MCP Server?

MCP Pg Schema connects MCP Pg Schema to AI assistants that speak the Model Context Protocol. MCP server for getting schema information from a PostgreSQL database.

What MCP Pg Schema does

A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

Practical notes

Maintained by vinsidious.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
query	Execute read-only SQL queries against the connected database

How to install the MCP Pg Schema MCP Server

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run", 
        "-i", 
        "--rm", 
        "mcp/postgres", 
        "postgresql://host.docker.internal:5432/mydb"]
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Example prompts to try

“Use MCP Pg Schema to query.”
“Use MCP Pg Schema to Input.”
“Use MCP Pg Schema to Tools.”

Frequently asked questions

MCP server for getting schema information from a PostgreSQL database Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.