ban-drop-schema

What It Detects

DROP SCHEMA permanently removes the schema and all objects within it.

Why It's Dangerous

DROP SCHEMA removes all tables, views, functions, and other objects in the schema. With CASCADE, this silently destroys everything.

Bad Example

DROP SCHEMA analytics CASCADE;

Good Example

-- Drop objects explicitly, then schema
DROP TABLE analytics.events;
DROP SCHEMA analytics;

Configuration

Disable this rule:

# .migrationpilotrc.yml
rules:
  MP035: false

Or change its severity:

# .migrationpilotrc.yml
rules:
  MP035:
    severity: warning