timescaleOfficial·9 Agent Skills Included

pg-aiguide

Gives AI coding agents expert PostgreSQL knowledge and best practices

Equips AI coding agents with curated PostgreSQL expertise for schema design, indexing, migrations, and extensions like TimescaleDB, PostGIS, and pgvector. Fixes the outdated, constraint-free, poorly indexed SQL that AI tools typically generate. Adds semantic search over official PostgreSQL docs so agents write correct, modern, production-ready database code.

1,830|106

↗

npx skills add timescale/pg-aiguide --all -g -y

All Skills in This Repository (9)

Pure Emerald Level Indicators

📦 In Repo

timescale

setup-timescaledb-hypertables

Design TimescaleDB hypertables for insert-heavy time-series workloads.

postgres-hybrid-text-search

Combine BM25 keyword search with semantic vector search in PostgreSQL.

migrate-postgres-tables-to-hypertables

Generate executable migration plans for PostgreSQL tables to TimescaleDB hypertables.

design-postgres-tables

Design PostgreSQL table schemas with data types, constraints, and indexes.

find-hypertable-candidates

Identify PostgreSQL tables for TimescaleDB hypertable conversion using schema analysis and candidacy scoring.

pgvector-semantic-search

Store, index, and query embeddings in PostgreSQL with pgvector.

postgres

Provides PostgreSQL best-practice references for schema design, indexing, search, and migrations.

design-postgis-tables

Design PostGIS spatial tables with geometry types, SRIDs, and spatial indexes.

ghost-database

Create, fork, query, and share managed PostgreSQL databases via Ghost CLI or MCP.

Official

Intermediate

Frequently Asked Questions

FAQPage Schema

How to install pg-aiguide?▼

Run `npx skills add timescale/pg-aiguide --all -g -y` in your terminal to install all PostgreSQL skills globally for your AI agent.

What does pg-aiguide do?▼

It gives AI coding assistants deep PostgreSQL knowledge, including table design, indexing, safe migrations, TimescaleDB hypertables, PostGIS spatial data, and pgvector semantic search.

Which AI agents work with pg-aiguide?▼

It works with Claude Code, Cursor, Codex, Gemini CLI, VS Code, and over 40 other agents that support the SKILL.md standard or MCP servers.

Can pg-aiguide help with zero-downtime migrations?▼

Yes. It includes detailed skills for safe schema changes, lock-level references, batched backfills, rollback planning, and fork-based testing on production databases.

Do I need to know SQL to use pg-aiguide?▼

No. Once installed, your AI agent applies the best practices automatically when you ask it to design schemas or write database queries in plain English.