Skip to main content

​
Editor Settings

Customize the SQL editor to match your coding preferences. Access editor settings via Settings > Editor.
Editor settings

​
Font Settings

​
Font Family

Choose from available monospace fonts:
FontDescription
System MonomacOS default monospace (recommended)
SF MonoSan Francisco Mono
MenloClassic macOS monospace
MonacoTraditional Mac programming font
Courier NewCross-platform standard
System Mono is recommended as it automatically uses the best available system monospace font.

​
Font Availability

Not all fonts are available on every system:
FontAvailability
System MonoAlways available
SF MonomacOS 10.12+
MenlomacOS 10.6+
MonacomacOS Classic
Courier NewStandard system font
If a selected font isn’t available, TablePro falls back to System Mono.

​
Font Size

Adjust the editor font size:
SettingRangeDefault
Font Size11-18 pt13 pt
Font sizes
Recommendations:
SizeBest For
11-12 ptSmall screens, seeing more code
13-14 ptStandard usage (default)
15-16 ptBetter readability
17-18 ptLarge screens, accessibility

​
Display Settings

​
Line Numbers

OptionDescription
OnShow line numbers (default)
OffHide line numbers for minimal interface
Line numbers help with:
  • Referencing specific lines
  • Error messages that mention line numbers
  • Navigating large queries
  • Discussing code with others
Line numbers

​
Current Line Highlight

OptionDescription
OnSubtly highlight the line with cursor (default)
OffNo highlight on current line
This helps track your cursor position, especially in long queries.

​
Word Wrap

OptionDescription
OffLong lines scroll horizontally (default)
OnLong lines wrap to next line
When to enable word wrap:
  • Working on narrow screens
  • Queries have long lines
  • Prefer not to scroll horizontally
When to disable word wrap:
  • Prefer consistent line lengths
  • Working with formatted queries
  • Need to see query structure clearly

​
Indentation Settings

​
Tab Width

Set how many spaces a tab represents:
SettingOptionsDefault
Tab Width1-16 spaces4
Common choices:
WidthUsage
2 spacesCompact code, JavaScript style
4 spacesStandard SQL formatting (recommended)
8 spacesTraditional, Unix-style

​
Auto Indent

OptionDescription
OnNew lines match previous indentation (default)
OffNew lines start at column 1
Auto indent helps maintain consistent formatting: 
SELECT
    u.id,
    u.name,
    |  -- Cursor here, next line auto-indents

​
Editor Behavior

​
Text Entry

The editor behaves like a standard macOS text editor:
  • Standard keyboard shortcuts work
  • Copy/paste functions normally
  • Undo/redo history is maintained
  • Selection works with mouse and keyboard

​
Autocomplete

Autocomplete cannot be disabled but can be dismissed with Escape. See Autocomplete for details on using this feature.

​
Applying Settings

Settings apply immediately:
  1. Change a setting
  2. The editor updates in real-time
  3. No restart required

​
Default (Balanced)

Font Family: System Mono
Font Size: 13 pt
Line Numbers: On
Current Line: On
Tab Width: 4
Auto Indent: On
Word Wrap: Off

​
Compact (More Code Visible)

Font Family: SF Mono
Font Size: 11 pt
Line Numbers: On
Current Line: On
Tab Width: 2
Auto Indent: On
Word Wrap: Off

​
Comfortable (Easy Reading)

Font Family: Menlo
Font Size: 15 pt
Line Numbers: On
Current Line: On
Tab Width: 4
Auto Indent: On
Word Wrap: On

​
Minimal (Clean Interface)

Font Family: Monaco
Font Size: 13 pt
Line Numbers: Off
Current Line: Off
Tab Width: 4
Auto Indent: On
Word Wrap: Off

​
Accessibility

Font Family: System Mono
Font Size: 18 pt
Line Numbers: On
Current Line: On
Tab Width: 4
Auto Indent: On
Word Wrap: On

​
Syntax Highlighting

The editor automatically highlights SQL syntax:
ElementColor (Dark)Color (Light)
KeywordsPinkPink
StringsGreenGreen
NumbersBlueBlue
CommentsGrayGray
FunctionsDefaultDefault
IdentifiersWhiteBlack
Syntax colors automatically adapt to the current theme.

​
Highlighted Keywords

SQL keywords that are highlighted include:
  • SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP
  • FROM, WHERE, JOIN, ON, GROUP BY, ORDER BY, HAVING
  • AND, OR, NOT, IN, LIKE, BETWEEN, IS NULL
  • INNER, LEFT, RIGHT, OUTER, CROSS, UNION
  • And many more SQL standard keywords

​
Keyboard Shortcuts in Editor

ActionShortcut
Execute queryCmd+Enter
UndoCmd+Z
RedoCmd+Shift+Z
FindCmd+F
ReplaceCmd+Option+F
Select AllCmd+A
Go to LineCmd+G
See Keyboard Shortcuts for the complete list.

​
Troubleshooting

​
Font Not Appearing Correctly

  1. Verify the font is installed on your system
  2. Try selecting a different font
  3. Restart TablePro

​
Settings Not Saving

  1. Check disk permissions
  2. Verify preferences file is writable: 
    ls -la ~/Library/Preferences/com.TablePro.plist
  3. Try resetting preferences

​
Editor Feels Slow

  1. Reduce font size (larger fonts render slower)
  2. Disable word wrap for long queries
  3. Check for very large queries in editor

SQL Editor

Editor features and usage

Autocomplete

Autocomplete functionality

Appearance

Theme and colors

Keyboard Shortcuts

All keyboard shortcuts