Query editor

The editor is where most of your time goes, so it is built to stay out of the way. Each tab is a separate query with its own results, and your tabs are restored when you relaunch.

Enlarge

Tabs#

• Open a new tab for a new query. Each tab remembers its connection, so you can keep staging and production open together.
• Double-click a tab title to rename it. Right-click a tab to close all tabs.
• Press ⌘W to close the current tab.
• Basic allows 2 query tabs at once by default. Pro and Lifetime are unlimited.

Autocomplete and hover docs#

Suggestions come from your real schema, not a generic keyword list. RowDex understands the structure of what you are typing, including aliases, joins, subqueries and CTEs, so it offers the columns that are actually in scope.

• Tables, views and columns from the connected database, with type and key information.
• Functions for your engine's dialect, with signature help as you type the arguments.
• Hover over a table, column or function to see its definition, columns, keys and description.
• Works across PostgreSQL, Redshift, MySQL, MariaDB and SQLite, each with its own dialect rules.

Run a query#

Format#

Press ⌘⇧F to tidy the current query. Placeholders such as :user_id or {{date}} are protected while formatting, so they come back exactly as you wrote them.

Transactions#

Click Begin in the toolbar to open a transaction in the current tab. Statements from that tab then run on one connection until you click Commit or Rollback. It is the safe way to try an UPDATE and inspect the result before deciding to keep it.

Insert another query with @#

Type @ in the editor to search your saved and recent queries and insert one. See Saved queries and history.