Postgres Ai Guide

Name: Postgres Ai Guide
Author: timescale

@timescale

Repository

About Postgres Ai Guide

No overview available yet

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

Basic information

Config

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

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

Tools

This retrieves relevant PostgreSQL documentation entries based on a natural language query.

This retrieves relevant documentation entries based on a natural language query. The content covers Tiger Cloud and TimescaleDB topics.

Retrieve detailed skills for TimescaleDB operations and best practices. Available Skills: **design-postgres-tables** - Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features **find-hypertable-candidates** - Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables **migrate-postgres-tables-to-hypertables** - Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation **setup-timescaledb-hypertables** - Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention policies, and continuous aggregates. Instructions for selecting: partition columns, segment_by columns, order_by columns, chunk time interval, real-time aggregation.

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.