Back to Details

database

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Database Workflow Bundle

数据库工作流合集

Overview

概述

Comprehensive database workflow for database design, development, optimization, migrations, and data engineering. Covers SQL, NoSQL, and modern data platforms.
一套涵盖数据库设计、开发、优化、迁移以及数据工程的全面数据库工作流，支持SQL、NoSQL及现代数据平台。

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

阶段1：数据库设计

Skills to Invoke

可调用的技能

  • database-architect
    - Database architecture
  • database-design
    - Schema design
  • postgresql
    - PostgreSQL design
  • nosql-expert
    - NoSQL design
  • database-architect
    - 数据库架构设计
  • database-design
    - 模式设计
  • postgresql
    - PostgreSQL设计
  • nosql-expert
    - NoSQL设计

Actions

操作步骤

  1. Gather requirements
  2. Design schema
  3. Define relationships
  4. Plan indexing strategy
  5. Design for scalability
  1. 收集需求
  2. 设计模式
  3. 定义关联关系
  4. 规划索引策略
  5. 设计可扩展性架构

Copy-Paste Prompts

可复制粘贴的提示词

Use @database-architect to design database schema
Use @postgresql to design PostgreSQL schema
Use @database-architect to design database schema
Use @postgresql to design PostgreSQL schema

Phase 2: Database Implementation

阶段2：数据库实施

Skills to Invoke

可调用的技能

  • prisma-expert
    - Prisma ORM
  • database-migrations-sql-migrations
    - SQL migrations
  • neon-postgres
    - Serverless Postgres
  • prisma-expert
    - Prisma ORM
  • database-migrations-sql-migrations
    - SQL迁移
  • neon-postgres
    - 无服务器Postgres

Actions

操作步骤

  1. Set up database connection
  2. Configure ORM
  3. Create migrations
  4. Implement models
  5. Set up seed data
  1. 建立数据库连接
  2. 配置ORM
  3. 创建迁移脚本
  4. 实现数据模型
  5. 配置初始数据

Copy-Paste Prompts

可复制粘贴的提示词

Use @prisma-expert to set up Prisma ORM
Use @database-migrations-sql-migrations to create migrations
Use @prisma-expert to set up Prisma ORM
Use @database-migrations-sql-migrations to create migrations

Phase 3: Query Optimization

阶段3：查询优化

Skills to Invoke

可调用的技能

  • database-optimizer
    - Database optimization
  • sql-optimization-patterns
    - SQL optimization
  • postgres-best-practices
    - PostgreSQL optimization
  • database-optimizer
    - 数据库优化
  • sql-optimization-patterns
    - SQL优化
  • postgres-best-practices
    - PostgreSQL优化

Actions

操作步骤

  1. Analyze slow queries
  2. Review execution plans
  3. Optimize indexes
  4. Refactor queries
  5. Implement caching
  1. 分析慢查询
  2. 查看执行计划
  3. 优化索引
  4. 重构查询语句
  5. 实施缓存策略

Copy-Paste Prompts

可复制粘贴的提示词

Use @database-optimizer to optimize database performance
Use @sql-optimization-patterns to optimize SQL queries
Use @database-optimizer to optimize database performance
Use @sql-optimization-patterns to optimize SQL queries

Phase 4: Data Migration

阶段4：数据迁移

Skills to Invoke

可调用的技能

  • database-migration
    - Database migration
  • framework-migration-code-migrate
    - Code migration
  • database-migration
    - 数据库迁移
  • framework-migration-code-migrate
    - 代码迁移

Actions

操作步骤

  1. Plan migration strategy
  2. Create migration scripts
  3. Test migration
  4. Execute migration
  5. Verify data integrity
  1. 规划迁移策略
  2. 创建迁移脚本
  3. 测试迁移流程
  4. 执行迁移操作
  5. 验证数据完整性

Copy-Paste Prompts

可复制粘贴的提示词

Use @database-migration to plan database migration
Use @database-migration to plan database migration

Phase 5: Data Pipeline Development

阶段5：数据管道开发

Skills to Invoke

可调用的技能

  • data-engineer
    - Data engineering
  • data-engineering-data-pipeline
    - Data pipelines
  • airflow-dag-patterns
    - Airflow workflows
  • dbt-transformation-patterns
    - dbt transformations
  • data-engineer
    - 数据工程
  • data-engineering-data-pipeline
    - 数据管道
  • airflow-dag-patterns
    - Airflow工作流
  • dbt-transformation-patterns
    - dbt数据转换

Actions

操作步骤

  1. Design data pipeline
  2. Set up data ingestion
  3. Implement transformations
  4. Configure scheduling
  5. Set up monitoring
  1. 设计数据管道
  2. 搭建数据采集系统
  3. 实现数据转换
  4. 配置调度任务
  5. 部署监控机制

Copy-Paste Prompts

可复制粘贴的提示词

Use @data-engineer to design data pipeline
Use @airflow-dag-patterns to create Airflow DAGs
Use @data-engineer to design data pipeline
Use @airflow-dag-patterns to create Airflow DAGs

Phase 6: Data Quality

阶段6：数据质量管控

Skills to Invoke

可调用的技能

  • data-quality-frameworks
    - Data quality
  • data-engineering-data-driven-feature
    - Data-driven features
  • data-quality-frameworks
    - 数据质量
  • data-engineering-data-driven-feature
    - 数据驱动特性

Actions

操作步骤

  1. Define quality metrics
  2. Implement validation
  3. Set up monitoring
  4. Create alerts
  5. Document standards
  1. 定义质量指标
  2. 实现数据验证
  3. 部署监控系统
  4. 创建告警机制
  5. 制定标准文档

Copy-Paste Prompts

可复制粘贴的提示词

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

Phase 7: Database Operations

阶段7：数据库运维

Skills to Invoke

可调用的技能

  • database-admin
    - Database administration
  • backup-automation
    - Backup automation
  • database-admin
    - 数据库管理
  • backup-automation
    - 备份自动化

Actions

操作步骤

  1. Set up backups
  2. Configure replication
  3. Monitor performance
  4. Plan capacity
  5. Implement security
  1. 配置备份策略
  2. 搭建复制机制
  3. 监控性能状态
  4. 规划容量扩展
  5. 实施安全管控

Copy-Paste Prompts

可复制粘贴的提示词

Use @database-admin to manage database operations
Use @database-admin to manage database operations

Database Technology Workflows

数据库技术工作流

PostgreSQL

PostgreSQL

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

MongoDB

MongoDB

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

Redis

Redis

Skills: bullmq-specialist, upstash-qstash
Skills: bullmq-specialist, upstash-qstash

Data Warehousing

数据仓库

Skills: clickhouse-io, dbt-transformation-patterns
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
  • development
    - 应用开发
  • cloud-devops
    - 基础设施
  • ai-ml
    - AI/ML数据管道
  • testing-qa
    - 数据测试