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

0•

Database Management

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

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

01Structured Drizzle migration workflows for SQLite column and table updates

02Versioned snapshot handling to maintain Automerge compatibility across updates

03Automated testing patterns for reducer logic and persistence loaders

04Automated classification of schema-only, event payload, and backfill changes

05Deterministic backfill logic via event-log reducers to preserve history

060 GitHub stars

Use Cases

01Refactoring local SQLite persistence structures while maintaining locale-neutral data

02Adding or removing fields from CRM entity schemas without breaking existing snapshots

03Implementing data backfills for new derived values across distributed client states

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add masked-kunsiquat/crm-orbit2 data-migration

For use in Claude.ai and ChatGPT

Download Skill