LATTICE Schema Migration Authoring

What problem does it solve?

It prevents Pixeltable schema migrations from drifting out of sync with the canonical schema documentation while ensuring migrations remain write-once and ownership rules are enforced.

Core Features & Use Cases

• Write-once migration discipline: creates new numbered migration files (e.g., 0015+) without modifying immutable migrations 0001–0014.
• Idempotent, helper-only schema changes: authors migrations using _helpers.py functions to ensure namespaces, tables, and columns while enforcing ownership and avoiding forbidden geometry writes.
• Automatic docs-drift control: updates meta/SCHEMA.md, meta/ARCHITECTURE.md, and the LIVE STATE migration count, then runs pre-commit docs validation and the schema scoring ratchet.

Quick Start

Ask the AI to author the next Pixeltable migration for a new lattice/* table or column, update meta/SCHEMA.md and architecture state accordingly, and then run the docs-drift pre-commit check plus the schema score script before you commit.