Vericto rules: the SQL that breaks production, and how to stop it

One page per engine rule: what happened, how to recover when you can, the cause, the generic fix, and the real output of vericto check --offline on the rule's example.

Mass writes

RuleWhat it detectsSeverityIn CI (offline CLI)
VERICTO-001DELETE without WHERE clauseCriticalBLOCKED
VERICTO-002DELETE with LIMIT 0 (MySQL, SQLite)HighBLOCKED
VERICTO-003DELETE with always-true WHERE (1=1, true)CriticalBLOCKED
VERICTO-011TRUNCATE TABLECriticalBLOCKED
VERICTO-012DROP SCHEMACriticalBLOCKED
VERICTO-030UPDATE without WHERE on main tableCriticalBLOCKED
VERICTO-031UPDATE without WHERE inside CTEHigh—
VERICTO-033DELETE without WHERE in subquery or CTEHigh—
VERICTO-040INSERT INTO … SELECT without filterHighBLOCKED
VERICTO-042UPDATE without WHERE clauseCritical—
VERICTO-083MERGEHighBLOCKED
VERICTO-084CREATE TABLE AS SELECTHighBLOCKED

Schema changes

RuleWhat it detectsSeverityIn CI (offline CLI)
VERICTO-010DROP TABLE or DROP DATABASECriticalFLAGGED
VERICTO-013DROP INDEX without IF EXISTSHighFLAGGED
VERICTO-015ALTER TABLE DROP COLUMNHighFLAGGED
VERICTO-016ALTER TABLE RENAME (table or column)HighFLAGGED
VERICTO-017ALTER TABLE DROP CONSTRAINT (FK/PK/CHECK)HighFLAGGED
VERICTO-018ALTER TABLE ALTER COLUMN TYPEHighFLAGGED
VERICTO-019ALTER TABLE DISABLE TRIGGER / RLSHighFLAGGED
VERICTO-094Recovery reduced (Snowflake)HighBLOCKED
VERICTO-099Safety PRAGMA (SQLite)HighBLOCKED

Security

RuleWhat it detectsSeverityIn CI (offline CLI)
VERICTO-070Use of SLEEP() or PG_SLEEP()HighBLOCKED
VERICTO-080COPY … TO/FROM PROGRAM (shell execution)CriticalBLOCKED
VERICTO-081DO anonymous code blockCriticalBLOCKED
VERICTO-082GRANT / REVOKEHighBLOCKED
VERICTO-085Read of a sensitive columnHigh—
VERICTO-086SQL text that MySQL and the engine would read differently (MySQL)Critical—
VERICTO-087Access outside the agent's allowlistHigh—
VERICTO-090SQL injection: OR tautology in WHERE (OR 1=1)CriticalBLOCKED
VERICTO-091Stage unload or file transfer (Snowflake)CriticalBLOCKED
VERICTO-092External stage or integration (Snowflake)CriticalBLOCKED
VERICTO-093Share to another account (Snowflake)CriticalBLOCKED
VERICTO-096Code that runs later (Snowflake)HighBLOCKED
VERICTO-097Role switch (Snowflake)HighBLOCKED
VERICTO-098ATTACH DATABASE (SQLite)HighBLOCKED
VERICTO-100Extension loading or file functions (SQLite)CriticalBLOCKED
VERICTO-101VACUUM INTO (SQLite)HighBLOCKED

Performance

RuleWhat it detectsSeverityIn CI (offline CLI)
VERICTO-050SELECT without LIMITMediumFLAGGED
VERICTO-051SELECT * without WHERE clauseMediumFLAGGED
VERICTO-060INSERT without explicit columnsLowMONITORED
VERICTO-061INSERT batch with more than 10k rowsMediumFLAGGED
VERICTO-095Warehouse cost (Snowflake)HighBLOCKED

For the whole catalogue on one page, with dialects and incident families, see the rules reference.