lattice-schema

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.