What problem does it solve? Modifying a production Postgres schema risks data loss, broken API contracts, and type errors rippling across the codebase. This Skill routes every Drizzle schema change through the correct procedure so migrations stay additive, generated clients stay in sync, and stored data is never silently invalidated. ## Core Features & Use Cases - Change Routing: Directs field/column additions on existing tables to the canonical schema-change-checklist procedure, while handling new tables and other schema changes through shared guardrails. - Contract Synchronization: Enforces updating both request and response OpenAPI shapes, then regenerating checked-in Zod and React Query clients without hand-editing generated output. - Safe Migration & Data Healing: Requires additive-only changes on populated tables, push-force schema application instead of hand-written SQL, and routing to a data-heal playbook when existing rows are affected. - Use Case: When adding a nullable column to a production table, follow the routed checklist to update the Drizzle schema, regenerate API clients, run typechecks, and push the schema without touching live data destructively. ## Quick Start Ask the AI to add a new column to an existing Drizzle table and route the change through the schema change procedure with typechecks and push-force migration.
