Make it yours

Settings

Every page and option in Settings, with its default, and how to edit settings.json by hand.

Open Settings with ⌘ , (Ctrl Alt S on Windows and Linux), or the gear in the title bar. Settings replaces the workspace while it's open; Esc or ⌘ W closes it.

The Settings screen, with its pages listed on the left
The Settings screen, with its pages listed on the left

Use Search settings at the top of the sidebar to find an option by name. Every page has a Reset to defaults link. Changes apply immediately; there is no Save button.

#Appearance & Behavior

#Appearance

OptionDefaultChoices
ModeSync with OSSync with OS, Light, Dark
Dark themeGraphite DarkAny dark theme
Light themeGraphite LightAny light theme
Accent colourThe theme's ownAny colour
Zoom100%50% to 300%
Font sizeDefaultDefault, or 11 to 16 pt
Panel cornersRoundedSquare, Slightly rounded, Rounded, Very rounded

Links on this page: Open settings.json, Open themes folder and Customize current theme.

#Color Scheme

  • Scheme: the colours of SQL syntax, with a live preview. Theme's own follows the theme.
  • Dark theme colours and Light theme colours: override the colour of each kind of SQL token (keywords, strings, numbers, comments…).
  • Environments: the badge colours for Local, Development, Staging and Production. See Safety & environments.

#Startup & Layout

OptionDefault
Reopen tabsOn
Tool window at startAs last time (or None, Connections, Query History, Saved Queries)
Agent chat at startClosed (or Open, As last time)
Remember window sizeOn
Remember panel widthsOn
Breadcrumbs in the status barOn
Selection summary in the status barOn

The Tool stripe section shows, hides and reorders the buttons on the far left.

#Keymap

  • Preset: TableGrip, DataGrip / IntelliJ, or VS Code.
  • A searchable table of every action ("Search actions or keys") where you can change a shortcut, see clashes, and reset one action at a time.

See Keyboard shortcuts.

#Updates

OptionDefault
Check for updates automaticallyOn
Download and install updates automaticallyOn
ChannelStable (or Beta, which includes pre-releases)

The page also has Check for Updates, the current version and What's new. See Updates.

#Editor

#SQL Editor

OptionDefaultRange
FontJetBrains Mono (bundled)Any installed monospace font
Font size13 pt9 to 32 pt
Line height150%100% to 300%
Tab size42, 4 or 8
Indent withSpacesSpaces or Tabs
Close brackets and quotesOn
Complete as you typeOnOff: completion only on ⌃ Space
Line numbersOn
Highlight the current lineOn
Reformat SQL → KeywordsUpper, Lower or Preserve case

#Database

#Query Execution

OptionDefaultRange
Max result rows1,00010 to 1,000,000
Query timeout0 (none)0 to 86,400 seconds

#Drivers

  • Downloading drivers: Ask every time (default), or Automatic for permissive licenses.
  • Maven repository: leave empty for Maven Central, or enter your mirror.
  • Lists of Installed and Available drivers.

See Drivers.

#Tools

The pg_dump, pg_restore, psql, mysqldump and mysql copies TableGrip found, and which one each connection uses. You can choose one by hand, and download or remove the PostgreSQL client tools. See Backup & restore.

#Backups

Turn scheduled backups on and manage the schedules. See Backup & restore → Scheduled backups.

#Data Editor

OptionDefaultChoices
Page size200 rows10 to 10,000
Row densityComfortableCompact, Comfortable, Spacious
Stripe alternate rowsOff
NULL shows as<null>Any text
Date-time formatThe system'sA custom pattern
Date-time zoneLocalLocal or UTC
Group thousandsOff1,234,567 instead of 1234567

#Tools

#Agent

OptionDefault
Agents fromCommand-line agents (or API provider)
Protocol, Base URL, Model, API keyUsed with an API provider
Connections shareSchema only (or Off, Schema and sample data)

See AI agent and What the agent can see.

#settings.json

Everything above is stored in ~/.tablegrip/settings.json. Open settings.json on the Appearance page opens it in your editor.

  • Only values that differ from the defaults are written, so the file stays short.
  • Comments and trailing commas are allowed.
  • The file is watched: save it in your editor and the app updates while it runs.
  • If the file has a syntax error, TableGrip uses the defaults, shows the error at the top of Settings, and won't overwrite the file until you fix it.
json
{
  // Follow the OS, but use Dracula at night
  "theme": { "mode": "System", "dark": "Dracula" },
  "zoom": 110,
  "editorFontSize": 14,
  "pageSize": 500,
  "maxResultRows": 5000,
  "formatKeywordCase": "Upper",
  "keymap": "DataGrip",
}

Some keys you might edit by hand:

KeySetting
theme.mode, theme.dark, theme.lightAppearance mode and themes
accentColor, zoom, uiFontSize, islandCornerRadiusAppearance
editorFontFamily, editorFontSize, editorLineHeight, tabSize, indentWithTabsSQL editor
maxResultRows, queryTimeoutSecondsQuery execution
pageSize, gridDensity, zebraRows, nullText, dateTimeFormat, dateTimeZone, numberGroupingData editor
autoDownloadDrivers, driverRepositoryDrivers
checkForUpdates, installUpdatesAutomatically, updateChannelUpdates
keymap, keyBindingsKeymap
agentMode, agentProvider, agentBaseUrl, agentModel, aiAccessAgent
environmentColors, syntaxScheme, syntaxColors, themeOverridesColours

Note

API keys and passwords are never stored in settings.json. They live in the system keychain.