SQL Safety Proxy v0.2.0-alpha

SQL Safety Proxy v0.2.0-alpha

Adds safe affected-row estimation before risky PostgreSQL mutations are executed.

Added

• Full-table row estimation for UPDATE without WHERE
• Full-table row estimation for DELETE without WHERE
• Filtered row estimation for UPDATE and DELETE
• TRUNCATE impact preview support
• Read-only estimator transactions
• Configurable estimation timeout
• Estimated row counts in popup and blocked-query errors
• SQL classifier test coverage

Verified

• UPDATE users SET active = false;

  • Estimated: 5000 rows
  • Blocked successfully

• UPDATE users SET active = false WHERE id <= 100;

  • Estimated: 100 rows
  • Blocked successfully

Status

Alpha release. PostgreSQL support only for now.