Postgres Ai Guide

Name: Postgres Ai Guide
Author: timescale

@timescale

リポジトリ

Postgres Ai Guide について

概要はまだありません

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

基本情報

カテゴリ

データベース

トランスポート

stdio

公開者

timescale

投稿者

Mat Arye

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

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.

概要

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.

「データベース」の他のコンテンツ

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

MCP Server for Milvus

zilliztech

Model Context Protocol Servers for Milvus

235

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412