timescale-pg-aiguide
🏪Marketplacetimescale/pg-aiguide
|Enhances AI coding tools with intelligent, version-aware PostgreSQL code generation, providing semantic search and best practice recommendations for database schemas and queries.
Overview
pg-aiguide provides AI-optimized PostgreSQL expertise to coding assistants, helping them write dramatically better Postgres code. It delivers semantic search across the official PostgreSQL manual (version-aware), curated best-practice skills used automatically by AI agents, and extension ecosystem documentation starting with TimescaleDB.
Key Features
- Semantic search of PostgreSQL docs — Version-aware search across the official PostgreSQL manual so AI agents reference the correct syntax and features for your Postgres version
- AI-optimized best-practice skills — Curated, opinionated Postgres patterns that AI agents use automatically, producing schemas with 4x more constraints, 55% more indexes, and modern features like GENERATED ALWAYS AS IDENTITY
- Dual access modes — Available as a public MCP server (https://mcp.tigerdata.com/docs) for any AI agent, or as a native Claude Code plugin with one-click installs for Cursor, VS Code, and other editors
- Extension ecosystem docs — Includes TimescaleDB documentation with more extensions coming soon, covering the broader Postgres ecosystem
Who is this for?
Backend developers and DBAs who want their AI coding assistant to generate production-quality PostgreSQL schemas and queries instead of outdated, constraint-missing, index-poor SQL. Particularly valuable for teams using modern Postgres features and TimescaleDB who need version-accurate code generation.
Add this Marketplace
/plugin marketplace add timescale/pg-aiguidePlugins in this Marketplace
More from this repository8
Provides AI coding agents with deep, version-aware PostgreSQL expertise through semantic search over the official manual and curated best-practice skills, helping generate dramatically better schemas with more constraints, indexes, and modern PG features.
Enables semantic search in PostgreSQL by storing and efficiently querying vector embeddings using pgvector, supporting RAG, similarity search, and AI-powered content retrieval.
Designs PostgreSQL tables with best practices, focusing on normalization, data types, constraints, indexing, and schema optimization strategies.
Configures and optimizes TimescaleDB hypertables for high-performance time-series, IoT, and metrics data storage with automatic partitioning and compression.
A hypertable candidate finder skill from pg-aiguide, providing AI-optimized PostgreSQL expertise with semantic search across official docs and Timescale extension guides.
Converts identified PostgreSQL tables to TimescaleDB hypertables with optimal configuration, migration planning, and performance validation.
A PostgreSQL skill for implementing hybrid search that combines BM25 keyword search (via pg_textsearch) with semantic vector search (via pgvector), using Reciprocal Rank Fusion (RRF) to merge results into a single ranked list for improved retrieval relevance.
Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications on PostgreSQL 15+.