database-performance
Database optimization, query performance, indexing strategies, and caching patterns. Use when optimizing queries, designing database schemas, or improving application performance.
Database optimization, query performance, indexing strategies, and caching patterns. Use when optimizing queries, designing database schemas, or improving application performance.
Database migration workflow helper. Use when creating database migrations, modifying SQLAlchemy models, or managing Alembic migrations. Automatically handles model changes, migration creation, and database upgrades.
Эксперт DB replication. Используй для настройки репликации MySQL, PostgreSQL, MongoDB, failover и high availability.
Creates Alembic database migrations safely. Use when schema changes are needed, adding tables, columns, indexes, or modifying database structure.
SQL query patterns, optimization techniques, and best practices for efficient database operations
SQL query optimization, indexing strategies, and EXPLAIN analysis for database performance. WHEN: MUST use for slow queries, EXPLAIN analysis, index design, N+1 problems. Invoke with "/sql-optimization-patterns" or "optimize this query", "analyze EXPLAIN", "fix slow query". WHEN NOT: ORM-specific patterns (use framework skills), application-level caching, database migrations.
Database migrations and schema evolution in Convex. Use when adding new fields, changing data structures, backfilling data, renaming fields, or performing zero-downtime schema changes.
Activate when creating database migrations that enable or disable PostgreSQL extensions. Provides the DO block pattern for cross-environment compatibility between Nhost Cloud, CNPG (CloudNativePG), and other PostgreSQL environments.
Executes database migrations using the postgres MCP server. Use when applying schema changes, running migrations, or updating database structure.
Database design, schema optimization, indexing strategies, and migration management.
Safe database migration creation and management for Supabase PostgreSQL
Create database migrations with schema builder, indexes, foreign keys, and seeders. Use when designing database schema, creating tables, or modifying columns.
Creates database schemas, migrations, queries, and data access layers. Use when implementing database-related tasks. Handles schema design, migrations, CRUD operations, and database optimization.
Rails migrations - schema changes, data migrations, migration commands. Use when creating or modifying database migrations.
Executes database migrations using the postgres MCP server. Use when applying schema changes, running migrations, or updating databese structure.
Writes and tests runtime migrations for state transitions in Moonbeam. Use when handling storage layout changes, renaming or removing storage items, data format changes, pallet index changes, or storage key modifications.
Perform monthly journal migration using hledger close --migrate to close the previous month and open the new month with proper balance assertions and account initialization.
Validate Laravel database configuration and test actual connections. Use when user reports "database connection error", "hosts array is empty", "could not connect to database", or wants to verify database setup is correct.
Making database schema changes to the CMS database. Use when adding columns, tables, running migrations, or updating the backend API and TypeScript types for new database fields.
Manage MySQL database for The Dreamer's Cave. Use for schema, migrations, queries, backup/restore.
Create and manage Doctrine migrations for database schema versioning and deployment. WHEN: Creating migrations (make:migration), running migrations, handling rollbacks, production deployment strategies, schema validation. WHEN NOT: Query optimization (use php-symfony-doctrine-fetch-modes), batch processing (use php-symfony-doctrine-batch-processing), Laravel migrations.
Create Supabase database migrations. Use when user says "add table", "create migration", "update schema", "add column", "database change", or asks to modify the database.