brokle-migration-workflow

What problem does it solve?

This Skill provides comprehensive guidance for managing database migrations in Brokle, covering both PostgreSQL and ClickHouse, ensuring schema evolution is smooth, safe, and consistent. It prevents database-related downtime and errors.

Core Features & Use Cases

• Migration CLI: Explains how to use the migration CLI for up, down, status, and create operations across different databases.
• Schema Guidelines: Provides best practices for designing PostgreSQL (transactional) and ClickHouse (analytics) schemas, including TTL, partitioning, and compression.
• Seeding Data: Guides on creating and running seed files for development, demo, and testing environments, ensuring consistent data setups.
• Use Case: A developer needs to add a new table to PostgreSQL and a new analytics table to ClickHouse. This skill provides the exact SQL templates, CLI commands, and safety checklists to ensure the migrations are correctly created, applied, and can be rolled back if needed.

Quick Start

I need to create a new PostgreSQL migration to add a features table and a ClickHouse migration for event_logs. Provide the SQL templates for both up and down migrations.