Tiger Data publishes agent skills centered on PostgreSQL and TimescaleDB, covering time-series schema design, hypertable conversion, hyperfunctions for analytical SQL, pgvector semantic search, hybrid BM25 and vector retrieval, safe schema migrations, and exploring unfamiliar databases. Their skills are notable for treating the database as a whole, guiding an agent from table design and data types through indexing, migration, and querying.
Pg Aiguide
11 skills · 1,884 stars · Apache-2.0
Design Postgis Tables Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems,…
Design Postgres Tables Use this skill for general PostgreSQL table design.
Find Hypertable Candidates Use this skill to analyze an existing PostgreSQL database and identify which tables should be con…
Migrate Postgres Tables To Hypertables Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with…
Pgvector Semantic Search Use this skill for setting up vector similarity search with pgvector for AI/ML embeddings, RAG ap…
Postgres Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints…
Postgres Database Migration Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especia…
Postgres Hybrid Text Search Use this skill to implement hybrid search combining BM25 keyword search with semantic vector sear…
Schema Exploration Explore an existing PostgreSQL database before answering questions about its data or writing SQL.
Setup Timescaledb Hypertables Use this skill when creating database schemas or tables for Timescale, TimescaleDB, TigerData, or…
Timescaledb Hyperfunctions Use this skill when writing analytical SQL over time-series data with the TimescaleDB Toolkit (ti…