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).
Create and manage database backups across environments
Initialize a PostgreSQL database and user on any configured host
Creates database migrations with proper schema changes, data migrations, and rollback support for various ORMs (Prisma, TypeORM, Alembic, etc.). Use when managing database schema changes.
データベースバックアップ戦略、RPO/RTO設計、復旧ランブック作成、検証運用を体系化するスキル。 多層防御と復旧演習を通じて、復旧準備の抜け漏れを防ぐ。 Anchors: • Database Reliability Engineering / 適用: 信頼性設計 / 目的: 失敗前提の運用整理 • Backup & Recovery (W. Curtis Preston) / 適用: バックアップ戦略 / 目的: 復旧可能性の担保 • Site Reliability Engineering / 適用: RTO/RPO設計 / 目的: 目標と検証の整合 Trigger: Use when designing backup strategies, defining RPO/RTO, drafting recovery runbooks, planning DR drills, or verifying backup readiness. backup strategy, rpo rto, recovery runbook, disaster recovery, backup validation
Create robust, error-proof Prisma seed scripts with comprehensive error handling and validation.
Initialize database infrastructure for new projects
Deploy database migrations safely across environments
When you need to modify the database schema, run migrations, or deploy Supabase changes. Use this for all SQL and Supabase-related tasks.
Create a migration to add, remove, or edit columns, tables, or indexes in the database
Plan and execute data migrations, system migrations, and platform transitions
Validates CakePHP migration files and ensures consistency between migrations, fixtures, and database schemas in multi-database environments
Set up NeonDB PostgreSQL database with Drizzle ORM for a project. Use when the user wants to configure NeonDB or add serverless Postgres.
Test and validate SQLite database migrations and schema changes
Backup database before tests, migrations, or other database operations
Create production-ready Supabase migrations for Ballee following strict naming conventions, idempotent SQL, RLS patterns, and storage bucket policies; use when user requests schema changes, adding columns, RLS policies, database functions, or storage buckets. Note: 852 lines retained as cohesive workflow (splitting would reduce usability).
Implement the repository pattern for database abstraction with sqlx, transactions, and retry logic. Use when building data access layers.
Configure MongoDB connection and test infrastructure. Use when adding MongoDB support to the project. Triggers on "setup mongodb", "add mongodb", "configure database", "mongodb connection".
Django migration best practices for the World of Darkness application. Use when creating data migrations, handling schema changes with existing data, squashing old migrations, testing migrations in CI/CD, or planning multi-step migrations for breaking changes. Triggers on migration work, database schema changes, or data transformation tasks.
Helps create and manage EF Core migrations with proper naming and rollback strategies
Create and manage database migrations using golang-migrate. Use when creating tables, modifying schemas, adding columns, or managing database structure changes.
