Provides AI coding agents with deep, version-aware PostgreSQL expertise through semantic search over the official manual and curated best-practice skills, helping generate dramatically better schemas with more constraints, indexes, and modern PG features.

🎯

pgvector-semantic-search🎯Skill

Enables semantic search in PostgreSQL by storing and efficiently querying vector embeddings using pgvector, supporting RAG, similarity search, and AI-powered content retrieval.

🎯

design-postgres-tables🎯Skill

Designs PostgreSQL tables with best practices, focusing on normalization, data types, constraints, indexing, and schema optimization strategies.

🎯

setup-timescaledb-hypertables🎯Skill

Configures and optimizes TimescaleDB hypertables for high-performance time-series, IoT, and metrics data storage with automatic partitioning and compression.

🎯

find-hypertable-candidates🎯Skill

A hypertable candidate finder skill from pg-aiguide, providing AI-optimized PostgreSQL expertise with semantic search across official docs and Timescale extension guides.

🎯

migrate-postgres-tables-to-hypertables🎯Skill

Converts identified PostgreSQL tables to TimescaleDB hypertables with optimal configuration, migration planning, and performance validation.

🎯

postgres-hybrid-text-search🎯Skill

A PostgreSQL skill for implementing hybrid search that combines BM25 keyword search (via pg_textsearch) with semantic vector search (via pgvector), using Reciprocal Rank Fusion (RRF) to merge results into a single ranked list for improved retrieval relevance.

🎯

design-postgis-tables🎯Skill

Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications on PostgreSQL 15+.