io.github.cxk280/locksmith

Please inspect this PostgreSQL migration script, identify operations that may cause long table locks or block writes, and suggest safer rewrites: ALTER TABLE orders ADD COLUMN status TEXT NOT NULL DEFAULT 'new'; CREATE INDEX idx_orders_created_at ON orders(created_at);

Identifies risky locking operations, explains why they are risky, and provides lower-lock alternative rewrites.

I’m deploying this set of database migrations to production. Run a lock-risk preflight check, list issues by severity, and mark which statements should use CONCURRENTLY, be batched, or be split into separate migrations.

Returns a severity-ranked risk list and migration optimization recommendations suitable for production.

Based on the following PostgreSQL migration SQL, summarize unsafe locking patterns and turn them into team guideline recommendations, including preferred patterns and anti-patterns to avoid.

Extracts common dangerous patterns and produces a reusable database migration best-practices checklist.