Set up PostgreSQL MCP in Continue

Query and interact with PostgreSQL databases, inspect schemas, and run SQL directly from your AI editor.

Locate the config file

Continue reads MCP server configuration from the following file:

~/.continue/config.yaml

Create this file if it does not already exist.

Add the configuration

Add the following to your Continue config file:

yaml

mcpServers:
  - name: postgres-mcp
    command: npx
    args:
      - -y
      - @modelcontextprotocol/server-postgres
      - postgresql://localhost/mydb
    env:
      POSTGRES_CONNECTION_STRING: YOUR_POSTGRES_CONNECTION_STRING

Set up environment variables

PostgreSQL MCP requires the following environment variables:

POSTGRES_CONNECTION_STRINGRequired

PostgreSQL connection string (e.g. postgresql://user:pass@localhost:5432/mydb)

Verify it works

Restart Continue. PostgreSQL MCP should appear in your MCP server list with 8 tools available.

This server adds approximately 4,120 tokens to your context window for tool definitions.

Set up PostgreSQL MCP in other editors

Claude Code Cursor VS Code Windsurf Claude Desktop

← Back to PostgreSQL MCP