Skip to main content

Settings Overview

Open settings via TablePro > Settings or Cmd+,.
Settings window

Settings Categories

General

Language, startup behavior, updates

Appearance

Themes, colors, and fonts

Editor

SQL editor configuration

Data Grid

Row height, date format, display

Tabs

Tab reuse behavior

Keyboard

Custom shortcuts

AI

AI provider setup

History

History retention

Plugins

Manage drivers

Sync

iCloud sync (Pro)

License

License activation

General Settings

Language

OptionDescription
SystemFollow macOS system language (default)
EnglishEnglish
Tiếng ViệtVietnamese
TürkçeTurkish
Changing the language requires restarting TablePro.

Startup Behavior

OptionDescription
Show Welcome ScreenDisplay the welcome screen with recent connections
Reopen Last SessionAuto-reconnect to your last database

Query Execution Timeout

Set the maximum time a query runs before cancellation:
SettingDefaultRangeDescription
Query timeout60 seconds0 — 600Maximum seconds to wait. 0 means no limit.
The timeout is enforced at the database level:
DatabaseMechanism
PostgreSQLSET statement_timeout (all statements)
MySQLSET SESSION max_execution_time (SELECT queries)
MariaDBSET SESSION max_statement_time (SELECT queries)
SQLitesqlite3_busy_timeout (lock contention)
The timeout applies when a new connection is established. Changing it requires reconnecting.
Query timeout setting

Software Update

SettingDefaultDescription
Automatically check for updatesOnPeriodically check for new versions in the background
Check for Updates…Check right now
TablePro uses Sparkle for updates. When an update is available, a dialog shows release notes and an install option. Also available from the TablePro menu > Check for Updates….

Privacy

SettingDefaultDescription
Share anonymous usage dataOnSends anonymous stats (OS version, architecture, locale, database types) every 24 hours
No personal information, queries, or database content is transmitted. Toggle off at any time.
General settings

Data Grid Settings

Font

SettingDefaultRangeDescription
Font familySystem MonoSystem Mono, SF Mono, Menlo, Monaco, Courier NewMonospace font for data grid cells
Font size13 pt10-18 ptText size in data grid cells
Affects all data grid cells, including NULL placeholders and cell editing overlays. A live preview is shown in the settings panel.
The data grid font is independent of the SQL editor font. You can use different fonts and sizes for each.

Row Height

OptionHeightBest For
Compact20pxDense data, more rows visible
Normal24pxBalanced (default)
Comfortable28pxBetter readability
Spacious32pxAccessibility

Date Format

FormatExample
ISO 86012024-12-31 23:59:59
ISO Date2024-12-31
US Long12/31/2024 11:59:59 PM
US Short12/31/2024
EU Long31/12/2024 23:59:59
EU Short31/12/2024
ISO 8601 is recommended for consistency, especially with international teams.

NULL Display

SettingDefaultDescription
NULL Display”NULL”Text shown for NULL values
Options:
  • NULL - Standard database notation
  • (null) - Parenthesized
  • - Empty set symbol
  • Custom text (max 20 characters)

Page Size

RangeMinimumMaximumDefault
Page Size10100,0001,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

Alternate Row Colors

OptionDescription
OnZebra striping for easier scanning
OffUniform background color

Row Numbers

OptionDescription
OnShow row number column (#) as the first column
OffHide the row number column

Auto-Show Inspector

SettingDefaultDescription
Auto-show inspector on row selectOffOpen the right sidebar automatically when selecting a row in a table tab
Data Grid settings

Tab Settings

Reuse Clean Table Tab

SettingDefaultDescription
Reuse clean table tabOffClicking a new table in the sidebar replaces the current table tab instead of opening a new one
A tab is “clean” when all of these are true:
  • It’s a table tab (not query or create table)
  • Not pinned
  • No unsaved changes
  • You haven’t interacted with it (no sorting, filtering, row selection, etc.)
When off (default), every table click opens a new tab.
Enable this for single-tab browsing, similar to TablePlus’s default behavior.
Tab settings

Preview Tabs

SettingDefaultDescription
Enable preview tabsOnSingle-clicking a table opens a temporary tab that gets replaced on next click
Single-clicking a table opens a preview tab that gets replaced on next click. Double-clicking or interacting with the tab (sorting, filtering, editing) makes it permanent. Preview tabs show “Preview” in the subtitle and are not persisted across restarts.

Keyboard Settings

Customize keyboard shortcuts for menu actions. See Keyboard Shortcuts for full details.

Rebinding Shortcuts

  1. Open Settings > Keyboard
  2. Click the shortcut field next to any action
  3. Press the new key combination
  4. Updates immediately

Conflict Detection

Assigning a shortcut already in use shows a dialog with Cancel or Reassign options. System-reserved shortcuts (Cmd+Q, Cmd+H, Cmd+M, Cmd+,) cannot be reassigned.

Reset to Defaults

Click Reset to Defaults to restore all shortcuts.
Keyboard settings

History Settings

Maximum Entries

SettingDefaultDescription
Max Entries10,000Maximum queries to keep
Set to 0 for unlimited.

Maximum Days

SettingDefaultDescription
Max Days90Delete queries older than this
Set to 0 to keep history forever.

Auto Cleanup

OptionDescription
OnAutomatically remove old entries (default)
OffManual cleanup only
Disabling auto cleanup with unlimited entries may cause the history database to grow very large over time.

Clear History

  1. Open Settings > History
  2. Click Clear All History
  3. Confirm the action
History settings

Plugins Settings

Manage database driver plugins from the Plugins tab in Settings.

Installed Plugins

Split-view: plugin list on the left, details on the right. Each row shows version, capability, and source (built-in or user-installed). Filter by name using the search field. TablePro ships with 3 built-in database driver plugins (MySQL, PostgreSQL, SQLite) and 3 built-in export plugins (CSV, JSON, SQL). Additional plugins are available from the plugin registry and can be installed from the Browse tab or downloaded automatically when you select a database type:
PluginDatabase TypesDefault PortDistribution
MySQLMySQL, MariaDB3306Built-in
PostgreSQLPostgreSQL, Redshift5432Built-in
SQLiteSQLiteBuilt-in
ClickHouseClickHouse8123Registry
SQL ServerSQL Server1433Registry
MongoDBMongoDB27017Registry
RedisRedis6379Registry
DuckDBDuckDBRegistry
OracleOracle1521Registry
Toggle plugins on/off in the detail pane. Disabled plugins hide their database type from the connection dialog.

Plugin Details

Select a plugin to view version, bundle ID, capabilities, database type, and default port. Driver plugins can provide custom settings panels in this view.

Browse plugins

The Browse tab uses the same split-view. Each row shows version, author, download count, and install status. Filter by name or category. Click a plugin for details, or install directly from the list.

Installing Third-Party Plugins

  1. Click the + button below the plugin list
  2. Select a .zip archive containing a .tableplugin bundle
  3. TablePro verifies the code signature and installs the plugin
You can also drag and drop a .tableplugin or .zip file onto the Plugins settings view to install it.
Only install plugins from sources you trust. TablePro checks the code signature of sideloaded plugins but cannot guarantee their behavior.

Uninstalling Plugins

Select a user-installed plugin and click -, or use Uninstall in the detail pane. Built-in plugins can only be disabled, not uninstalled.

Advanced Settings

Some settings are available via defaults write for advanced users:
SettingCommandDescription
Custom plugin registrydefaults write com.TablePro com.TablePro.customRegistryURL <url>Use a private plugin registry
Clear custom registrydefaults delete com.TablePro com.TablePro.customRegistryURLRevert to default registry

Sync settings

Manage iCloud sync from the Sync tab in Settings. This is a Pro feature.

iCloud Sync toggle

SettingDefaultDescription
iCloud SyncOffEnable or disable iCloud sync across all Macs

Status

ElementDescription
iCloud AccountShows the current iCloud account status
Last SyncTimestamp of the most recent sync
Sync NowManually trigger a sync

Sync categories

SettingDefaultDescription
ConnectionsOnSync connection details (not passwords)
Groups & TagsOnSync connection organization, including nested group hierarchy
App SettingsOnSync all 8 settings categories
Query HistoryOnSync query history

History limit

OptionDescription
100Sync last 100 queries
500Sync last 500 queries
1,000Sync last 1,000 queries
UnlimitedSync all query history
Passwords are never synced. They remain in each Mac’s local Keychain.
See iCloud Sync for full details on conflict resolution, sync behavior, and troubleshooting.
Sync settings

License Settings

Manage your license from the License tab in Settings.

Activating a License

  1. Open Settings (Cmd+,) and select the License tab
  2. Enter your license key
  3. Click Activate
Once activated, the tab shows your registered email and license key.

Deactivating a License

  1. Open Settings > License
  2. Click Deactivate…
  3. Confirm
Deactivating frees up the activation slot for use on a different machine.

Offline Use

License validation is local (cryptographic signature). No internet needed after activation. Re-validates with the server every 7 days.
License settings

Settings Storage

Settings are stored in:
~/Library/Preferences/com.TablePro.plist

Resetting Settings

To reset everything to defaults:
# Remove preferences file
rm ~/Library/Preferences/com.TablePro.plist

# Remove cached settings
rm -rf ~/Library/Caches/com.TablePro
Then restart TablePro.
Resetting preferences does not affect saved connections or query history.

Keyboard Shortcut

ActionShortcut
Open SettingsCmd+,