Database Fundamentals

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

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