Audit Log
The Audit Log tracks important operations performed in Tablen, providing a record of database interactions for security, compliance, and troubleshooting.
Accessing the Audit Log
- Go to Settings and find the Audit Log section
- The audit log is stored locally
What Is Logged
Connection Events
- Connection established
- Connection disconnected
- Connection failed
Query Events
- Query executed (with SQL text)
- Query failed (with error message)
- Query cancelled
Data Modification Events
- Rows inserted
- Rows updated
- Rows deleted
- Table structure changes
Approval Events
- Query submitted for approval
- Query approved
- Query rejected
Administrative Events
- Settings changed
- Plugin installed/uninstalled
- Data exported
Log Entry Format
Each audit log entry contains:
| Field | Description |
|---|---|
| Timestamp | When the event occurred |
| Event Type | Category of the event |
| Description | Human-readable description |
| User | Who performed the action |
| Connection | Which database connection was involved |
| SQL | The SQL query (for query events) |
| Result | Success or failure |
Log Storage
Audit logs are stored locally:
~/Library/Application Support/DBClient/audit_log.json
Retention
- Logs are stored as JSON entries
- The local audit service manages the log file
- Older entries can be cleaned up through settings
Viewing the Log
Filtering
- Filter by event type
- Filter by date range
- Filter by connection
- Search log entries by text
Sorting
- Sort by timestamp (newest or oldest first)
- Sort by event type
Use Cases
Security Auditing
- Track who accessed which databases
- Monitor for unauthorized data modifications
- Review failed connection attempts
Compliance
- Maintain records of data access for regulatory compliance
- Document approval workflows
- Track data exports
Troubleshooting
- Review recent operations before an issue occurred
- Identify failed queries and their error messages
- Trace connection problems
Team Oversight
- Monitor team member activity (Team plan)
- Review approval workflow history
- Track data modifications
Relationship with Other Features
Safe Mode
Safe Mode confirmations are logged in the audit log, recording both the confirmation and the resulting query execution.
Approval Workflow
All approval workflow actions (submit, approve, reject) are logged with full context.
Data Deletion
The "Delete All My Data" action in Settings also deletes the audit log file.
Privacy
- Audit logs are stored locally on your machine
- No audit data is sent to external servers (unless Team plan with server-side features)
- The log contains SQL queries, which may include sensitive data
- Consider the audit log when performing data cleanup