Show HN: DryRun – PostgreSQL MCP and schema advisor that works offline(github.com)2 points·by radimm·3 เดือนที่ผ่านมา·1 commentsgithub.comShow HN: DryRun – PostgreSQL MCP and schema advisor that works offlinehttps://github.com/boringSQL/dryrun3 commentsPost comment[–]radimm·3 เดือนที่ผ่านมาreplyOne of the benefit is that instead of LLM blindly advising you to do> ALTER TABLE customers ALTER COLUMN email SET NOT NULL;it can advise you to-- Step 1: backfill NULLs UPDATE customers SET email = 'unknown-' || id || '@example.com' WHERE email IS NULL;-- Step 2: add constraint without full table scan ALTER TABLE customers ADD CONSTRAINT customers_email_not_null CHECK (email IS NOT NULL) NOT VALID;-- Step 3: validate in the background with a weaker lock ALTER TABLE customers VALIDATE CONSTRAINT customers_email_not_null;[+]radimm·3 เดือนที่ผ่านมา[+]andrewrozumy·3 เดือนที่ผ่านมา
> ALTER TABLE customers ALTER COLUMN email SET NOT NULL;
it can advise you to
-- Step 1: backfill NULLs UPDATE customers SET email = 'unknown-' || id || '@example.com' WHERE email IS NULL;
-- Step 2: add constraint without full table scan ALTER TABLE customers ADD CONSTRAINT customers_email_not_null CHECK (email IS NOT NULL) NOT VALID;
-- Step 3: validate in the background with a weaker lock ALTER TABLE customers VALIDATE CONSTRAINT customers_email_not_null;