timescale/pg-aiguide

Find Hypertable Candidates analyzes an existing PostgreSQL database to identify which tables should be converted to Timescale/TimescaleDB hypertables. Use it when auditing tables for time-series or insert-heavy workloads and evaluating hypertable candidacy before migration.

Ghost Database creates and manages PostgreSQL databases for agent workflows, with on-demand creation, instant forks for safe testing, and shareable snapshots. Use it when an agent needs persistent storage or wants to pass databases as assets between workflows.

PGVector Semantic Search stores and searches vector embeddings in PostgreSQL using HNSW or IVFFlat indexes for semantic search, RAG, and nearest-neighbor queries. Use it to set up pgvector, tune recall and performance, or implement binary quantization for large datasets.

PostGIS Spatial Table Design provides best practices and SQL patterns for designing PostGIS tables, covering geometry types, SRID selection, spatial indexes, and performance considerations for location-based applications.

PostgreSQL provides expert guidance for PostgreSQL table design, indexing, data types, constraints, extensions, search, and migrations. Use it when designing schemas, working with pgvector/PostGIS/TimescaleDB, or planning safe schema changes.

PostgreSQL Database Migration helps plan, test, and safely execute PostgreSQL schema migrations on production data. Use it to understand DDL lock levels, perform zero-downtime ALTER TABLE changes, backfill data, and plan rollbacks.

PostgreSQL Table Design guides PostgreSQL schema, table, data type, constraint, and index decisions when creating new tables or modifying existing ones.

Postgres Hybrid Text Search combines BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). Use it when building search that handles both exact terms and meaning, such as product names mixed with conceptual queries.

Postgres Hypertable Migration plans and executes migration of PostgreSQL tables to TimescaleDB hypertables, including partition column selection, chunk interval calculation, constraint handling, and validation. Use it after identifying candidate tables to convert with minimal downtime.

Setup TimescaleDB Hypertables configures TimescaleDB for time-series data, including hypertable creation, compression, retention policies, and continuous aggregates. Use it when designing schemas for insert-heavy tables like IoT metrics, event logs, or transaction records.