Motivation & Goal
Prevent accidental data loss and catastrophic schema destruction when executing queries containing destructive DDL or DML statements (DROP DATABASE, DROP TABLE, DROP SCHEMA, TRUNCATE) in the SQL editor.
Proposed Scope
- Implement an AST/Lexer heuristic in the SQL editor execution pipeline to detect destructive commands (
DROP, TRUNCATE).
- Display a high-visibility confirmation modal requiring explicit user action (e.g. typing the target table/database name or clicking 'Confirm Execution') before sending the statement to the database server.
- Allow users to toggle or configure strict safety guards per connection (e.g. strict protection on production connections vs demo/local databases).
- Add unit and widget tests for destructive query detection and confirmation dialog flow.
Motivation & Goal
Prevent accidental data loss and catastrophic schema destruction when executing queries containing destructive DDL or DML statements (
DROP DATABASE,DROP TABLE,DROP SCHEMA,TRUNCATE) in the SQL editor.Proposed Scope
DROP,TRUNCATE).