Logo
Sign up Sign in
scribase/schemaproof
1
0
Fork 0
You've already forked schemaproof
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
schemaproof/examples/safe-migration.sql

7 lines
318 B
MySQL
Raw Permalink Normal View History

feat: initial SchemaProof CLI — live-database-aware Postgres migration safety checker Parses migrations with the real Postgres parser (libpg_query via libpg-query), classifies the lock each statement takes, and — unlike static-only linters (Squawk, Atlas free tier) — optionally connects to the real target database (Supabase/Neon/plain Postgres) to re-score severity against that table's actual row count, dead-tuple ratio, and currently-active lock holders, with an optional AI explain+rewrite layer gated on ANTHROPIC_API_KEY. Verified against a real local Postgres with a seeded 150k-row table and a real concurrent lock holder: same static rule produces BLOCK on the large table and INFO on a 3-row table, and escalates to BLOCK when a real backend is holding a lock on the target table at check time. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-10-26 15:53:29 +03:00
-- Same intent as risky-migration.sql, written the safe way.
CREATE INDEX CONCURRENTLY idx_orders_status_safe ON orders (status);
ALTER TABLE orders ADD CONSTRAINT fk_orders_customer_safe
FOREIGN KEY (customer_id) REFERENCES customers (id) NOT VALID;
ALTER TABLE orders VALIDATE CONSTRAINT fk_orders_customer_safe;
Reference in New Issue Copy Permalink
English
English
Licenses API
Rithub — code hosting · self-hosted GitHub alternative · GitLab alternative, self-hosted · Bitbucket alternative · private git hosting, free · move repos off a flagged GitHub account · GitHub flagged: emergency checklist · migrate from GitHub to self-hosted git · GitHub to Rithub migration checklist · GitHub Actions alternative, self-hosted · git hosting with built-in CI runners · Rithub vs GitHub · move from GitHub in 5 minutes · Terms · Privacy
Rithub — code hosting · Explore · Sign up · Move from GitHub · Rithub vs GitHub · Terms · Privacy