Format query (beautify/minify/uglify)

In TablePlus, you can reformat the query to make it more readable using either the built-in Beautify feature, or install the SQL Formatter Plugin.

Beautify

You can reformat the queries in SQL query editor:

• Select the queries in the Query Editor.

• Click Beautify or use shortcut key ⌘ + I to beautify the queries.

• Click the dropdown next to Beautify button and choose Uglify, or use shortcut key ⌘ + ⇧ + I to uglify the queries.

SQL Formatter Plugin

This plugin helps reformat the SQL statements.

To install it:

• Navigate to menu Plugin > Manage Plugins..., or press ⌘ + L

• Select SQL Formatter Plugin and install

To use it:

• Select the SQL statements

• Navigate to menu Plugin > SQL Format, or press ⌃ + I