Can I use this for complex schema refactoring?

Yes, it provides a step-by-step methodology for breaking complex refactors into multiple safe migrations, including data backfilling and deprecation patterns.

How does this skill prevent data loss?

It enforces 'additive-only' patterns and prohibits destructive actions like DROP TABLE or modifying shipped migrations, ensuring user data is preserved.

What database frameworks does this skill support?

The skill provides patterns and guidance for the most common xOS database frameworks, including SQLite, GRDB, and the modern SwiftData framework.

Does it provide automated testing templates?

Yes, the skill includes specific Swift testing patterns to verify both fresh installations and migration paths from previous app versions.

Axiom Database Migration

Name: Axiom Database Migration
Author: CharlesWiltgen

byCharlesWiltgen

•

233

•

Database Management

Ensures safe database schema evolution and prevents data loss in iOS and macOS applications using SQLite, GRDB, or SwiftData.

Axiom Database Migration provides Claude with battle-tested patterns for managing database migrations in production environments, specifically optimized for the xOS ecosystem. It enforces additive, idempotent, and transactional practices to ensure user data remains intact when updating table structures, adding columns, or refactoring schemas. By following strict safety rules and providing comprehensive testing checklists, it helps developers avoid common pitfalls like constraint failures and data corruption while maintaining an immutable migration history.

Key Features

01Transactional logic for atomic schema updates across all tables

02Additive-only migration patterns to prevent accidental data destruction

03233 GitHub stars

04Idempotency checks to ensure migrations can safely run multiple times

05Comprehensive testing workflows for fresh installs and upgrade paths

06Framework-specific templates for GRDB, SQLite, and SwiftData

Use Cases

01Refactoring complex database schemas while maintaining backward compatibility

02Adding new columns or tables to a live production app without losing user data

03Resolving SQLite NOT NULL and FOREIGN KEY constraint errors during migration

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add charleswiltgen/axiom axiom-database-migration

For use in Claude.ai and ChatGPT

Download Skill