Database MCP servers for PostgreSQL and CrateDB

Overview

Popular MCP servers that can connect to both PostgreSQL and CrateDB, alphabetically sorted.

• CrateDB MCP

• DBHub

• MCP Alchemy

• PG-MCP

• PostgreSQL basic

• Quarkus JDBC

See also

Detailed MCP API capabilities about all of them, regarding available prompts, resources, and tools, can be explored on the MCP server landscape for PostgreSQL and CrateDB page. Ready-to-run example programs are available per example collection about exploring MCP with CrateDB.

Install

The uv package manager is the tool of choice to install MCP servers written in Python across the board. Please ensure it is installed on the machine where you are invoking the MCP server.

Claude Desktop

MCP servers are configured within the mcpServers section of your claude_desktop_config.json configuration file. A CrateDB configuration for MCP Alchemy that will automatically install the required packages looks like this:

{
  "mcpServers": {
    "my_cratedb": {
      "command": "uvx",
      "args": ["--with", "sqlalchemy-cratedb>=0.42.0.dev2", "mcp-alchemy"],
      "env": {
        "DB_URL": "crate://crate@localhost:4200/?schema=testdrive"
      }
    }
  }
}

If you provided required packages upfront, the incantation snippet is slightly different.

uv pip install 'mcp-alchemy' 'sqlalchemy-cratedb>=0.42.0.dev2'

{
  "mcpServers": {
    "my_cratedb": {
      "command": "mcp-alchemy",
      "args": [],
      "env": {
        "DB_URL": "crate://crate@localhost:4200/?schema=testdrive"
      }
    }
  }
}

For connecting to CrateDB Cloud, use a URL like crate://user:password@example.aks1.westeurope.azure.cratedb.net:4200?ssl=true.