All Rules

80 safety rules across 4 categories. 77 free, 3 Pro-only.

Lock Safety — Critical

ID	Name	Severity	Fix
MP001	require-concurrent-index-creation	critical	auto
MP002	require-check-not-null-pattern	critical
MP003	volatile-default-table-rewrite	critical
MP004	require-lock-timeout	critical	auto
MP005	require-not-valid-foreign-key	critical
MP006	no-vacuum-full	critical
MP007	no-column-type-change	critical
MP008	no-multi-ddl-transaction	critical
MP009	require-drop-index-concurrently	warning	auto
MP010	no-rename-column	warning
MP011	unbatched-data-backfill	warning
MP012	no-enum-add-in-transaction	warning
MP015	no-add-column-serial	warning
MP018	no-force-set-not-null	warning
MP021	require-concurrent-reindex	warning	auto
MP025	ban-concurrent-in-transaction	critical
MP026	ban-drop-table	critical
MP027	disallowed-unique-constraint	critical
MP028	no-rename-table	warning
MP029	ban-drop-not-null	warning
MP030	require-not-valid-check	critical	auto
MP031	ban-exclusion-constraint	critical
MP032	ban-cluster	critical
MP033	require-concurrent-refresh-matview	warning	auto
MP046	require-concurrent-detach-partition	critical	auto
MP047	ban-set-logged-unlogged	critical
MP049	require-partition-key-in-pk	critical
MP062	ban-add-generated-stored-column	critical
MP064	ban-disable-trigger	critical
MP065	ban-lock-table	critical
MP069	warn-fk-lock-both-tables	warning
MP072	warn-partition-default-scan	warning
MP073	ban-superuser-role	critical

ID	Name	Severity
MP013	high-traffic-table-ddlPRO	critical
MP014	large-table-ddlPRO	critical
MP019	no-exclusive-lock-high-connectionsPRO	critical

ID	Name	Severity
MP017	no-drop-column	warning
MP022	no-drop-cascade	warning
MP024	no-enum-value-removal	warning
MP034	ban-drop-database	critical
MP035	ban-drop-schema	critical
MP036	ban-truncate-cascade	critical
MP044	no-data-loss-type-narrowing	warning
MP067	warn-backfill-no-batching	warning
MP071	ban-rename-in-use-column	warning
MP080	ban-data-in-migration	warning

ID	Name	Severity	Fix
MP016	require-index-on-fk	warning
MP020	require-statement-timeout	warning	auto
MP023	require-if-not-exists	warning	auto
MP037	prefer-text-over-varchar	warning	auto
MP038	prefer-bigint-over-int	warning
MP039	prefer-identity-over-serial	warning
MP040	prefer-timestamptz	warning	auto
MP041	ban-char-field	warning	auto
MP042	require-index-name	warning
MP043	ban-domain-constraint	warning
MP045	require-primary-key	warning
MP048	ban-alter-default-volatile	warning
MP050	prefer-hnsw-over-ivfflat	warning
MP051	require-spatial-index	warning
MP061	suboptimal-column-order	warning
MP063	warn-do-block-ddl	warning
MP066	warn-autovacuum-disabled	warning
MP068	warn-integer-pk-capacity	warning
MP070	warn-concurrent-index-invalid	warning
MP074	require-deferrable-fk	warning
MP075	warn-toast-bloat-risk	warning
MP076	warn-xid-consuming-retry	warning
MP077	prefer-lz4-toast-compression	warning
MP078	warn-extension-version-pin	warning
MP079	warn-rls-policy-completeness	warning