pg-aiguide

Étoiles13

Forks2

Mis à jour21 février 2026 à 18:17

PostgreSQL and TimescaleDB skill collection from Timescale's pg-aiguide. Covers table design, hypertables, pgvector semantic search, and hybrid text search. **Trigger when user asks to:** - Design PostgreSQL tables or schemas - Work with TimescaleDB hypertables - Implement semantic search with pgvector - Set up hybrid text search in PostgreSQL - Migrate tables to hypertables

Installation

Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.

Source

lambdaflows

lambdaflows/freely

Ouvrir le dépôt GitHub Voir les dépôts du créateur

Téléchargement

Métiers associésSOC

Basé sur la classification professionnelle SOC

Architectes de bases de donnéesProfessions informatiques et mathématiques·SOC 15-1243

Explorateur de fichiers

7 fichiers

SKILL.md

readonly

name	pg-aiguide
description	PostgreSQL and TimescaleDB skill collection from Timescale's pg-aiguide. Covers table design, hypertables, pgvector semantic search, and hybrid text search. Trigger when user asks to: - Design PostgreSQL tables or schemas - Work with TimescaleDB hypertables - Implement semantic search with pgvector - Set up hybrid text search in PostgreSQL - Migrate tables to hypertables

PostgreSQL AI Guide (Timescale)

This skill aggregates PostgreSQL and TimescaleDB expertise from Timescale's pg-aiguide project.

Sub-skills

Each sub-directory contains a specialized SKILL.md:

design-postgres-tables — General PostgreSQL table design, data types, indexing, constraints, JSONB patterns
find-hypertable-candidates — Identify tables that would benefit from conversion to TimescaleDB hypertables
migrate-postgres-tables-to-hypertables — Step-by-step migration of standard PostgreSQL tables to hypertables
pgvector-semantic-search — Semantic search implementation using pgvector extension
postgres-hybrid-text-search — Hybrid full-text + semantic search in PostgreSQL
setup-timescaledb-hypertables — Initial setup and configuration of TimescaleDB hypertables

Refer to the individual sub-skill SKILL.md files for detailed instructions and references.

Plus depuis ce dépôt

même dépôt

aws-cdk-development

lambdaflows/freely

AWS Cloud Development Kit (CDK) expert for building cloud infrastructure with TypeScript/Python. Use when creating CDK stacks, defining CDK constructs, implementing infrastructure as code, or when the user mentions CDK, CloudFormation, IaC, cdk synth, cdk deploy, or wants to define AWS infrastructure programmatically. Covers CDK app structure, construct patterns, stack composition, and deployment workflows.

2026-02-2113

aws-cost-operations

lambdaflows/freely

This skill provides AWS cost optimization, monitoring, and operational best practices with integrated MCP servers for billing analysis, cost estimation, observability, and security assessment.

2026-02-2113

github-ops

lambdaflows/freely

Provides comprehensive GitHub operations using gh CLI and GitHub API. Activates when working with pull requests, issues, repositories, workflows, or GitHub API operations including creating/viewing/merging PRs, managing issues, querying API endpoints, and handling GitHub workflows in enterprise or public GitHub environments.

2026-02-2113

design-postgres-tables

lambdaflows/freely

Use this skill for general PostgreSQL table design. **Trigger when user asks to:** - Design PostgreSQL tables, schemas, or data models when creating new tables and when modifying existing ones. - Choose data types, constraints, or indexes for PostgreSQL - Create user tables, order tables, reference tables, or JSONB schemas - Understand PostgreSQL best practices for normalization, constraints, or indexing - Design update-heavy, upsert-heavy, or OLTP-style tables **Keywords:** PostgreSQL schema, table design, data types, PRIMARY KEY, FOREIGN KEY, indexes, B-tree, GIN, JSONB, constraints, normalization, identity columns, partitioning, row-level security Comprehensive reference covering data types, indexing strategies, constraints, JSONB patterns, partitioning, and PostgreSQL-specific best practices.

2026-02-2113

find-hypertable-candidates

lambdaflows/freely

Use this skill to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. **Trigger when user asks to:** - Analyze database tables for hypertable conversion potential - Identify time-series or event tables in an existing schema - Evaluate if a table would benefit from Timescale/TimescaleDB - Audit PostgreSQL tables for migration to Timescale/TimescaleDB/TigerData - Score or rank tables for hypertable candidacy **Keywords:** hypertable candidate, table analysis, migration assessment, Timescale, TimescaleDB, time-series detection, insert-heavy tables, event logs, audit tables Provides SQL queries to analyze table statistics, index patterns, and query patterns. Includes scoring criteria (8+ points = good candidate) and pattern recognition for IoT, events, transactions, and sequential data.

2026-02-2113

migrate-postgres-tables-to-hypertables

lambdaflows/freely

Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation. **Trigger when user asks to:** - Migrate or convert PostgreSQL tables to hypertables - Execute hypertable migration with minimal downtime - Plan blue-green migration for large tables - Validate hypertable migration success - Configure compression after migration **Prerequisites:** Tables already identified as candidates (use find-hypertable-candidates first if needed) **Keywords:** migrate to hypertable, convert table, Timescale, TimescaleDB, blue-green migration, in-place conversion, create_hypertable, migration validation, compression setup Step-by-step migration planning including: partition column selection, chunk interval calculation, PK/constraint handling, migration execution (in-place vs blue-green), and performance validation queries.

2026-02-2113

name	pg-aiguide
description	PostgreSQL and TimescaleDB skill collection from Timescale's pg-aiguide. Covers table design, hypertables, pgvector semantic search, and hybrid text search. Trigger when user asks to: - Design PostgreSQL tables or schemas - Work with TimescaleDB hypertables - Implement semantic search with pgvector - Set up hybrid text search in PostgreSQL - Migrate tables to hypertables

PostgreSQL AI Guide (Timescale)

This skill aggregates PostgreSQL and TimescaleDB expertise from Timescale's pg-aiguide project.

Sub-skills

Each sub-directory contains a specialized SKILL.md:

design-postgres-tables — General PostgreSQL table design, data types, indexing, constraints, JSONB patterns
find-hypertable-candidates — Identify tables that would benefit from conversion to TimescaleDB hypertables
migrate-postgres-tables-to-hypertables — Step-by-step migration of standard PostgreSQL tables to hypertables
pgvector-semantic-search — Semantic search implementation using pgvector extension
postgres-hybrid-text-search — Hybrid full-text + semantic search in PostgreSQL
setup-timescaledb-hypertables — Initial setup and configuration of TimescaleDB hypertables

Refer to the individual sub-skill SKILL.md files for detailed instructions and references.