timescale/pg-aiguide
8 skills3.3k installs14.4k starsGitHub
Install
npx skills add https://github.com/timescale/pg-aiguideSkills in this repo
1Postgrespostgres is a Timescale pg-aiguide skill that routes PostgreSQL work through nine specialized reference guides covering table design, PostGIS spatial schemas, pgvector semantic search, hybrid BM25+vector search, TimescaleDB hypertables, migration scoring, zero-downtime DDL, and Ghost managed databases. The agent loads topic-specific markdown references such as design-postgres-tables.md or pgvector-semantic-search.md instead of improvising SQL. Developers reach for postgres when designing schemas, choosing indexes and constraints, setting up RAG with pgvector, configuring PostGIS or TimescaleDB, or planning production migrations. It targets PostgreSQL, pgvector, PostGIS, TimescaleDB, and Ghost CLI/MCP workflows common in SaaS and agent backends.821installs2Pgvector Semantic Searchpgvector-semantic-search is a skill in the timescale/pg-aiguide repository for implementing vector similarity search inside PostgreSQL using the pgvector extension. It covers embedding storage, HNSW and IVFFlat index creation, cosine distance queries, halfvec types, and binary quantization for large datasets. Developers use it when building RAG pipelines, nearest-neighbor search, or semantic retrieval that must stay co-located with relational data. The skill also addresses pgvector performance tuning around recall, memory usage, and index selection. Reach for pgvector-semantic-search when prompts mention embeddings in Postgres, semantic search, or RAG backed by SQL rather than Pinecone or dedicated vector stores.681installs3Design Postgres Tablesdesign-postgres-tables is a skill in timescale/pg-aiguide for general PostgreSQL table design. It triggers when developers need new or updated schemas, data type selection, constraints, indexes, user or order tables, reference tables, or JSONB document columns. Guidance spans normalization, identity columns, partitioning considerations, B-tree and GIN indexes, and patterns for update-heavy or upsert-heavy OLTP workloads. Developers reach for design-postgres-tables when modeling production PostgreSQL rather than guessing types and keys that later require painful migrations.412installs4Setup Timescaledb Hypertablessetup-timescaledb-hypertables is a Timescale pg-aiguide skill for schema work on TimescaleDB, TigerData, and Tiger Cloud. It triggers when developers create SQL tables for sensors, metrics, telemetry, events, or logs and need partition columns, chunk intervals, segment_by, order_by, compression, retention policies, or continuous aggregates. The skill targets insert-heavy time-series workloads where plain PostgreSQL tables bottleneck ingestion or storage. Developers reach for it during backend schema design, IoT pipelines, and observability storage—not for generic CRUD apps without temporal partitioning needs. It encodes Timescale-specific DDL and policy patterns so agents propose hypertables instead of single monolithic tables.360installs5Find Hypertable Candidatesfind-hypertable-candidates is a Claude Code skill for ai & agent building. It helps solo builders move faster with AI-assisted development.285installs6Migrate Postgres Tables To Hypertablesmigrate-postgres-tables-to-hypertables is a Claude Code skill for databases. It helps solo builders move faster with AI-assisted development.266installs7Postgres Hybrid Text Searchpostgres-hybrid-text-search is a Claude Code skill for databases. It helps solo builders move faster with AI-assisted development.249installs8Design Postgis Tablesdesign-postgis-tables is a Claude Code skill for design & ui/ux. It helps solo builders move faster with AI-assisted development.211installs