Brokle Migration Workflow FAQs

Question 1

What does the Brokle Migration Workflow skill do?

Accepted Answer

This skill provides Claude with specialized capabilities to manage the entire database migration lifecycle for PostgreSQL and ClickHouse. It automates CLI commands for status monitoring, rollbacks, schema enforcement, and rapid environment setup using YAML-based data seeding.

Question 2

When should I use this Claude Code skill?

Accepted Answer

Use this skill when you are creating or managing database schemas for transactional data (PostgreSQL) or high-performance analytics (ClickHouse). It is particularly useful for troubleshooting migration failures, managing 'dirty' database states, or configuring OTEL-native tracing schemas.

Question 3

How does this skill improve my development workflow?

Accepted Answer

It eliminates the manual overhead of managing dual-database migrations. By providing Claude with expert knowledge of ZSTD compression, TTL policies, and partitioning strategies, it ensures your analytics database is optimized for performance while reducing human error during rollbacks.

Question 4

What database-specific optimizations does it provide?

Accepted Answer

The skill includes best practices for PostgreSQL transactional storage and advanced ClickHouse patterns, such as MergeTree engines for analytics, millisecond-precision timestamps (DateTime64), and automated 365-day data retention policies.

Question 5

Can this skill help with failed or 'dirty' migrations?

Accepted Answer

Yes. It includes dedicated recovery procedures to handle failed migration attempts. Claude can use specific 'force' commands and health checks to detect and resolve dirty states, allowing you to reset migration versions safely and resume development.

Brokle Migration Workflow

Brokle Migration Workflow

Key Features

Use Cases

Key Features

Use Cases