pgembed

Run PostgreSQL locally without installing it: named instances of any version in the background, SQL with readable results and errors, schema inspection, SQL formatting, and an MCP server for AI assistants.

Installation

MCP client config (paste into mcp.json)

{
  "mcpServers": {
    "mysticmind-pgembed-cli-npm-pgembed": {
      "command": "npx",
      "args": [
        "-y",
        "pgembed"
      ]
    }
  }
}

Agent install prompt

Copy and paste into Cursor / Claude / other agents to install this MCP for you

Please read this MCP repository and install it into my current environment:
https://github.com/mysticmind/pgembed-cli/tree/main/npm/pgembed

Known working client config (can write into mcp.json):
{
  "mcpServers": {
    "mysticmind-pgembed-cli-npm-pgembed": {
      "command": "npx",
      "args": [
        "-y",
        "pgembed"
      ]
    }
  }
}

Please: 1) check README for deps and env vars; 2) write config for my client; 3) if secrets are missing, tell me what to fill — do not invent values.

GitHub

Related servers