Skip to content

Summary

Tiger Data's hosted MCP server and skills for PostgreSQL: version-aware semantic search over the Postgres, TimescaleDB and PostGIS manuals.

Features

  • Version-aware semantic search over the PostgreSQL manual
  • TimescaleDB and PostGIS documentation included
  • Hosted endpoint at mcp.tigerdata.com/docs
  • Companion Postgres best-practice and schema-exploration skills
  • Installs as a Claude Code plugin in two commands

Installation

Set up this MCP server in your favorite AI agent — copy a ready-made configuration below.

Any MCP-compatible agent

Most agents (Claude, Cursor, Windsurf, VS Code, and more) read a standard mcpServers configuration.

  1. Open your agent's MCP configuration file.
  2. Merge the snippet below into it.
  3. Restart the agent — the "pg-aiguide" tools will be available.
{
  "mcpServers": {
    "pg-aiguide": {
      "command": "claude",
      "args": [
        "plugin",
        "marketplace",
        "add",
        "timescale/pg-aiguide"
      ]
    }
  }
}

Description

pg-aiguide, from Tiger Data (the company behind TimescaleDB), helps coding agents write better PostgreSQL. Its public MCP server at mcp.tigerdata.com/docs gives an agent semantic search across the official PostgreSQL manual, version by version, and the TimescaleDB and PostGIS documentation, so schema and query suggestions follow the database version you actually run instead of whatever the model remembers.

The same repository ships opinionated Postgres best-practice skills, such as a postgres skill for schema design and a schema-exploration skill for investigating an existing database, installable with npx skills for Claude Code, Cursor, Codex, Gemini CLI and other agents. Claude Code users can install everything at once as a plugin from the repository's marketplace. Tiger Data's README demo compares an e-commerce schema written with and without the server and reports more constraints, more indexes and modern features such as GENERATED ALWAYS AS IDENTITY.

The MCP endpoint is hosted and free to connect with no API key in the README's configuration; the code is Apache-2.0 licensed.

Self-hosted documentation retrieval for coding agents — index any library's docs from the web, GitHub, npm, PyPI or local files and query them by exact version. An open-source Context7 alternative.

New

Zilliz's MCP server for semantic code search: it indexes a whole repository into Milvus or Zilliz Cloud and hands coding agents only the relevant chunks.

Featured

Attio's official hosted MCP server — search, read and write your CRM records, lists, notes, tasks, meetings and emails from any MCP client over OAuth.

Browse all MCP servers →