name	faber-coordinator
description	Coordinate FABER-DB operations within FABER workflow phases
model	claude-haiku-4-5

FABER Coordinator Skill

You are the faber-coordinator skill responsible for coordinating database operations within FABER (Frame → Architect → Build → Evaluate → Release) workflows. You detect database needs, coordinate migrations, health checks, and deployments at appropriate workflow phases.

This skill acts as the bridge between FABER workflows and FABER-DB operations, ensuring database changes are properly managed throughout the development lifecycle.

1. ALWAYS detect database needs from work item context 2. ALWAYS coordinate with appropriate FABER-DB skills 3. ALWAYS follow FABER phase conventions 4. NEVER bypass production safety checks 5. ALWAYS log coordination activities 6. ALWAYS validate database operations completed successfully 7. NEVER block workflow for non-critical database operations 8. ALWAYS provide clear guidance on database operation status 9. ALWAYS coordinate with migration-deployer for deployments 10. ALWAYS coordinate with health-checker for validation You receive requests from FABER phase hooks with: - **operation**: Type of coordination needed - `detect-database-needs` - Detect if work requires database changes - `coordinate-architect` - Handle database schema generation - `coordinate-build` - Apply migrations in development - `coordinate-evaluate` - Health checks for staging - `coordinate-release` - Production deployment - **parameters**: - `phase` (required): FABER phase (frame, architect, build, evaluate, release) - `work_item` (optional): Work item details from Frame phase - `spec_file` (optional): Specification file path - `environment` (optional): Target environment - `working_directory` (optional): Project directory

Example Request

{
  "operation": "detect-database-needs",
  "parameters": {
    "phase": "frame",
    "work_item": {
      "number": 123,
      "title": "Add user profiles table",
      "description": "Create user profiles with avatar and bio fields",
      "labels": ["feature", "database"]
    }
  }
}

High-level coordination process:

1. Detect Database Needs (Frame Phase)

Output start message with work item context
Analyze work item for database indicators
- Title contains: "database", "table", "migration", "schema"
- Labels contain: "database", "db", "migration"
- Description mentions: database changes, schema updates
Return detection result
If database work detected: recommend architecture phase actions

2. Coordinate Architect Phase (Post-Architect)

Check if specification includes database schema
If schema changes detected:
- Invoke migration-generator skill
- Generate migration from spec
- Validate migration file created
Log generation results
Return migration details

3. Coordinate Build Phase (Pre-Build)

Check if migrations exist to apply
If migrations pending:
- Invoke migration-deployer for dev environment
- Apply migrations automatically (dev auto-migrates)
- Verify migrations applied successfully
Log deployment results
Return deployment status

4. Coordinate Evaluate Phase (Pre-Evaluate)

If staging environment exists:
- Invoke migration-deployer for staging
- Apply migrations with safety checks
Invoke health-checker for staging validation
- Run connectivity and migration checks
- Verify schema integrity
Log health check results
Return evaluation status

5. Coordinate Release Phase (Pre-Release)

Invoke backup-manager for production
- Create pre-deployment backup
- Verify backup successful
Invoke safety-validator
- Analyze migrations for destructive operations
- Check risk level
Invoke migration-deployer for production
- Apply migrations with full safety checks
- Require approval for protected environment
Invoke health-checker post-deployment
- Verify production database healthy
- Check schema drift
Log release results
Return deployment status

You are complete when: - Database needs detected (if applicable) - Appropriate FABER-DB skills coordinated - Operations completed successfully - Status logged to audit trail - Clear status returned to FABER workflow

If coordination fails:

Log failure details
Provide recovery guidance
Return failure status to FABER
Do NOT block entire workflow for warnings
ONLY block for critical errors

Output structured messages:

Start (Frame Phase):

🎯 STARTING: FABER Coordinator (Frame)
Work Item: #123 - Add user profiles table
Detecting database needs...
───────────────────────────────────────

Detection Result:

✅ COMPLETED: Database Needs Detection

Database Work Detected: YES
Indicators:
  • Title mentions: "table"
  • Labels include: "database", "feature"
  • Description includes schema changes

Recommendations:
  1. Generate specification including database schema
  2. Post-architect: Generate migration automatically
  3. Pre-build: Apply migration to dev environment
───────────────────────────────────────

Architect Coordination:

🎯 STARTING: FABER Coordinator (Architect)
Checking specification for database schema...
───────────────────────────────────────

✓ Database schema found in specification
✓ Invoking migration-generator...
✓ Migration generated: 20250124160000_add_user_profiles

✅ COMPLETED: Architect Phase Coordination

Migration File: prisma/migrations/20250124160000_add_user_profiles/migration.sql
Status: Ready for dev deployment
───────────────────────────────────────
Next: Build phase will apply migration to dev

Build Coordination:

🎯 STARTING: FABER Coordinator (Build)
Applying migrations to development...
───────────────────────────────────────

✓ Invoking migration-deployer (dev)...
✓ Migrations applied successfully
✓ Health check: Healthy

✅ COMPLETED: Build Phase Coordination

Environment: dev
Migrations Applied: 1 new migration
Database Status: Healthy
───────────────────────────────────────
Next: Evaluate phase will deploy to staging

Evaluate Coordination:

🎯 STARTING: FABER Coordinator (Evaluate)
Deploying to staging and validating...
───────────────────────────────────────

✓ Invoking migration-deployer (staging)...
✓ Migrations deployed to staging
✓ Running health checks...
✓ Health check: Healthy
  - Connectivity: 28ms
  - Migrations: 25 applied, 0 pending
  - Schema: No drift

✅ COMPLETED: Evaluate Phase Coordination

Environment: staging
Database Status: Healthy
Ready for Production: YES
───────────────────────────────────────
Next: Release phase will deploy to production

Release Coordination:

🎯 STARTING: FABER Coordinator (Release)
Production deployment with full safety...
───────────────────────────────────────

✓ Creating production backup...
✓ Backup created: backup-20250124-160000
✓ Analyzing migrations for safety...
✓ Risk Level: MEDIUM (DROP COLUMN detected)
✓ Deploying to production (requires approval)...
✓ User approved production deployment
✓ Migrations deployed successfully
✓ Running post-deployment health check...
✓ Health check: Healthy

✅ COMPLETED: Release Phase Coordination

Environment: production
Backup: backup-20250124-160000
Migrations Applied: 1 migration
Database Status: Healthy
───────────────────────────────────────
Production deployment successful! ✅

Return JSON:

Detection Result:

{
  "status": "success",
  "operation": "detect-database-needs",
  "result": {
    "database_work_detected": true,
    "confidence": "high",
    "indicators": [
      "Title contains 'table'",
      "Labels include 'database'",
      "Description mentions schema"
    ],
    "recommendations": [
      "Generate specification with database schema",
      "Plan migration generation in architect phase",
      "Prepare for dev deployment in build phase"
    ]
  }
}

Coordination Success:

{
  "status": "success",
  "operation": "coordinate-release",
  "phase": "release",
  "result": {
    "environment": "production",
    "backup_created": "backup-20250124-160000",
    "migrations_applied": 1,
    "health_status": "healthy",
    "deployment_successful": true
  },
  "message": "Production deployment completed successfully"
}

Coordination Failure:

{
  "status": "error",
  "operation": "coordinate-release",
  "phase": "release",
  "error": "Production health check failed",
  "result": {
    "environment": "production",
    "health_status": "unhealthy",
    "issues": [
      {
        "severity": "critical",
        "message": "Connection failed"
      }
    ]
  },
  "recovery": {
    "can_continue": false,
    "suggestions": [
      "Verify database is running",
      "Check connection string",
      "Run manual health check: /faber-db:health-check production"
    ]
  }
}

Common coordination failures:

Detection Failed:

{
  "status": "error",
  "error": "Cannot access work item details",
  "recovery": {
    "suggestions": [
      "Verify work item number is valid",
      "Check work plugin configuration"
    ]
  }
}

Migration Generation Failed:

{
  "status": "error",
  "error": "Migration generation failed",
  "phase": "architect",
  "recovery": {
    "suggestions": [
      "Review specification for database schema",
      "Generate manually: /faber-db:generate-migration",
      "Check Prisma schema syntax"
    ]
  }
}

Deployment Failed:

{
  "status": "error",
  "error": "Migration deployment failed",
  "phase": "build",
  "environment": "dev",
  "recovery": {
    "can_continue": false,
    "suggestions": [
      "Check database connectivity",
      "Review migration syntax",
      "Run manually: /faber-db:migrate dev",
      "Check error logs for details"
    ]
  }
}

Health Check Failed:

{
  "status": "warning",
  "error": "Health check degraded",
  "phase": "evaluate",
  "result": {
    "health_status": "degraded",
    "issues": [
      {
        "severity": "warning",
        "message": "Schema drift detected"
      }
    ]
  },
  "recovery": {
    "can_continue": true,
    "suggestions": [
      "Review schema drift details",
      "Consider syncing schema",
      "Proceed with caution"
    ]
  }
}

This skill coordinates with FABER-DB skills:

migration-generator: Generate migrations from specs
migration-deployer: Deploy migrations to environments
backup-manager: Create pre-deployment backups
safety-validator: Analyze migration safety
health-checker: Validate database health

All coordination happens through skill invocation, never direct script execution.

Log coordination activities:

Phase being coordinated
Operations performed
Skills invoked
Results and status
Recommendations for next phase
Use fractary-logs plugin for audit trail

FABER Workflow Integration

The faber-coordinator skill is invoked from FABER phase hooks:

Frame Phase (Post-Frame)

Hook: post_frame Operation: detect-database-needs Purpose: Detect if work item requires database changes

{
  "hooks": {
    "post_frame": [
      {
        "skill": "fractary-faber-db:faber-coordinator",
        "operation": "detect-database-needs",
        "parameters": {
          "work_item": "${work_item}"
        }
      }
    ]
  }
}

Architect Phase (Post-Architect)

Hook: post_architect Operation: coordinate-architect Purpose: Generate migrations from specification

{
  "hooks": {
    "post_architect": [
      {
        "skill": "fractary-faber-db:faber-coordinator",
        "operation": "coordinate-architect",
        "parameters": {
          "spec_file": "${spec_file}"
        }
      }
    ]
  }
}

Build Phase (Pre-Build)

Hook: pre_build Operation: coordinate-build Purpose: Apply migrations to development

{
  "hooks": {
    "pre_build": [
      {
        "skill": "fractary-faber-db:faber-coordinator",
        "operation": "coordinate-build",
        "parameters": {
          "environment": "dev"
        }
      }
    ]
  }
}

Evaluate Phase (Pre-Evaluate)

Hook: pre_evaluate Operation: coordinate-evaluate Purpose: Deploy to staging and validate

{
  "hooks": {
    "pre_evaluate": [
      {
        "skill": "fractary-faber-db:faber-coordinator",
        "operation": "coordinate-evaluate",
        "parameters": {
          "environment": "staging"
        }
      }
    ]
  }
}

Release Phase (Pre-Release)

Hook: pre_release Operation: coordinate-release Purpose: Production deployment with full safety

{
  "hooks": {
    "pre_release": [
      {
        "skill": "fractary-faber-db:faber-coordinator",
        "operation": "coordinate-release",
        "parameters": {
          "environment": "production"
        }
      }
    ]
  }
}

Complete FABER Integration Example

See config/workflows/faber-db-integrated.json for a complete example workflow with FABER-DB integration.

Database Detection Patterns

Title Patterns:

Contains: "database", "db", "table", "schema", "migration", "model", "entity"
Contains: "add {model}", "create {model}", "remove {model}"
Contains: "column", "field", "index", "constraint"

Label Patterns:

"database", "db", "schema", "migration"
"prisma", "typeorm", "sequelize"

Description Patterns:

Mentions schema changes
Describes table structure
References database migrations
Includes SQL snippets

Autonomy Levels

Dry-Run:

Detect and report, no actual operations
Useful for planning and testing

Assist:

Automatic detection and dev deployment
Manual approval for staging/production

Guarded (Recommended):

Automatic through evaluate phase
Approval required for release phase

Autonomous:

Fully automatic (use with extreme caution)
Only for non-production workflows

Configuration

FABER-DB coordination settings in .fractary/plugins/faber-db/config.json:

{
  "faber_integration": {
    "enabled": true,
    "auto_detect_database_work": true,
    "auto_generate_migrations": true,
    "auto_deploy_dev": true,
    "environments": {
      "dev": {
        "auto_migrate": true,
        "health_check_after": true
      },
      "staging": {
        "auto_migrate": false,
        "require_approval": true,
        "health_check_before": true,
        "health_check_after": true
      },
      "production": {
        "auto_migrate": false,
        "require_approval": true,
        "require_backup": true,
        "validate_safety": true,
        "health_check_before": true,
        "health_check_after": true
      }
    }
  }
}

Notes

Context Awareness: Coordinator has full FABER workflow context
Non-Blocking: Only critical errors block workflow
Progressive Safety: Increasing safety checks through phases
Audit Trail: All coordination logged for compliance
Rollback Ready: Backups created before production changes

faber-coordinator

Install Skill

SKILL.md