database-manager

What this skill does

# Database Manager - Complete Database Management Workflow

## Overview

This skill provides end-to-end database management services by orchestrating database architects, performance specialists, and data governance experts. It transforms data requirements into optimized database systems with comprehensive design, performance optimization, and operational excellence.

**Key Capabilities:**
- 🏗️ **Database Architecture Design** - Multi-database architecture and schema design
- ⚡ **Performance Optimization** - Query optimization, indexing, and performance tuning
- 🔄 **Data Migration & Replication** - Seamless data migration and replication strategies
- 📊 **Data Governance & Security** - Data quality, security, and compliance management
- 🛡️ **Backup & Recovery** - Comprehensive backup strategies and disaster recovery

## When to Use This Skill

**Perfect for:**
- Database architecture design and implementation
- Schema design and data modeling
- Performance optimization and query tuning
- Data migration and database modernization
- Backup and disaster recovery implementation
- Data governance and compliance management

**Triggers:**
- "Design database architecture for [application]"
- "Optimize database performance for [system]"
- "Implement data migration from [source] to [target]"
- "Set up backup and disaster recovery for databases"
- "Implement data governance and security measures"

## Database Expert Panel

### **Database Architect** (Database Design & Architecture)
- **Focus**: Database architecture, schema design, data modeling
- **Techniques**: Normalization, indexing strategies, data modeling, database patterns
- **Considerations**: Scalability, performance, data integrity, maintainability

### **Performance Specialist** (Database Optimization)
- **Focus**: Query optimization, performance tuning, indexing strategies
- **Techniques**: Query analysis, performance profiling, caching strategies, optimization
- **Considerations**: Response times, throughput, resource utilization, scalability

### **Data Migration Expert** (Migration & Replication)
- **Focus**: Data migration, database replication, data synchronization
- **Techniques**: ETL processes, data transformation, replication strategies, migration planning
- **Considerations**: Data integrity, minimal downtime, data consistency, rollback procedures

### **Data Governance Specialist** (Data Quality & Security)
- **Focus**: Data governance, data quality, security, compliance
- **Techniques**: Data quality management, access control, encryption, compliance frameworks
- **Considerations**: Data privacy, regulatory compliance, audit trails, data classification

### **Backup & Recovery Expert** (Backup & Disaster Recovery)
- **Focus**: Backup strategies, disaster recovery, high availability
- **Techniques**: Backup automation, point-in-time recovery, failover strategies, testing
- **Considerations**: RPO/RTO requirements, data retention, recovery testing, business continuity

## Database Management Workflow

### Phase 1: Database Requirements Analysis & Planning
**Use when**: Starting database design or database modernization

**Tools Used:**
```bash
/sc:analyze database-requirements
Database Architect: database requirements analysis and architecture planning
Performance Specialist: performance requirements and optimization needs
Data Governance Specialist: governance and compliance requirements
```

**Activities:**
- Analyze data requirements and usage patterns
- Define database architecture and technology selection
- Identify performance requirements and scalability needs
- Assess data governance and compliance requirements
- Plan migration strategies and timelines

### Phase 2: Database Architecture & Schema Design
**Use when**: Designing database structure and data models

**Tools Used:**
```bash
/sc:design --type database schema-architecture
Database Architect: comprehensive database design and schema creation
Performance Specialist: performance-optimized schema design
Data Governance Specialist: data classification and security design
```

**Activities:**
- Design database architecture and technology selection
- Create normalized data models and schemas
- Design indexing strategies for optimal performance
- Plan data partitioning and distribution strategies
- Define data relationships and integrity constraints

### Phase 3: Database Implementation & Optimization
**Use when**: Implementing database and optimizing performance

**Tools Used:**
```bash
/sc:implement database-optimization
Performance Specialist: query optimization and performance tuning
Database Architect: database implementation and best practices
Data Governance Specialist: security implementation and access control
```

**Activities:**
- Implement database schema and data models
- Optimize queries and implement indexing strategies
- Configure database parameters for optimal performance
- Implement caching strategies and query optimization
- Set up database monitoring and performance metrics

### Phase 4: Data Migration & Integration
**Use when**: Migrating data or integrating with other systems

**Tools Used:**
```bash
/sc:implement data-migration
Data Migration Expert: migration planning and execution
Database Architect: target database design and validation
Performance Specialist: migration performance optimization
```

**Activities:**
- Design ETL processes and data transformation logic
- Implement data validation and quality checks
- Execute data migration with minimal downtime
- Validate data integrity and consistency
- Implement data synchronization and replication

### Phase 5: Data Governance & Security Implementation
**Use when**: Implementing data governance and security measures

**Tools Used:**
```bash
/sc:implement data-governance
Data Governance Specialist: governance framework implementation
Database Architect: security architecture and access control
Performance Specialist: security-optimized database configuration
```

**Activities:**
- Implement data classification and access controls
- Set up data encryption and security measures
- Create audit trails and compliance reporting
- Implement data quality management processes
- Configure data retention and deletion policies

### Phase 6: Backup & Disaster Recovery Setup
**Use when**: Setting up backup strategies and disaster recovery

**Tools Used:**
```bash
/sc:implement backup-recovery
Backup & Recovery Expert: backup strategy and disaster recovery implementation
Database Architect: recovery architecture and testing
Performance Specialist: backup performance optimization
```

**Activities:**
- Design backup strategies and retention policies
- Implement automated backup procedures
- Set up disaster recovery and failover mechanisms
- Create recovery testing and validation procedures
- Document backup and recovery procedures

## Integration Patterns

### **SuperClaude Command Integration**

| Command | Use Case | Output |
|---------|---------|--------|
| `/sc:design --type database` | Database design | Complete database architecture |
| `/sc:implement database-optimization` | Performance tuning | Optimized database configuration |
| `/sc:implement data-migration` | Data migration | Complete migration solution |
| `/sc:implement data-governance` | Data governance | Governance framework |
| `/sc:implement backup-recovery` | Backup/DR | Backup and disaster recovery |

### **Database Technology Integration**

| Technology | Role | Capabilities |
|------------|------|------------|
| **PostgreSQL** | Relational database | Advanced relational database features |
| **MongoDB** | NoSQL database | Document-oriented database |
| **Redis** | Cache/database | In-memory caching and data store |
| **MySQL** | Relational database | Popular relational database |

### **MCP Server Integration**

| Server | Expertise | Use Case |
|--------|----------|---------|
| **Sequential** | Database reasoning | Complex database design and problem-solving |
| **Web Search** | Database t