Use this agent when reviewing PRs that touch database migrations, data backfills, or any code that transforms production data. This agent validates ID mappings against production reality, checks for swapped values, verifies rollback safety, and ensures data integrity during schema changes. Essential for any migration that involves ID mappings, column renames, or data transformations.
Use this agent when a PR touches production data, migrations, or any behavior that could silently discard or duplicate records. Produces a concrete pre/post-deploy checklist with SQL verification queries, rollback procedures, and monitoring plans. Essential for risky data changes where you need a Go/No-Go decision.
Keep a feature branch up to date with the main branch using rebase. Use this skill whenever the user wants to sync, update, or rebase their feature branch onto main (or master), after another PR has merged, when they are getting behind on main, or when they want to avoid merge conflicts before opening or updating a PR. Trigger on phrases like "sync my branch", "rebase onto main", "pull main into my branch", "update my branch", "I'm behind main", or "pull after the PR merged".
Rebase the current branch into clean conventional commits with proper author attribution. Use when the user wants to clean up a branch's commit history into well-organized conventional commits.
Run and test the example-app against a local PostgreSQL database. USE FOR: starting Postgres via Docker Compose, running SQL migrations, building with code generation, running the example app, verifying generated queries work end-to-end. DO NOT USE FOR: writing unit tests, CI/CD pipeline setup.
Manage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations for any database paradigm.
Manage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations for any database paradigm.
Design PostgreSQL, MongoDB, or Redis schemas with entities, relationships, indexes, constraints, migrations, query optimization, and backward-compatible schema evolution
Provision database infrastructure, initialize migration framework, configure environments, and verify connectivity/migration gates
Aplica ingenieria de software moderna para query optimization practice con foco en robustez, mantenibilidad y excelencia operacional.
Generate database migrations with up/down scripts — Alembic, Flyway, Liquibase, and framework-native migrations.
Create and run database migrations for fancai. Use when changing database schema, adding columns, creating tables, or modifying SQLAlchemy models.
Clone or update the vmware/photon repository and import commit history for all branches (3.0, 4.0, 5.0, 6.0, common, master) into a local SQLite database (photon_commits.db). Use this skill when the blogger droid needs fresh commit data, when the database is missing or stale, or when the user requests a data refresh.
Database management with Prisma ORM. Use for migrations, schema management, seeding, and database queries.
Create virtual machine snapshots for backup and recovery. Use when: - "Create a snapshot of VM [name]" - "Backup VM [name] before upgrade" - "Take a snapshot of [vm]" Validates storage class snapshot support, CSI driver capabilities, and guest agent status before snapshot creation. NOT for VM cloning (use vm-clone to create independent copies).
Guide for drift database in Flutter. Use when building apps with local SQLite storage — type-safe queries, reactive streams, migrations, CRUD. Includes drift_flutter setup, StreamBuilder integration, and cross-platform support.
Complete guide for using drift database library in Dart applications (CLI, server-side, non-Flutter). Use when building Dart apps that need local SQLite database storage or PostgreSQL connection with type-safe queries, reactive streams, migrations, and efficient CRUD operations.
Clone existing virtual machines for testing, scaling, or creating templates. Use when: - "Clone VM [source] to [target]" - "Create a copy of VM [name]" - "Duplicate VM [name] for testing" - "Create 3 copies of template-vm" This skill clones VM configuration and optionally creates new storage or references existing storage. NOT for snapshots (use vm-snapshot for point-in-time backups).
Expert Elasticsearch guide covering index design (mappings, analyzers, sharding), query DSL (full-text, filters, aggregations, fuzzy), indexing patterns (bulk API, ingest pipelines), performance (query profiling, caching, segment management), and operational best practices. Use when building search features, log analytics, or autocomplete with Elasticsearch or OpenSearch.
Redis caching workflow for latency improvement with explicit key strategy, TTL/invalidation policy, and correctness bounds. Use when Redis-backed caching decisions are required for application performance; do not use for repository-wide architecture governance or release management policy.
Django Redis caching with django-cacheops. This skill should be used when implementing caching, adding cache invalidation, optimizing API performance, modifying models that affect cached data, or debugging cache-related issues in the Django backend.
Use this skill to store the chat history to MongoDB
Database specialist covering PostgreSQL, MongoDB, Redis, Oracle, and advanced data patterns for modern applications
