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.

数据库分类下的更多 MCP 服务器

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245