What problem does it solve?
This Skill prevents Pixeltable schema drift by standardizing how migrations are authored, validated, and reflected in the canonical schema documentation.
Core Features & Use Cases
- Write-once migration discipline: Ensures new tables and columns are added only via sequential numbered migrations (0015+), never by editing immutable 0001–0014.
- Idempotent schema authoring: Uses
_helpers.py (ensure_namespace, ensure_table, ensure_column, assert_ownership) to enforce ownership rules and consistent table/column creation.
- Docs-drift and correctness scoring: Runs the pre-commit docs-drift validator and then the schema scoring script to measure completeness, geometry/path correctness, and doc synchronization.
- Canonical metadata upkeep: Updates
meta/SCHEMA.md and meta/ARCHITECTURE.md alongside migration changes so the repo remains discoverable and verifiable.
Quick Start
Ask the AI to create the next numbered migration for adding a new lattice/* Pixeltable table or column, then update meta/SCHEMA.md and run the docs-drift check and schema score before proposing a commit.