What technologies does this data migration skill support?

This skill is specifically designed for the CRM Orbit stack, focusing on Automerge for state snapshots and Drizzle ORM for SQLite persistence.

How does it handle backward compatibility?

It implements versioned handling in the load paths and updates persistence loaders to accept older data shapes with default values for new fields.

Does this skill allow direct database mutation?

No, it enforces guardrails where the event log is the source of truth and reducers must remain pure; state is never mutated directly.

Can I use this for data backfills?

Yes, it provides a workflow for emitting migration events or implementing deterministic backfill logic within reducers to handle existing data.

What files are typically modified using this skill?

It primarily targets schema definitions, persistence domains, event logs, and reducer files within the CRM Orbit project structure.

CRM Orbit Data Migrations

Name: CRM Orbit Data Migrations
Author: Masked-Kunsiquat

byMasked-Kunsiquat

Database Management

Streamlines the planning and implementation of complex data migrations for CRM Orbit's Automerge and Drizzle persistence layers.

About

The CRM Orbit Data Migration skill provides a robust framework for managing evolving data structures within the CRM Orbit ecosystem. It specializes in implementing safe, deterministic migrations for local SQLite persistence via Drizzle and distributed state snapshots via Automerge. By guiding developers through classification, persistence updates, and event-log preservation, the skill ensures that schema changes and data backfills never compromise the integrity of the append-only event log or the purity of state reducers. It is particularly useful for developers needing to add fields, change persisted structures, or introduce new events while maintaining strict backward compatibility.

Key Features

Structured Drizzle migration workflows for SQLite column and table updates
Versioned snapshot handling to maintain Automerge compatibility across updates
Automated testing patterns for reducer logic and persistence loaders
Automated classification of schema-only, event payload, and backfill changes
Deterministic backfill logic via event-log reducers to preserve history
0 GitHub stars

Use Cases

Refactoring local SQLite persistence structures while maintaining locale-neutral data
Adding or removing fields from CRM entity schemas without breaking existing snapshots
Implementing data backfills for new derived values across distributed client states

About

Key Features

Structured Drizzle migration workflows for SQLite column and table updates
Versioned snapshot handling to maintain Automerge compatibility across updates
Automated testing patterns for reducer logic and persistence loaders
Automated classification of schema-only, event payload, and backfill changes
Deterministic backfill logic via event-log reducers to preserve history
0 GitHub stars

Use Cases

Refactoring local SQLite persistence structures while maintaining locale-neutral data
Adding or removing fields from CRM entity schemas without breaking existing snapshots
Implementing data backfills for new derived values across distributed client states