require-index-name

What It Detects

Indexes without explicit names get auto-generated names that are hard to reference.

Why It's Dangerous

Auto-generated index names like "users_email_idx" are unpredictable across environments. Explicit names make it easier to reference indexes in maintenance operations and documentation.

Bad Example

CREATE INDEX ON users (email);

Good Example

CREATE INDEX idx_users_email ON users (email);

Configuration

Disable this rule:

# .migrationpilotrc.yml
rules:
  MP042: false

Or change its severity:

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