Mass writes
| Rule | What it detects | Severity | In CI (offline CLI) |
|---|---|---|---|
VERICTO-001 | DELETE without WHERE clause | Critical | BLOCKED |
VERICTO-002 | DELETE with LIMIT 0 (MySQL, SQLite) | High | BLOCKED |
VERICTO-003 | DELETE with always-true WHERE (1=1, true) | Critical | BLOCKED |
VERICTO-011 | TRUNCATE TABLE | Critical | BLOCKED |
VERICTO-012 | DROP SCHEMA | Critical | BLOCKED |
VERICTO-030 | UPDATE without WHERE on main table | Critical | BLOCKED |
VERICTO-031 | UPDATE without WHERE inside CTE | High | — |
VERICTO-033 | DELETE without WHERE in subquery or CTE | High | — |
VERICTO-040 | INSERT INTO … SELECT without filter | High | BLOCKED |
VERICTO-042 | UPDATE without WHERE clause | Critical | — |
VERICTO-083 | MERGE | High | BLOCKED |
VERICTO-084 | CREATE TABLE AS SELECT | High | BLOCKED |
Schema changes
| Rule | What it detects | Severity | In CI (offline CLI) |
|---|---|---|---|
VERICTO-010 | DROP TABLE or DROP DATABASE | Critical | FLAGGED |
VERICTO-013 | DROP INDEX without IF EXISTS | High | FLAGGED |
VERICTO-015 | ALTER TABLE DROP COLUMN | High | FLAGGED |
VERICTO-016 | ALTER TABLE RENAME (table or column) | High | FLAGGED |
VERICTO-017 | ALTER TABLE DROP CONSTRAINT (FK/PK/CHECK) | High | FLAGGED |
VERICTO-018 | ALTER TABLE ALTER COLUMN TYPE | High | FLAGGED |
VERICTO-019 | ALTER TABLE DISABLE TRIGGER / RLS | High | FLAGGED |
VERICTO-094 | Recovery reduced (Snowflake) | High | BLOCKED |
VERICTO-099 | Safety PRAGMA (SQLite) | High | BLOCKED |
Security
| Rule | What it detects | Severity | In CI (offline CLI) |
|---|---|---|---|
VERICTO-070 | Use of SLEEP() or PG_SLEEP() | High | BLOCKED |
VERICTO-080 | COPY … TO/FROM PROGRAM (shell execution) | Critical | BLOCKED |
VERICTO-081 | DO anonymous code block | Critical | BLOCKED |
VERICTO-082 | GRANT / REVOKE | High | BLOCKED |
VERICTO-085 | Read of a sensitive column | High | — |
VERICTO-086 | SQL text that MySQL and the engine would read differently (MySQL) | Critical | — |
VERICTO-087 | Access outside the agent's allowlist | High | — |
VERICTO-090 | SQL injection: OR tautology in WHERE (OR 1=1) | Critical | BLOCKED |
VERICTO-091 | Stage unload or file transfer (Snowflake) | Critical | BLOCKED |
VERICTO-092 | External stage or integration (Snowflake) | Critical | BLOCKED |
VERICTO-093 | Share to another account (Snowflake) | Critical | BLOCKED |
VERICTO-096 | Code that runs later (Snowflake) | High | BLOCKED |
VERICTO-097 | Role switch (Snowflake) | High | BLOCKED |
VERICTO-098 | ATTACH DATABASE (SQLite) | High | BLOCKED |
VERICTO-100 | Extension loading or file functions (SQLite) | Critical | BLOCKED |
VERICTO-101 | VACUUM INTO (SQLite) | High | BLOCKED |
Performance
| Rule | What it detects | Severity | In CI (offline CLI) |
|---|---|---|---|
VERICTO-050 | SELECT without LIMIT | Medium | FLAGGED |
VERICTO-051 | SELECT * without WHERE clause | Medium | FLAGGED |
VERICTO-060 | INSERT without explicit columns | Low | MONITORED |
VERICTO-061 | INSERT batch with more than 10k rows | Medium | FLAGGED |
VERICTO-095 | Warehouse cost (Snowflake) | High | BLOCKED |
For the whole catalogue on one page, with dialects and incident families, see the rules reference.