aiguide

active

1plugins

4skills

TigerData

pg

Comprehensive PostgreSQL documentation and best practices through semantic search and curated skills, including ecosystem tools like TimescaleDB and Tiger Cloud

database

4 skills

design-postgres-tables

verified

Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features

find-hypertable-candidates

verified

Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables

migrate-postgres-tables-to-hypertables

verified

Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation

setup-timescaledb-hypertables

verified

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.