Any MCP client that can launch a stdio server can connect Cursor-style to PostgreSQL through pREST. Point the client at prest-mcp and set PREST_MCP_URL to your /_mcp endpoint.
Requires pREST v2.1.0+ and the pREST MCP Adapter.
PREST_MCP_URL=http://localhost:3000/_mcp prest-mcpOr in client config JSON:
{
"mcpServers": {
"prest": {
"command": "prest-mcp",
"env": {
"PREST_MCP_URL": "http://localhost:3000/_mcp"
}
}
}
}Optional: PREST_MCP_TOKEN, PREST_MCP_TIMEOUT_MS (default 30000). See Install pREST MCP Adapter.
Prefer a read-only PostgreSQL role for agent access.
VS Code uses a different MCP JSON shape (servers with "type": "stdio", typically in .vscode/mcp.json). Full walkthrough: Use with VS Code and Copilot.
Install the official plugin from ClawHub:
Wire MCP with prest-mcp and PREST_MCP_URL as in the generic pattern above. Full guide: pREST for OpenClaw plugin.
In Cline’s MCP settings, add a stdio server with:
Command: prest-mcp (or absolute path)
Env: PREST_MCP_URL=http://localhost:3000/_mcp
Reload MCP servers after saving. Ask Cline to list databases or describe a table to confirm tools appear.
Add an MCP server entry in Continue’s config (shape varies by Continue version). Typical fields:
Command / args launching prest-mcp
Environment with PREST_MCP_URL
If Continue cannot resolve Homebrew binaries, use /opt/homebrew/bin/prest-mcp or /usr/local/bin/prest-mcp.
Configure Windsurf’s MCP / Cascade server list the same way as other stdio clients: command prest-mcp, env PREST_MCP_URL. Restart the IDE after changes.
When you do not want a host binary:
If your client can call MCP over HTTP directly, you may not need the adapter. Point it at http://localhost:3000/_mcp (or your deployed URL) and send the same auth headers as REST. Protocol details: MCP over HTTP.
Process exits immediately
Set PREST_MCP_URL
Spawn / PATH errors
Use an absolute path to prest-mcp
Empty tools
Confirm curl discovery; check permissions
Auth errors
Set PREST_MCP_TOKEN
Last updated
openclaw plugins install clawhub:@prest/prest-openclaw{
"mcpServers": {
"prest": {
"command": "docker",
"args": [
"run",
"--rm",
"-i",
"-e",
"PREST_MCP_URL=http://host.docker.internal:3000/_mcp",
"ghcr.io/prest/prest-mcp-adapter:0.1.3"
]
}
}
}