timescale/pg-aiguide
10 skills
$npx skills add timescale/pg-aiguideSkillInstalls
design-postgis-tablesComprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based…design-postgres-tablesUse this skill for general PostgreSQL table design.find-hypertable-candidatesUse this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables.ghost-databaseUse this skill for persistent PostgreSQL storage in agent workflows — spin up databases on demand, test schema migrations safely on forks, and pass databases…migrate-postgres-tables-to-hypertablesUse this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation.pgvector-semantic-searchUse this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG applications, or semantic search.postgresUse this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and…postgres-database-migrationUse this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases.postgres-hybrid-text-searchUse this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF).setup-timescaledb-hypertablesUse this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or Tiger Cloud, especially for time-series, IoT, metrics,…