Pg Aiguide MCP Server

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

People who work with ai coding, claude marketplace and docs and want it reachable from Claude, Cursor, VS Code, or another MCP client. The project is written in Python.

VERIFIED ACTIVE

LAST COMMIT 2026-09-16 · ★ 1,843 · #19 OF 208 MAINTAINED DOCUMENTATION · VERIFIED 2026-09-18

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-09-17

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.6.1 · 2026-09-04

v0.6.0 · 2026-09-04

Update @tigerdata/mcp-boilerplate to 1.6.4 · Update dependencies (includes boilerplate XSS fix) · update python deps to clear all 44 Dependabot alerts · Resolve relative inline links to fully-qualified URLs during…

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…

04 · Who maintains Pg Aiguide

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

  1. Tiger MCP Provides programmatic access to Tiger Cloud services, databases, and documentation. ★ 119
  2. tiger-skills Provider agnostic skills implementation, with skills sourced from local paths or GitHub repositories ★ 7

05 · Facts

repository
github.com/timescale/pg-aiguide
category
documentation - ranked #19 of 208 actively-maintained documentation servers as of 2026-09-18.
release cadence
2 releases in the last 90 days (latest 2026-09-04)
registry
io.github.timescale/pg-aiguide (active, first published 2025-12-09 · 7 versions)
packages
npm:@tigerdata/pg-aiguide · oci:ghcr.io/timescale/pg-aiguide:0.6.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-09-18, its last commit was 2026-09-16 and it shipped 2 releases in the last 90 days. 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-09-17; you can connect without credentials.

07 · Alternatives to Pg Aiguide

Alternatives to Pg Aiguide

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

  1. Context7 Up-to-date code docs for any prompt ★ 62,152 · 2026-09-18
  2. Agent Skills Search Server Search and discover Agent Skills from the skills.sh registry. Powered by HAPI MCP server. ★ 25,432 · 2026-08-09
  3. Repowise Codebase intelligence for AI coding agents - graph, git history, docs, decisions, code health. ★ 6,686 · 2026-09-17
  4. GitLab MCP GitLab MCP server for projects, merge requests, issues, pipelines, wiki, releases, and more. ★ 1,984 · 2026-09-16
  5. Microsoft Learn MCP Official Microsoft Learn MCP Server – real-time, trusted docs & code samples for AI and LLMs. ★ 1,892 · 2026-09-10
  6. IWE Markdown knowledge base as agent memory. Runs against the notes directory it is started in. ★ 1,650 · 2026-09-17

Pairs well with

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

  1. Serena → coding agent companion coding agent · ★ 29,556
  2. Desktop Commander → coding agent companion coding agent · ★ 9,633
  3. Xcode Build MCP → developer tools companion developer tools · ★ 6,397
  4. Sentry MCP → developer tools companion developer tools · ★ 855

More documentation MCP servers · Prumo · Devrag · Trip2g · Valuein - SEC EDGAR Fundamentals & Smart-Money Data

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