Schema Evolution
Manage database schema changes while maintaining backwards compatibility. Handle migrations, versioning, and zero-downtime deployments. Use when evolving data models in production systems.
Install
/plugin marketplace add sethdford/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add sethdford/claude-skills --skill schema-evolutiongit clone --depth 1 https://github.com/sethdford/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/architect/data-architecture/skills/schema-evolution ~/.claude/skills/schema-evolutionPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Schema Evolution Evolve database schemas safely while maintaining backwards compatibility and minimizing downtime. ## Context You are planning schema changes in production systems. Design migrations that don't break deployed clients or services. Read current schemas, deployment frequency, and rollback requirements. ## Domain Context Based on production database migration best practices: - **Backwards Compatibility**: Old code continues working with new schema; new code works with both - **Forwards Compatibility**: New code can read old data; gracefully handles missing fields - **Zero-Downtime Deployment**: Database changes don't require application downtime - **Additive Changes**: Adding columns/tables is safe; dropping/renaming requires care - **Dual-Write Pattern**: Write to both old and new schema during migration; switch reads ## Instructions 1. **Plan Phase 1 (Additive)**: Add new columns/tables. Code ignores new columns for now. Deploy database changes. All existing code still works. 2. **Plan Phase 2 (Dual Write)**: Update application code to write to both old and new schema. Reads can use either. Let data double-write for period (hours to days). 3. **Plan Phase 3 (Migrate Data)**: Background job migrates existing data to new schema. Backfill new fields from old data via transformation. 4. **Plan Phase 4 (Code Switch)**: Update code to read from new schema, write to both. Gradually shift reads: 10% new, 90% old → 50/50 → 100% new.
Details
- Skill name
schema-evolution- Repository
- sethdford/claude-skills
- Path
architect/data-architecture/skills/schema-evolution/SKILL.md- License
- MIT
- Repo updated
- 11 March 2026
FAQ
What does the Schema Evolution skill do?
Manage database schema changes while maintaining backwards compatibility. Handle migrations, versioning, and zero-downtime deployments. Use when evolving data models in production systems.
How do I install the Schema Evolution skill?
Claude Code plugin: /plugin marketplace add sethdford/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Schema Evolution popular?
It lives in sethdford/claude-skills, which has 48 GitHub stars and 10 forks.
Related skills
A B Test Design
48sethdford/claude-skills
Design rigorous A/B tests with hypotheses, variants, metrics, and sample size calculations.
A B Test Design Pm
48sethdford/claude-skills
Analytics and experimentation skill for product managers.
Abuse Case Design
48sethdford/claude-skills
Design abuse cases (negative use cases) showing how attackers misuse system features. Use when identifying attacks that exploit intended functionality or business logic flaws.
Storage Selection
48sethdford/claude-skills
Choose the right database technology for specific workloads. Evaluate relational, NoSQL, data warehouses, and search engines. Use when selecting storage systems for new features or optimizing existing ones.
Schema Design
48sethdford/claude-skills
Database schema design with normalization, relationships, constraints, and data integrity.
Architecture Database Scaling
45j4flmao/agent-skills
Use when the user asks how to scale the database, read replicas, table partitioning, sharding, choosing a shard key, Citus, Vitess, resharding or hot partitions. Produces a scaling ladder plan, shard key and routing design. Not for PostgreSQL engine internals (use architecture-postgresql-internals) or NoSQL selection (use data-nosql-database).
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.