# Schema Drift Handling

> See the main Schema Drift Detection skill for comprehensive coverage of schema drift detection and management.

- Skill: `majiayu000/schema-drift-handling` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/schema-drift-handling`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/schema-drift-handling/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/schema-drift-handling

---


# Schema Drift Handling

This skill is covered in detail in the main **Schema Drift Detection** skill.

Please refer to: `43-data-reliability/schema-drift/SKILL.md`

That skill covers:
- What is schema drift and why it matters
- Types of schema changes (column added/removed, data type changed, constraints, table renamed/dropped)
- Schema drift detection (automated monitoring, version tracking, change detection)
- Schema evolution strategies (backward compatibility, forward compatibility, schema versioning)
- Handling schema changes (graceful degradation, data migration, pipeline adaptation)
- Tools and techniques (dbt schema tests, Great Expectations, Monte Carlo, Kafka Schema Registry, Protobuf/Avro)
- Schema change notification (alerts, change logs, impact analysis)
- Database migration best practices (migrations in version control, rolling migrations, zero-downtime)
- Schema documentation (data dictionary, schema changelog, ERD diagrams)
- Testing schema changes
- Real schema drift incidents

---

## Related Skills
- `43-data-reliability/schema-drift` (Main skill)
- `43-data-reliability/schema-management`
- `43-data-reliability/data-contracts`