Pg Aiguide MCP Server

AI-optimized PostgreSQL expertise for coding assistants pg-aiguide helps AI coding tools write dramatically better PostgreSQL code.

People connecting documentation tools to Claude, Cursor, VS Code, or another MCP client. The project is written in Python.

VERIFIED ACTIVE

LAST COMMIT 2026-06-26 · ★ 1,821 · #34 OF 183 MAINTAINED DOCUMENTATION · VERIFIED 2026-08-25

Apache-2.0 · Python servers · how we verify → /methodology

01 · Install Pg Aiguide

Claude Code

claude mcp add timescale-pg-aiguide --transport http https://mcp.tigerdata.com/docs

Claude Desktop / Cursor / VS Code - add to config

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

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

https://mcp.tigerdata.com/docs

transport: streamable-http

endpoint alive - responded to MCP initialize · probed 2026-08-25

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions · container (OCI image) - can be sandboxed away from your filesystem · remote - your agent's requests go to mcp.tigerdata.com

endpoint auth accepted our unauthenticated MCP initialize - no credentials needed to connect

license Apache-2.0 - declared in the repository

npm package @tigerdata/pg-aiguide - the @tigerdata scope differs from the repo owner (timescale); confirm it's the project's official package

registry namespace io.github.timescale is GitHub-verified and matches the repo owner

03 · What Pg Aiguide can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

Latest releases

v0.5.0 · 2026-04-28

[AGE-430] Add PostGIS versioning (and combine source+version) · Update secrets to ORG_AUTOMATION_TOKEN · [CHORE] update lock file · [CHORE] use non-prod instead of github's runners · [CHORE] revert · Add npx skills…

v0.4.0 · 2026-03-18

add PostGIS documentation support · [AGE-383] Refactor Postgres/PostGIS import · Add hint annotations to tools · New Contributors · @cbc3929 made their first contribution in · @gregsaab made their first contribution in

v0.3.1 · 2026-02-23

Update skills descriptions to match Claude best practices · permission denied to create extension "pg_textsearch" · Add Cursor Marketplace plugin support · New Contributors · @wachawo made their first contribution in

04 · Who maintains Pg Aiguide

pg-aiguide is maintained by timescale. We track 3 MCP servers from timescale - 3 actively maintained, 1,944 combined GitHub stars, oldest repo from Jul 2025. Full record: all servers from timescale.

05 · Facts

repository: github.com/timescale/pg-aiguide
category: documentation - ranked #34 of 183 actively-maintained documentation servers as of 2026-08-25.
registry: io.github.timescale/pg-aiguide (active, first published 2025-12-09 · 6 versions)
packages: npm:@tigerdata/pg-aiguide · oci:ghcr.io/timescale/pg-aiguide:0.5.1

06 · Pg Aiguide FAQ

What is Pg Aiguide?

AI-optimized PostgreSQL expertise for coding assistants pg-aiguide helps AI coding tools write dramatically better PostgreSQL code.

Is Pg Aiguide still maintained?

Yes - as of 2026-08-25, its last commit was 2026-06-26. We re-verify nightly.

How do I install Pg Aiguide?

Run `npx -y @tigerdata/pg-aiguide`. You can also paste the ready-made client config above.

Does Pg Aiguide require authentication?

No - the endpoint accepted our unauthenticated MCP initialize when probed on 2026-08-25; you can connect without credentials.

07 · Alternatives to Pg Aiguide

Alternatives to Pg Aiguide

Maintained documentation servers if Pg Aiguide isn't the fit.

Pairs well with

Servers that cover what Pg Aiguide doesn't - only shown when the pairing reason fits the companion.

More documentation MCP servers · Devrag · Trip2g · Pindoc · Vercel MCP

More Python MCP servers · Clawtouch MCP · Tinycontext · Lacuna Research MCP · Mnemograph · Tendem MCP server · see all