Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
https://mcp.tigerdata.com/docsnpx -y @tigerdata/pg-aiguide{
"OPENAI_API_KEY": "YOUR_SECRET_VALUE",
"PGHOST": "YOUR_SECRET_VALUE",
"PGPORT": "YOUR_SECRET_VALUE",
"PGUSER": "YOUR_SECRET_VALUE",
"PGPASSWORD": "YOUR_SECRET_VALUE",
"PGDATABASE": "YOUR_SECRET_VALUE",
"DB_SCHEMA": "YOUR_SECRET_VALUE"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-timescale-pg-aiguide": {
"command": "npx",
"args": [
"-y",
"@tigerdata/pg-aiguide"
],
"env": {
"OPENAI_API_KEY": "YOUR_SECRET_VALUE",
"PGHOST": "YOUR_SECRET_VALUE",
"PGPORT": "YOUR_SECRET_VALUE",
"PGUSER": "YOUR_SECRET_VALUE",
"PGPASSWORD": "YOUR_SECRET_VALUE",
"PGDATABASE": "YOUR_SECRET_VALUE",
"DB_SCHEMA": "YOUR_SECRET_VALUE"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
pg-aiguide is an MCP server for Comprehensive PostgreSQL documentation and best practices, including ecosystem tools. It supports STDIO, HTTP transport.
Use the generated config in Install. This server runs with npx -y @tigerdata/pg-aiguide; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install, copy the config, and add it to Claude Desktop's MCP server settings. Endpoint: https://mcp.tigerdata.com/docs.
Choose the Claude Code tab in Install, copy the config, and add it to Claude Code's MCP server settings. Endpoint: https://mcp.tigerdata.com/docs.
Choose the Codex tab in Install, copy the config, and add it to Codex's MCP server settings. Endpoint: https://mcp.tigerdata.com/docs.
Choose the Cursor or VS Code tab in Install, copy the config, and add it to Cursor or VS Code's MCP server settings. Endpoint: https://mcp.tigerdata.com/docs.
pg-aiguide uses STDIO, HTTP transport. Endpoint: https://mcp.tigerdata.com/docs.
pg-aiguide inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
pg-aiguide is marked with Auth required by registry metadata auth. You may need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
@tigerdata/pg-aiguidestdio | npm | 0.5.0 | Env: OPENAI_API_KEY required secret Env: PGHOST required secret Env: PGPORT required secret Env: PGUSER required secret Env: PGPASSWORD required secret Env: PGDATABASE required secret Env: DB_SCHEMA secret |
ghcr.io/timescale/pg-aiguide:0.5.0stdio | oci | Not captured | Env: OPENAI_API_KEY required secret Env: PGHOST required secret Env: PGPORT required secret Env: PGUSER required secret Env: PGPASSWORD required secret Env: PGDATABASE required secret Env: DB_SCHEMA secret |