Brokle Migration Workflow

概要

Provides expert guidance and automated workflows for managing database lifecycles within the Brokle AI observability platform. It streamlines the creation and execution of migrations for both transactional (PostgreSQL) and analytical (ClickHouse) databases, offering a suite of CLI tools for status tracking, safety-checked rollbacks, and data seeding. Whether troubleshooting a 'dirty' migration state or optimizing ClickHouse schemas with ZSTD compression and TTL policies, this skill ensures consistent and reliable database evolution across development and production environments.

主な機能

• Automated recovery procedures for 'dirty' database states and failed migration attempts
• 3 GitHub stars
• YAML-based data seeding workflows for rapid development and testing environment setup
• Multi-database support for simultaneous PostgreSQL and ClickHouse migration management
• Domain-specific schema guidelines for OTEL-native tracing and high-performance analytics
• Comprehensive CLI suite for status monitoring, dry-run previews, and granular step control

ユースケース

• Architecting and deploying new analytical schemas for LLM observability metrics
• Troubleshooting and recovering from interrupted or failed database migrations
• Populating local or staging environments with standardized seed data for development