​

Safe Mode

Safe Mode is a per-connection setting that controls how TablePro handles query execution. Each connection can have its own level, from unrestricted access to complete write protection. Set the safe mode level when creating or editing a connection in the connection form.

​

Levels

TablePro provides 6 graduated safe mode levels: New connections default to Silent.

​

How It Works

​

Silent

No restrictions. Queries execute immediately. TablePro still shows its built-in dangerous query warning for DROP, TRUNCATE, and DELETE-without-WHERE statements.

​

Alert

A confirmation dialog appears before executing write queries (INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER, etc.). The dialog shows a preview of the SQL to be executed. Read queries run without prompts.

​

Alert (Full)

Same as Alert, but the confirmation dialog appears for ALL queries, including SELECT statements. Useful when you want to review every query before execution.

​

Safe Mode

Like Alert, but after confirming the dialog, you must also authenticate with Touch ID or your macOS password. Falls back to system password if Touch ID is unavailable.

​

Safe Mode (Full)

Combines Alert (Full) and Safe Mode: every query requires both a confirmation dialog and Touch ID/password authentication.

​

Read-Only

All write operations are blocked. The UI disables:

• Inline cell editing
• Adding, deleting, and duplicating rows
• Table truncate and drop operations
• Import functionality

Read queries (SELECT) execute normally. NoSQL databases (MongoDB, Redis, etc.) can’t be parsed for read vs. write operations, so all operations are treated as writes. This means every query in Alert/Safe Mode triggers a confirmation, and Read-Only blocks everything. The current safe mode level is shown as a badge in the toolbar. Click it to change levels. Safe mode gates apply to query execution, saving cell edits, table operations, and sidebar changes. The Silent level still shows dangerous query warnings (DROP/TRUNCATE/DELETE-without-WHERE).