database

Database Workflow Bundle

Overview

Comprehensive database workflow for database design, development, optimization, migrations, and data engineering. Covers SQL, NoSQL, and modern data platforms.

When to Use This Workflow

Use this workflow when:

• Designing database schemas
• Implementing database migrations
• Optimizing query performance
• Setting up data pipelines
• Managing database operations
• Implementing data quality

Workflow Phases

Phase 1: Database Design

Skills to Invoke

• database-architect - Database architecture
• database-design - Schema design
• postgresql - PostgreSQL design
• nosql-expert - NoSQL design

Actions

1. Gather requirements
2. Design schema
3. Define relationships
4. Plan indexing strategy
5. Design for scalability

Copy-Paste Prompts

Use @database-architect to design database schema

Use @postgresql to design PostgreSQL schema

Phase 2: Database Implementation

Skills to Invoke

• prisma-expert - Prisma ORM
• database-migrations-sql-migrations - SQL migrations
• neon-postgres - Serverless Postgres

Actions

1. Set up database connection
2. Configure ORM
3. Create migrations
4. Implement models
5. Set up seed data

Copy-Paste Prompts

Use @prisma-expert to set up Prisma ORM

Use @database-migrations-sql-migrations to create migrations

Phase 3: Query Optimization

Skills to Invoke

• database-optimizer - Database optimization
• sql-optimization-patterns - SQL optimization
• postgres-best-practices - PostgreSQL optimization

Actions

1. Analyze slow queries
2. Review execution plans
3. Optimize indexes
4. Refactor queries
5. Implement caching

Copy-Paste Prompts

Use @database-optimizer to optimize database performance

Use @sql-optimization-patterns to optimize SQL queries

Phase 4: Data Migration

Skills to Invoke

• database-migration - Database migration
• framework-migration-code-migrate - Code migration

Actions

1. Plan migration strategy
2. Create migration scripts
3. Test migration
4. Execute migration
5. Verify data integrity

Copy-Paste Prompts

Use @database-migration to plan database migration

Phase 5: Data Pipeline Development

Skills to Invoke

• data-engineer - Data engineering
• data-engineering-data-pipeline - Data pipelines
• airflow-dag-patterns - Airflow workflows
• dbt-transformation-patterns - dbt transformations

Actions

1. Design data pipeline
2. Set up data ingestion
3. Implement transformations
4. Configure scheduling
5. Set up monitoring

Copy-Paste Prompts

Use @data-engineer to design data pipeline

Use @airflow-dag-patterns to create Airflow DAGs

Phase 6: Data Quality

Skills to Invoke

• data-quality-frameworks - Data quality
• data-engineering-data-driven-feature - Data-driven features

Actions

1. Define quality metrics
2. Implement validation
3. Set up monitoring
4. Create alerts
5. Document standards

Copy-Paste Prompts

Use @data-quality-frameworks to implement data quality checks

Phase 7: Database Operations

Skills to Invoke

• database-admin - Database administration
• backup-automation - Backup automation

Actions

1. Set up backups
2. Configure replication
3. Monitor performance
4. Plan capacity
5. Implement security

Copy-Paste Prompts

Use @database-admin to manage database operations

Database Technology Workflows

PostgreSQL

Skills: postgresql, postgres-best-practices, neon-postgres, prisma-expert

MongoDB

Skills: nosql-expert, azure-cosmos-db-py

Redis

Skills: bullmq-specialist, upstash-qstash

Data Warehousing

Skills: clickhouse-io, dbt-transformation-patterns

Operational boundaries

Select only needed phases and read the actual specialized skill before use. For migrations, identify the exact database/account, backup and tested restore path, lock/downtime effects and rollback or forward-repair plan. Rehearse against representative nonproduction data and verify row counts/invariants and application compatibility. Use least-privileged credentials and synthetic seeds; do not export private production records as test data. Query-plan commands that execute statements need the same scope as those statements. A configured backup is not a verified restore.

Quality Gates

• Schema designed and reviewed
• Migrations tested
• Performance benchmarks met
• Backups configured
• Monitoring in place
• Documentation complete

Related Workflow Bundles

• development - Application development
• cloud-devops - Infrastructure
• ai-ml - AI/ML data pipelines
• testing-qa - Data testing

Limitations

• Use this skill only when the task clearly matches the scope described above.
• Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
• Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.