pg-aiguide
OfficialProvides AI coding assistants with semantic search across PostgreSQL documentation and curated best practices to generate better, more modern PostgreSQL code.
What it does
- Search PostgreSQL documentation semantically
- Access TimescaleDB and Tiger Cloud documentation
- Retrieve PostgreSQL best practices and design patterns
- Get version-aware PostgreSQL guidance
Best for
Tools (3)
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.
