Skip to content
MCP server

Pg Aiguide

Comprehensive PostgreSQL documentation and best practices, including ecosystem tools

Install
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/docs

Add to Settings → Connectors → Add custom connector

https://mcp.tigerdata.com/docs
Install 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 OpenAIRequired
  • PGHOSTPostgreSQL host to connect toRequired
  • PGPORTPostgreSQL port to connect toRequired
  • PGUSERPostgreSQL user to connect asRequired
  • PGPASSWORDPostgreSQL password to connect withRequired
  • PGDATABASEPostgreSQL database to connect toRequired
  • DB_SCHEMAPostgreSQL database schema to use
  • OPENAI_API_KEYYour API key for text embeddings via OpenAIRequired
  • PGHOSTPostgreSQL host to connect toRequired
  • PGPORTPostgreSQL port to connect toRequired
  • PGUSERPostgreSQL user to connect asRequired
  • PGPASSWORDPostgreSQL password to connect withRequired
  • PGDATABASEPostgreSQL database to connect toRequired
  • DB_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