Managed vector database for production AI applications. Fully managed, auto-scaling, with hybrid search (dense + sparse), metadata filtering, and namespaces. Low latency (<100ms p95). Use for production RAG, recommendation systems, or semantic search at scale. Best for serverless, managed infrastructure.
Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention policies, and continuous aggregates. Instructions for selecting: partition columns, segment_by columns, order_by columns, chunk time interval, real-time aggregation.
Generate database-agnostic Wheels migrations for creating tables, altering schemas, and managing database changes. Use when creating or modifying database schema, adding tables, columns, indexes, or foreign keys. Prevents database-specific SQL and ensures cross-database compatibility.
Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables
Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation
Guide for researching SQL syntax and behavior for database backends. Use when you need to research how a SQL function, command, or feature works in a specific database before implementing it in dbplyr.
Explain, optimise, or translate SQL queries into plain language. Use when asked to explain a SQL query, optimise slow SQL, write a data dictionary, translate SQL to plain English for non-technical stakeholders, or review a query for correctness and performance. Works across PostgreSQL, MySQL, BigQuery, Snowflake, and standard SQL.
Database schema design, migrations, query optimization with SQL, Exposed ORM, Flyway. Use for database, migration, schema, sql, flyway tags. Provides migration patterns, validation commands, rollback strategies.
Analyzes database migration scripts for risk: lock contention, downtime estimation, rollback strategy, and deployment recommendations. Classifies DDL and DML operations by lock type and duration, identifies irreversible changes, generates rollback scripts, and produces pre/post validation queries. Triggers on: "analyze this migration", "migration risk", "is this migration safe", "schema change risk", "DDL risk", "downtime for this migration", "lock risk", "rollback strategy", "how to roll back", "migration review", "alter table risk". Use this skill when reviewing database migrations before deployment.
Analyzes SQL queries for performance issues: missing indexes, N+1 patterns, suboptimal joins, full table scans. Interprets EXPLAIN output, detects anti-patterns, recommends indexes, and rewrites queries with detailed explanations of each optimization. Triggers on: "optimize this query", "slow query", "query performance", "add indexes", "index recommendation", "explain plan", "query plan", "N+1 query", "fix this SQL", "SQL performance", "optimize SQL", "why is this query slow", "index strategy". Use this skill when given a SQL query that needs performance analysis or optimization.
Check and analyze upstream Storybook repository changes that may need to be synced to storybook-rsbuild. Use this skill whenever the user wants to check for upstream Storybook changes, review what's new in the official Storybook repo, identify changes needing sync, or compare storybook-rsbuild against the upstream. Activate for phrases like "check upstream", "sync check", "storybook changes", "need to sync", "what changed upstream", or any mention of tracking changes from storybookjs/storybook. Even casual mentions like "anything new in storybook?" should trigger this skill.
SQL generation reference for SimpleORM — how TSimpleSQL builds queries, pagination by dialect, soft delete behavior.
Creates EF Core migrations for master or tenant databases. Use when adding new entities, modifying existing ones, or changing relationships. Follow the workflow to ensure correct migration generation and application.
ComfyUI V1 to V3 node migration - converting legacy nodes to the V3 API. Use when migrating existing custom nodes from V1 to V3, understanding differences between API versions, or modernizing node code.
Search memory using qmd (BM25 + optional vector) and compaction tree traversal. Use ROOT.md to decide whether to search memory or look externally. Always check memory before external lookups.
Drizzle ORM database migration workflow. Use when making schema changes, adding columns/tables, or modifying the database. Triggers include "add a column", "create a table", "schema change", "migration", "db change", or any task that modifies drizzle schema files.
Use when querying, modifying, or investigating database state — enforces schema-first approach and mutation safety
Use to design measurement, alerting, and reporting for MQL→SQL SLAs.
Nightly memory consolidation — prunes stale entries, merges duplicates, resolves contradictions, rebuilds MEMORY.md index. Use when memory files have accumulated over many sessions and need cleanup. Do NOT use for storing new decisions (use remember) or searching memory (use memory).
Database design and migration patterns for Alembic migrations, schema design (SQL/NoSQL), and database versioning. Use when creating migrations, designing schemas, normalizing data, managing database versions, or handling schema drift.
Установка версии конфигурации. Используй, когда пользователь просит установить версию конфигурации, выставить версию, обновить ConfigDumpInfo или версию в метаданных.
Операции с информационными базами 1С. Используй, когда пользователь просит создать пустую ИБ, обновить базу, выгрузить/загрузить в dt, запретить внешние ресурсы, инициализировать данные ИБ.
