pg-aiguide

Servidor MCP de Tiger Data (Timescale)

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

Sin cuenta (No hace falta cuenta ni clave)Streamable HTTP

Conectar con pg-aiguide

No hace falta iniciar sesión. Conéctate con la URL propia de pg-aiguide:

https://mcp.tigerdata.com/docs

Pégala en cualquier cliente compatible con servidores MCP remotos. Tu cliente habla directamente con Tiger Data (Timescale), no a través de mcp.tc.

Compartir este servidor

Abre esta página, con la URL y los pasos de configuración.

mcp.tc/i/pg-aiguide

Descripción

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.

Qué puedes hacer

  • 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

Herramientas 2

  • search_docsSolo lectura

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

  • view_skillSolo lectura

    Retrieve a named skill with TimescaleDB and PostgreSQL best practices.

Leídas del servidor en funcionamiento el 3 oct 2026. Solo lectura, Escribe y Puede borrar son indicaciones que declara el servidor; tu cliente decide si te pregunta antes de ejecutar una herramienta.

Prompts de ejemplo

  • 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?

Configuración

Todos los clientes se conectan a mcp.tigerdata.com. Elige el tuyo; la página recuerda tu elección.

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 Settings → Connectors and click 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, open Settings → Security and login and turn on Developer mode.
  2. Go to chatgpt.com/plugins and click + to create an app for a remote MCP server.
  3. Paste https://mcp.tigerdata.com/docs as the server URL and choose No authentication.

Developer mode is available on the web for Plus, Pro, Business, Enterprise and Education accounts.

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.

Preguntas frecuentes

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 2 tools: search_docs y view_skill. You can search PostgreSQL, TimescaleDB and PostGIS documentation, switch between keyword-only, semantic-only or blended search y 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 in developer mode, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. The setup steps cover each one.

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.

Insertar

Muestra pg-aiguide en un README o en tu web. Cada inserción enlaza a esta página, usa la URL propia del servidor y no instala cookies. Cómo funcionan las inserciones

Insignia para README

Vista previa de la insignia, claraVista previa de la insignia, oscura
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>

Sigue el modo claro u oscuro de quien lee. Añade ?theme=light o ?theme=dark para fijarlo, o ?style=compact para mostrar el símbolo sin la palabra.

Tarjeta para web

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

La tarjeta aparece donde esté la etiqueta. Añade data-theme="dark" o data-size="compact" a la etiqueta para cambiarla. El archivo contiene todo lo que necesita, así que no hace otras solicitudes ni instala 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>

Úsalo en páginas que no permiten scripts. Añade ?theme=light o ?theme=dark a la dirección para fijar los colores.

JSON

La ficha como datos para tus propias páginas y herramientas: nombre, descripción corta, la URL propia del servidor, herramientas y los enlaces «Add to». Cualquier web puede leerla (CORS abierto).

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

Qué significa cada campo

mcp.tc no tiene relación con Tiger Data (Timescale). Esta página se creó a partir de los metadatos públicos de pg-aiguide, comprobados por última vez el 3 oct 2026, y un modelo de IA escribió la descripción, así que puede contener errores. Los nombres y marcas pertenecen a sus titulares. ¿Algo no cuadra? Reportar esta ficha.