timescale

This skill assists with general PostgreSQL table design, including creating and modifying tables, schemas, and data models. It helps choose data types, constraints, and indexes, and provides best practices for normalization.

This skill analyzes existing PostgreSQL databases to identify tables suitable for conversion to Timescale/TimescaleDB hypertables, helping to find time-series or event tables and evaluate conversion benefits.

This skill sets up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search.

This skill is for PostgreSQL database work, covering table design, indexing, data types, constraints, extensions (like pgvector), search, and migrations. It triggers for tasks such as designing tables, choosing data types, or working with pgvector embeddings and semantic search.

Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications.

Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation.

Use this skill to implement hybrid search, combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF).

Use this skill for creating database schemas or tables in Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics, events, or log data. It helps improve the performance of insert-heavy tables.