Postgres Ai Guide

@timescale

About Postgres Ai Guide

No overview available yet

#postgres-ai #postgresql #ai-coding-assistant

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

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.

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, partitioning, row-level security\n\nComprehensive reference covering data types, indexing strategies, constraints, JSONB patterns, partitioning, and PostgreSQL-specific best practices.\n" find-hypertable-candidates "Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables.\n\n**Trigger when user asks to:**\n- Analyze database tables for hypertable conversion potential\n- Identify time-series or event tables in an existing schema\n- Evaluate if a table would benefit from Timescale/TimescaleDB\n- Audit PostgreSQL tables for migration to Timescale/TimescaleDB/TigerData\n- Score or rank tables for hypertable candidacy\n\n\n**Keywords:** hypertable candidate, table analysis, migration assessment, Timescale, TimescaleDB, time-series detection, insert-heavy tables, event logs, audit tables\n\nProvides SQL queries to analyze table statistics, index patterns, and query patterns. Includes scoring criteria (8+ points = good candidate) and pattern recognition for IoT, events, transactions, and sequential data.\n" ghost-database "Use this skill for persistent PostgreSQL storage in agent workflows — spin up databases on demand, test schema migrations safely on forks, and pass databases as assets between agents using Ghost.\n\n**Trigger when user asks to:**\n- Create a new PostgreSQL database quickly\n- Manage database lifecycle in agent workflows\n- Fork a database to test changes safely\n- Run analytics or heavy queries on a fork without impacting the production database\n- Share a database snapshot so others can spin up their own copy\n- Pass a database as an input or output between agents\n- Create a database for agents\n- Need many databases that are billed only when queried\n- Set up the Ghost MCP server or CLI\n\n**Note:** If the Ghost MCP server is already installed, use its tools directly — this skill is for environments without the MCP or as a reference for what's possible.\n\n**Keywords:** Ghost, ghost.build, database, create database, fork database, PostgreSQL, managed Postgres, MCP, agent database, connection string\n" migrate-postgres-tables-to-hypertables "Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation.\n\n**Trigger when user asks to:**\n- Migrate or convert PostgreSQL tables to hypertables\n- Execute hypertable migration with minimal downtime\n- Plan blue-green migration for large tables\n- Validate hypertable migration success\n- Configure compression after migration\n\n**Prerequisites:** Tables already identified as candidates (use find-hypertable-candidates first if needed)\n\n**Keywords:** migrate to hypertable, convert table, Timescale, TimescaleDB, blue-green migration, in-place conversion, create_hypertable, migration validation, compression setup\n\nStep-by-step migration planning including: partition column selection, chunk interval calculation, PK/constraint h…

Overview

What is Postgres Ai Guide?

Postgres Ai Guide is an MCP server that helps AI coding tools write better PostgreSQL code. It provides semantic search across the official PostgreSQL manual (version-aware), AI-optimized best-practice “skills” automatically used by AI agents, and extension ecosystem documentation starting with TimescaleDB. It is available as a public MCP server or as a Claude Code plugin.

How to use Postgres Ai Guide?

Use as a public MCP server by configuring your client with URL https://mcp.tigerdata.com/docs. One-click installs exist for Cursor, VS Code, and other editors. For Claude Code, install the plugin with claude plugin marketplace add timescale/pg-aiguide then claude plugin install pg@aiguide. Ask Postgres questions or design schemas in natural language.

Key features of Postgres Ai Guide

Semantic search over the official PostgreSQL manual, scoped to a specific version
AI-optimized skills covering schema design, indexing, data types, and performance
Extension documentation, starting with TimescaleDB
Version-aware results that use modern PostgreSQL features (e.g., PG17 patterns)
Works with any MCP-compatible AI coding agent

Use cases of Postgres Ai Guide

Designing robust PostgreSQL schemas with proper constraints, indexes, and modern syntax
Getting version-specific guidance on PostgreSQL features and best practices
Learning recommended naming conventions and performance tuning patterns
Generating optimized queries using TimescaleDB documentation

FAQ from Postgres Ai Guide

How does Postgres Ai Guide improve AI-generated PostgreSQL code?

It provides AI agents with deep, versioned PostgreSQL knowledge and proven patterns, solving issues like outdated code, missing constraints, and unawareness of modern PG features.

What skills does Postgres Ai Guide include?

Skills cover schema design, indexing strategies, data types, data integrity and constraints, naming conventions, performance tuning, and modern PostgreSQL features.

What extensions are currently supported?

TimescaleDB is supported today; pgvector and PostGIS are coming soon.

How do I install Postgres Ai Guide as a Claude Code plugin?

Run claude plugin marketplace add timescale/pg-aiguide then claude plugin install pg@aiguide. It uses the skills in the skills directory and the publicly hosted MCP server.

What transport does Postgres Ai Guide use?

It uses HTTP; the MCP server URL is https://mcp.tigerdata.com/docs. No authentication is mentioned in the README.

Frequently asked questions

How does Postgres Ai Guide improve AI-generated PostgreSQL code?

It provides AI agents with deep, versioned PostgreSQL knowledge and proven patterns, solving issues like outdated code, missing constraints, and unawareness of modern PG features.

What skills does Postgres Ai Guide include?

Skills cover schema design, indexing strategies, data types, data integrity and constraints, naming conventions, performance tuning, and modern PostgreSQL features.

What extensions are currently supported?

TimescaleDB is supported today; pgvector and PostGIS are coming soon.

How do I install Postgres Ai Guide as a Claude Code plugin?

Run `claude plugin marketplace add timescale/pg-aiguide` then `claude plugin install pg@aiguide`. It uses the skills in the `skills` directory and the publicly hosted MCP server.

What transport does Postgres Ai Guide use?

It uses HTTP; the MCP server URL is `https://mcp.tigerdata.com/docs`. No authentication is mentioned in the README.

Comments

Basic information

More Databases MCP servers

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K