Agent skill

Schema Drift Handling

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

Stars 163
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/schema-drift

SKILL.md

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

Didn't find tool you were looking for?

Be as detailed as possible for better results