MCP Solutions

PostgreSQL

Active

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.

Updated 8/2/2025
Key Features

What makes this MCP server special

Query database
Readonly mode

Requirements

Docker
NPX
Server Information

Status

Active

Version

1.0.0

License

MIT

Author

modelcontextprotocol

Installation Guide
Get started with this MCP server in minutes

1. Install the Package

-

2. Configuration

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

3. Usage Example

Query database table X