pg-aiguide

Estrelas13

Forks2

Atualizado21 de fevereiro de 2026 às 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

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Fonte

lambdaflows

lambdaflows/freely

Abrir repositório GitHub Ver repositórios do creator

Download

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Arquitetos de banco de dadosInformática e Matemática·SOC 15-1243

Explorador de arquivos

7 arquivos

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.

Mais deste repositório

mesmo repositório

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.