Windsurf pg aiguide Prompt/design-postgres-tables

How to: Windsurf pg aiguide design-postgres-tables

client:Windsurf transport:streamable-http prompt:design-postgres-tables

Add pg aiguide to Windsurf

01
Open ~/.codeium/windsurf/mcp_config.json and merge this in. Keep any servers already there.

{
  "mcpServers": {
    "pg-aiguide": {
      "serverUrl": "https://mcp.tigerdata.com/docs"
    }
  }
}

02
Save the file and restart Windsurf.
03
design-postgres-tables is surfaced in the client's prompt or command menu. Unlike a tool, you invoke it deliberately — Windsurf will not call it for you.
04
If it does not appear, check that pg aiguide is connected and that you are looking at its prompts rather than its tools.

Global only — Windsurf has no per-project MCP config. Refresh Cascade after saving. Windsurf docs

Set these first

pg aiguide will not start until these are set, so it never reaches Windsurf.

OPENAI_API_KEY
PGHOST
PGPORT
PGUSER
PGPASSWORD
PGDATABASE
DB_SCHEMA

Same prompt, other clients

Read from the server itself, by connecting to it and calling prompts/list on 24 September 2026. A listing does not declare its prompts, so asking is the only way to know them, and this is what the server actually offers rather than what its listing claims. Names only are stored; connect the server for each prompt's arguments.

pg aiguide MCP server