pg_aiguide_mcp

pg-aiguide provides AI-optimized PostgreSQL knowledge and documented skills that you can access via an MCP client. It helps you write better, version-aware PostgreSQL code by offering semantic search, curated best practices, and extension ecosystem guidance for tools and agents.

How to use

Connect to the public MCP server to access AI-optimized PostgreSQL knowledge. You can query for version-aware PostgreSQL documentation, leverage our curated best-practice skills, and browse extension ecosystem information. Use the MCP client to send natural language questions or prompts, and rely on pg-aiguide to guide schema design, indexing strategies, data integrity rules, and modern PostgreSQL features.

How to install

Prerequisites: ensure you have an MCP client installed or an environment that can consume MCP endpoints. The public MCP server is hosted at the specified URL and can be added to your MCP-enabled tooling as a remote source.

Option 1 — add the public MCP server to your MCP client using the provided endpoint.

{
  "mcpServers": {
    "pg-aiguide_mcp": {
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

Option 2 — use Claude Code Plugin setup (for Claude users)

If you are using Claude Code, install the plugin to access pg-aiguide within Claude’s native skill support.

claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide

Available tools

semantic_search_postgres_docs

Performs semantic search over the official PostgreSQL manual, scoped to a specific PostgreSQL version.

semantic_search_tiger_docs

Searches Tiger Data’s documentation corpus, including TimescaleDB and related extensions.

view_skill

Exposes curated, opinionated PostgreSQL best-practice guidance for AI coding assistants, covering schema design, indexing, data integrity, naming conventions, and performance.