NeVibeCode · repository · 11 items
pg-aiguide: a set by timescale
The timescale/pg-aiguide repository on GitHub: 11 cards with a description and an install command. Inside: 10 skills and 1 MCP server. They work in Claude Code, Codex, Cursor — 10 platforms in total.
About the repository
- GitHub
- timescale/pg-aiguide
- Stars
- ★ 1,886
- Installs across cards
- 5,744
- License
- Apache-2.0
- Source updated
- 2026-10-22
- In the catalog since
- 2026-10-25
postgres skill A skill for PostgreSQL work: table design, indexing, pgvector, PostGIS, TimescaleDB and migrations. Useful when your agent writes SQL blind.
CX Codex +1
1,500installs
pgvector-semantic-search skill pgvector-semantic-search configures AI agents to set up vector similarity search in PostgreSQL using pgvector. Helps store embeddings with halfvec, build HNSW indexes, and power RAG apps.
CX Codex +1
1,000installs
design-postgres-tables skill design-postgres-tables — a reference skill for PostgreSQL table design: data types, indexes, constraints, JSONB and partitioning. Useful when your agent writes or edits a schema.
CX Codex +1
680installs
setup-timescaledb-hypertables skill setup-timescaledb-hypertables guides agents in designing TimescaleDB and Tiger Cloud hypertables for insert-heavy workloads. Helps configure chunk partitioning, columnstore compression, and sparse indexes.
CX Codex +1
559installs
find-hypertable-candidates skill find-hypertable-candidates reads a PostgreSQL schema and ranks which tables are worth converting to TimescaleDB hypertables. Useful before a migration.
CX Codex +1
423installs
postgres-hybrid-text-search skill postgres-hybrid-text-search teaches AI agents how to combine BM25 keyword matching with pgvector semantic retrieval using Reciprocal Rank Fusion in PostgreSQL.
CX Codex +1
411installs
design-postgis-tables skill design-postgis-tables is a Claude Code skill that covers PostGIS geometry types, coordinate systems, indexes and query patterns for designing schemas for location data.
CX Codex +1
391installs
migrate-postgres-tables-to-hypertables skill migrate-postgres-tables-to-hypertables plans the move of PostgreSQL tables to TimescaleDB hypertables: partition column, chunk interval, keys and compression.
CX Codex +1
382installs
postgres-database-migration skill The postgres-database-migration skill helps plan, test, and run PostgreSQL schema migrations safely. It is aimed at production tables and shared databases.
CX Codex +1
285installs
schema-exploration skill The schema-exploration skill for Claude Code analyzes an existing PostgreSQL database before writing queries or answering data questions.
CX Codex +1
113installs
pg-aiguide MCP server pg-aiguide gives your coding agent semantic search over the PostgreSQL, TimescaleDB and PostGIS manuals plus curated Postgres best-practice skills.
CX Codex +1
★ 1,886repo stars