Settings Overview
TablePro provides various settings to customize your experience. Access settings via TablePro > Settings or press Cmd+,.
Settings Categories
General Settings
Language
Choose the display language for the TablePro interface:
| Option | Description |
|---|
| System | Follow macOS system language (default) |
| English | English |
| Tiếng Việt | Vietnamese |
Changing the language requires restarting TablePro to take full effect.
Startup Behavior
Control what happens when TablePro launches:
| Option | Description |
|---|
| Show Welcome Screen | Display the welcome screen with recent connections |
| Reopen Last Session | Automatically reconnect to your last database |
Query Execution Timeout
Set a maximum time for queries to run before being cancelled:
| Setting | Default | Range | Description |
|---|
| Query timeout | 60 seconds | 0 — 600 | Maximum seconds to wait for a query. Set to 0 for no limit. |
| Database | Mechanism |
|---|
| PostgreSQL | SET statement_timeout (applies to all statements) |
| MySQL | SET SESSION max_execution_time (applies to SELECT queries) |
| MariaDB | SET SESSION max_statement_time (applies to SELECT queries) |
| SQLite | sqlite3_busy_timeout (applies to lock contention) |
The timeout is applied when a new connection is established. Changing the timeout value requires reconnecting to take effect.
Software Update
Control how TablePro checks for and installs updates:
| Setting | Default | Description |
|---|
| Automatically check for updates | On | Periodically check for new versions in the background |
| Check for Updates… | — | Manually check for updates now |
Data Grid Settings
Configure how data is displayed in the results grid.
Row Height
| Option | Height | Best For |
|---|
| Compact | 20px | Dense data, see more rows |
| Normal | 24px | Balanced view (default) |
| Comfortable | 28px | Better readability |
| Spacious | 32px | Accessibility |
| Format | Example |
|---|
| ISO 8601 | 2024-12-31 23:59:59 |
| ISO Date | 2024-12-31 |
| US Long | 12/31/2024 11:59:59 PM |
| US Short | 12/31/2024 |
| EU Long | 31/12/2024 23:59:59 |
| EU Short | 31/12/2024 |
ISO 8601 format is recommended for consistency, especially when working with international teams.
NULL Display
Customize how NULL values appear:
| Setting | Default | Description |
|---|
| NULL Display | ”NULL” | Text shown for NULL values |
NULL - Standard database notation(null) - Parenthesized∅ - Empty set symbol- Custom text (max 20 characters)
Page Size
Set the default number of rows loaded per page:
| Range | Minimum | Maximum | Default |
|---|
| Page Size | 10 | 100,000 | 1,000 |
Larger page sizes use more memory but show more data at once.
Validation ranges:
- Page Size: 10 — 100,000 rows (values outside this range are clamped)
- NULL Display: Maximum 20 characters, no newlines or tabs allowed
Alternate Row Colors
| Option | Description |
|---|
| On | Zebra striping for easier scanning |
| Off | Uniform background color |
History Settings
Control query history retention.
Maximum Entries
| Setting | Default | Description |
|---|
| Max Entries | 10,000 | Maximum queries to keep |
0 for unlimited history.
Maximum Days
| Setting | Default | Description |
|---|
| Max Days | 90 | Delete queries older than this |
0 to keep history forever.
Auto Cleanup
| Option | Description |
|---|
| On | Automatically remove old entries (default) |
| Off | Manual cleanup only |
Disabling auto cleanup with unlimited entries may cause the history database to grow very large over time.
Clear History
To clear all query history:
- Open Settings > History
- Click Clear All History
- Confirm the action
License Settings
Manage your TablePro license from the License tab in Settings.
Activating a License
- Open Settings (
Cmd+,) and select the License tab
- Enter your license key in the text field
- Click Activate
Once activated, the tab displays your registered email and license key.
Deactivating a License
To remove the license from this machine:
- Open Settings > License
- Click Deactivate…
- Confirm the action
Deactivating frees up the activation slot so you can use the license on a different machine.
Offline Use
TablePro validates your license locally using a cryptographic signature. No internet connection is required for day-to-day use after activation. The app periodically re-validates with the server (every 7 days) to check for updates.
Settings Storage
Settings are stored in:
~/Library/Preferences/com.TablePro.plist
Resetting Settings
To reset all settings to defaults:
# Remove preferences file
rm ~/Library/Preferences/com.TablePro.plist
# Remove cached settings
rm -rf ~/Library/Caches/com.TablePro
Resetting preferences will not affect your saved connections or query history.
Settings by Feature
| Setting | Location | Description |
|---|
| Language | General | App display language |
| Startup behavior | General | What to do on launch |
| Query timeout | General | Maximum query execution time |
| Auto-check updates | General | Check for updates automatically |
| Auto-reconnect | Connections | Reconnect on disconnect |
| Setting | Location | Description |
|---|
| Font family | Editor | Monospace font choice |
| Font size | Editor | Text size (11—18 pt, clamped to range) |
| Line numbers | Editor | Show/hide line numbers |
| Word wrap | Editor | Wrap long lines |
| Tab width | Editor | Spaces per tab (1—16) |
| Setting | Location | Description |
|---|
| Theme | Appearance | Light/Dark/System |
| Accent color | Appearance | UI accent color |
| Row height | Data Grid | Grid row height |
| Date format | Data Grid | Date display format |
| Setting | Location | Description |
|---|
| Default column | Filters | Column pre-selected for new filters (Raw SQL, Primary Key, Any Column) |
| Default operator | Filters | Operator pre-selected for new filters |
| Panel state | Filters | Filter panel behavior on open (Hidden, Always Show, Restore Last) |
Keyboard Shortcut
Open settings quickly:
| Action | Shortcut |
|---|
| Open Settings | Cmd+, |
Related Pages
