MCP server
Pg Aiguide
Comprehensive PostgreSQL documentation and best practices, including ecosystem tools
- Pricing
- Open source
- Runs
- Locally or Remotely
- Version
- 0.6.1
- Listing updated
- 5 days ago
About Pg Aiguide
Pg Aiguide is an open-source MCP server. It can run locally on your machine or as a hosted remote server.
Install
Run in a terminal
claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docsAdd to Settings → Connectors → Add custom connector
https://mcp.tigerdata.com/docsInstall in CursorOpens Cursor, which asks you to confirm. Or add it by hand:
Add to ~/.cursor/mcp.json
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:
Add to .vscode/mcp.json
{
"servers": {
"pg-aiguide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"pg-aiguide": {
"serverUrl": "https://mcp.tigerdata.com/docs"
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"pg-aiguide": {
"type": "http",
"url": "https://mcp.tigerdata.com/docs"
}
}
}Configuration
OPENAI_API_KEYYour API key for text embeddings via OpenAIRequiredPGHOSTPostgreSQL host to connect toRequiredPGPORTPostgreSQL port to connect toRequiredPGUSERPostgreSQL user to connect asRequiredPGPASSWORDPostgreSQL password to connect withRequiredPGDATABASEPostgreSQL database to connect toRequiredDB_SCHEMAPostgreSQL database schema to useOPENAI_API_KEYYour API key for text embeddings via OpenAIRequiredPGHOSTPostgreSQL host to connect toRequiredPGPORTPostgreSQL port to connect toRequiredPGUSERPostgreSQL user to connect asRequiredPGPASSWORDPostgreSQL password to connect withRequiredPGDATABASEPostgreSQL database to connect toRequiredDB_SCHEMAPostgreSQL database schema to use
Pricing
Open source
Pg Aiguide FAQ
Is Pg Aiguide free?
Yes. Pg Aiguide is open source, so you can use and self-host it for free.
How do I add Pg Aiguide to Claude Code?
Run this command in your terminal: claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs