We and selected third parties use cookies or similar technologies for technical purposes and, with your consent, to analyze how the site is used.

You can freely give, refuse or withdraw your consent at any time.

pg-aiguide

MCP server by Tiger Data (Timescale)

Search PostgreSQL, TimescaleDB and PostGIS docs and load Postgres best-practice skills for schema design and migrations.

No sign-in (No account or key needed)Streamable HTTP

Connect to pg-aiguide

No sign-in needed. Connect with pg-aiguide’s own URL:

https://mcp.tigerdata.com/docs

Paste it into any client that supports remote MCP servers. Your client talks to Tiger Data (Timescale) directly, not through mcp.tc.

Share this server

Opens this page, with the URL and setup steps.

mcp.tc/i/pg-aiguide

About

pg-aiguide gives coding assistants version-aware documentation search across PostgreSQL, Tiger Cloud (TimescaleDB) and PostGIS. Search combines keyword (BM25) and semantic vector ranking, and the weighting is adjustable. It also serves curated skills for table design, hypertables, pgvector, hybrid text search, schema exploration and safe migrations.

It runs as a hosted streamable-http endpoint at https://mcp.tigerdata.com/docs. No sign-in or API key is needed. The same project is also published as an npm package and container image, and as a Claude Code plugin.

What you can do

  • Search PostgreSQL, TimescaleDB and PostGIS documentation
  • Switch between keyword-only, semantic-only or blended search
  • Load Postgres table design best-practice skills
  • Find tables that should become TimescaleDB hypertables
  • Plan and test PostgreSQL schema migrations
  • Set up pgvector and hybrid BM25 plus vector search

Tools 3

  • search_docsRead-only

    Hybrid keyword and semantic search over Tiger Cloud, PostgreSQL and PostGIS documentation.

  • view_skillRead-only

    Retrieve a named skill with TimescaleDB and PostgreSQL best practices.

  • get_contextRead-only

    Read docs around a search hit

Read from the live server on 17 Nov 2026. Read-only, Writes and Can delete are hints the server declares; your client decides whether to ask before running a tool.

Example prompts

  • Create a Postgres schema for users with unique emails, using pg-aiguide.

  • Search the PostgreSQL docs for how NULLS NOT DISTINCT works.

  • Which of my tables should be converted to TimescaleDB hypertables?

  • How do I set up hybrid BM25 and vector search in Postgres?

Set up

Every client connects to mcp.tigerdata.com. Pick yours; the page remembers your choice.

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport http pg-aiguide https://mcp.tigerdata.com/docs
  1. Start Claude Code and type /mcp. pg-aiguide should show as connected.

Add --scope user to make it available in every project, not just this one.

Claude Desktop

  1. Open Customize → Connectors, click + Add, then Add custom connector.
  2. Name it pg-aiguide and paste this URL:
https://mcp.tigerdata.com/docs
  1. Click Add. Its tools appear in the chat’s tools menu.

Claude Desktop’s JSON config file only starts local servers. Remote servers go through Connectors, and connectors you add on claude.ai show up here too.

claude.ai

  1. Open the connector form on claude.ai. This button fills in the name and URL for you:
  1. Check that the URL reads https://mcp.tigerdata.com/docs and click Add.
  2. Turn it on in a chat from the tools menu.

Free plans allow one custom connector. On Team and Enterprise plans an owner adds it under Organization settings → Connectors.

ChatGPT

  1. On chatgpt.com, go to Plugins, select +, then Add custom MCP server.
  2. Enter a name for the server.
  3. Under Connection, paste https://mcp.tigerdata.com/docs as the server URL, then for authentication choose No authentication.
  4. Check I understand and want to continue, then select Create as a plugin.

Whether you can add a custom MCP server depends on your ChatGPT plan and your workspace permissions (in Business workspaces, admins and owners can).

Cursor

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

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

VS Code

Or from a terminal:

code --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'

Or commit it to the repo in .vscode/mcp.json:

.vscode/mcp.json
{
  "servers": {
    "pg-aiguide": {
      "type": "http",
      "url": "https://mcp.tigerdata.com/docs"
    }
  }
}

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "pg-aiguide": {
      "serverUrl": "https://mcp.tigerdata.com/docs"
    }
  }
}
  1. Refresh the MCP server list in Cascade.

Devin Desktop is the new name for Windsurf. It reads serverUrl (or url) for remote servers.

Codex

codex mcp add pg-aiguide --url https://mcp.tigerdata.com/docs

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.pg-aiguide]
url = "https://mcp.tigerdata.com/docs"

Gemini CLI

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

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients accept this shape. Some name the URL field differently: serverUrl in Devin Desktop, httpUrl in Gemini CLI’s settings file.

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

Zed puts servers under context_servers in its settings. Cline needs "type": "streamableHttp", or it assumes SSE.

Client only starts local servers? Bridge it with npx -y mcp-remote https://mcp.tigerdata.com/docs.

Embed

Show pg-aiguide in a README or on your site. Each embed links to this page, uses the server’s own URL, and sets no cookies. How embeds work

The card, the iframe and the JSON are in English. Add ?lang=it, fr, de or es to their address for another language.

README badge

Badge preview, lightBadge preview, dark
Markdown
[![pg-aiguide on mcp.tc](https://mcp.tc/i/pg-aiguide/badge.svg)](https://mcp.tc/i/pg-aiguide)
HTML
<a href="https://mcp.tc/i/pg-aiguide"><img src="https://mcp.tc/i/pg-aiguide/badge.svg" alt="pg-aiguide on mcp.tc" height="20"></a>

It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.

Website card

HTML
<script src="https://mcp.tc/w/pg-aiguide.js" async></script>

The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.

iframe

HTML
<iframe src="https://mcp.tc/embed/pg-aiguide" title="pg-aiguide on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.

JSON

The listing as data for your own pages and tools: name, tagline, the server’s own URL, tools and the “Add to” links. Any site can read it (CORS is open).

https://mcp.tc/i/pg-aiguide.json

What each field means

AI prompt

Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the pg-aiguide card to your site.

Markdown
Add the mcp.tc card for pg-aiguide, an MCP server, to my website. It is one static script: no build step, no package to install, no cookies.

Put this tag where the card should appear. The card renders right before it:

```html
<script src="https://mcp.tc/w/pg-aiguide.js" async></script>
```

To show the card somewhere else, put this placeholder there and load the same script once, for example before `</body>`. Keep the link inside: visitors without JavaScript see it.

```html
<div data-mcptc="pg-aiguide"><a href="https://mcp.tc/i/pg-aiguide">pg-aiguide on mcp.tc</a></div>
```

Options:
- `data-theme="light"` or `"dark"` on the tag or the placeholder fixes the colors. Without it, the card follows the visitor’s light or dark mode.
- `data-size="compact"` gives a smaller card without the tagline.
- The CSS variable `--mcptc-max-width` on the placeholder or a parent sets the width (default `520px`).
- `?lang=` on the script URL sets the card’s language: `en`, `it`, `fr`, `de` or `es`.

If the site has a Content Security Policy, allow `script-src https://mcp.tc` and `img-src data:` (the icon is inline).

For a README or other Markdown docs, use the badge instead:

```markdown
[![pg-aiguide on mcp.tc](https://mcp.tc/i/pg-aiguide/badge.svg)](https://mcp.tc/i/pg-aiguide)
```

Reference: https://mcp.tc/embed

Change history

We read this server’s tool list every 3 hours and record what changes. Last read 18 Nov 2026, 05:34 UTC.

Follow pg-aiguide and we’ll email you when something changes.

  1. , Automatic check

    1 tool added and 1 tool changed.

    Details, 12 Nov 2026, 23:48 UTC

    Added 1

    • get_contextRead-only

      Opens any part of the docs (a section or a whole page) as markdown, with links to move around it. Use it on a search_docs hit before answering from it: a hit is one chunk, and often a fragment (a table row without the header that says which column is which plan, one step of a procedure). Pass the hit's chunk_id to get the whole section it is in. Every result is a node in the page's outline. parent_id goes one level up (to the enclosing section, then the page); children lists the sections one level down; previous_id / next_id move to the neighbouring sections. Pass any of those ids back in. It also takes a docs URL, e.g. a link in the text; a #fragment opens that section. Text over 20,000 characters (a whole Postgres reference page, a long page) comes back in parts: you get the part holding the chunk you passed, and part / part_count say which.

    Changed 1

    • search_docsdescription and output schema
      Before

      Search documentation with hybrid semantic (vector) and keyword (BM25) search. Use semanticWeight to choose keyword-only (0), semantic-only (1), or a blend; mid values fuse rankings with RRF. Supports Tiger Cloud (TimescaleDB), PostgreSQL, and PostGIS.

      After

      Search documentation with hybrid semantic (vector) and keyword (BM25) search. Use semanticWeight to choose keyword-only (0), semantic-only (1), or a blend; mid values fuse rankings with RRF. Supports Tiger Cloud (TimescaleDB), PostgreSQL, and PostGIS. A hit is one chunk of a page, often part of a larger section: a table row without its header, one step of a procedure. Before answering from a hit, read it in context: get_context with the hit's chunk_id returns the whole section it is in, and from there its parent section, the page and the page's outline. For exact figures (limits, prices, plan features) prefer keyword-heavy searches (semanticWeight 0–0.3) that use the words the docs would use.

  2. , Automatic check

    2 tools changed.

    Details, 21 Oct 2026, 19:41 UTC

    Changed 2

    • search_docsinput schema and output schema
    • view_skillinput schema and output schema
  3. , Automatic check

    1 tool changed.

    Details, 7 Oct 2026, 22:32 UTC

    Changed 1

    • view_skilldescription
      Before

      Retrieve detailed skills for TimescaleDB operations and best practices. ## Available Skills <available_skills> [10 ]{name description}: design-postgis-tables Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications design-postgres-tables "Use this skill for general PostgreSQL table design.\n\n**Trigger when user asks to:**\n- Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones.\n- Choose data types, constraints, or indexes for PostgreSQL\n- Create user tables, order tables, reference tables, or JSONB schemas\n- Understand PostgreSQL best practices for normalization, constraints, or indexing\n- Design update-heavy, upsert-heavy, or OLTP-style tables\n\n\n**Keywords:** PostgreSQL schema, table design, data types, PRIMARY KEY, FOREIGN KEY, indexes, B-tree, GIN, JSONB, constraints, normalization, identity columns, parti…

      After

      Retrieve detailed skills for TimescaleDB operations and best practices. ## Available Skills <available_skills> [11 ]{name description}: design-postgis-tables Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications design-postgres-tables "Use this skill for general PostgreSQL table design.\n\n**Trigger when user asks to:**\n- Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones.\n- Choose data types, constraints, or indexes for PostgreSQL\n- Create user tables, order tables, reference tables, or JSONB schemas\n- Understand PostgreSQL best practices for normalization, constraints, or indexing\n- Design update-heavy, upsert-heavy, or OLTP-style tables\n\n\n**Keywords:** PostgreSQL schema, table design, data types, PRIMARY KEY, FOREIGN KEY, indexes, B-tree, GIN, JSONB, constraints, normalization, identity columns, parti…

  4. , Automatic check

    Tracking started: 2 tools.

FAQ

Can I paste mcp.tc/i/pg-aiguide into my MCP client?

No. mcp.tc links are pages, not server addresses. Connect with https://mcp.tigerdata.com/docs, so your client talks to pg-aiguide directly. The quick link is for sharing: it opens this page, with setup steps for every client.

Does pg-aiguide need an API key or a sign-in?

No. pg-aiguide doesn’t ask for an account or key.

Is pg-aiguide a remote or a local server?

Remote. Tiger Data (Timescale) hosts it at https://mcp.tigerdata.com/docs, and it speaks Streamable HTTP. There’s nothing to install.

What can pg-aiguide do?

It has 3 tools: search_docs, view_skill and get_context. You can search PostgreSQL, TimescaleDB and PostGIS documentation, switch between keyword-only, semantic-only or blended search and load Postgres table design best-practice skills.

Which clients can use it?

Any client that supports remote MCP servers: Claude Code, Claude Desktop, claude.ai, ChatGPT, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. The setup steps cover each one.

Does mcp.tc track changes to pg-aiguide?

Yes. pg-aiguide’s History tab shows each change we find to its tools, down to descriptions and parameters, plus new versions and edits by its owner. Follow the listing to get an email when it changes.

Who wrote this page?

mcp.tc’s robot read pg-aiguide’s own metadata (its MCP handshake, tool list and public pages), and an AI model drafted the text from it. A person reviews anything the checks can’t confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

mcp.tc isn’t affiliated with Tiger Data (Timescale). This page was built from pg-aiguide’s public metadata, last checked on 17 Nov 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.