Install pg-aiguide for Claude Desktop
Claude Desktop reads mcpServers from claude_desktop_config.json. Restart the app after saving.
- Open ~/Library/Application Support/Claude/claude_desktop_config.json on macOS, %APPDATA%\Claude\claude_desktop_config.json on Windows, or ~/.config/Claude/claude_desktop_config.json on Linux.
- Paste the JSON config below.
- Replace placeholder secrets, then restart the client if it does not reload on its own.
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"timescale-pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide@0.6.1"
],
"env": {
"OPENAI_API_KEY": "YOUR_OPENAI_API_KEY",
"PGHOST": "YOUR_PGHOST",
"PGPORT": "YOUR_PGPORT",
"PGUSER": "YOUR_PGUSER",
"PGPASSWORD": "YOUR_PGPASSWORD",
"PGDATABASE": "YOUR_PGDATABASE",
"DB_SCHEMA": "YOUR_DB_SCHEMA"
}
}
}
}