Other AI tools
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.
Generic stdio pattern
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 / GitHub Copilot
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.
OpenClaw
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.
Cline
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.
Continue
Add an MCP server entry in Continue’s config (shape varies by Continue version). Typical fields:
Command / args launching
prest-mcpEnvironment with
PREST_MCP_URL
If Continue cannot resolve Homebrew binaries, use /opt/homebrew/bin/prest-mcp or /usr/local/bin/prest-mcp.
Windsurf
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.
Docker as the command
When you do not want a host binary:
HTTP-native clients
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.
Troubleshooting
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
Next steps
Last updated