Query

A place to write SQL with a little less busywork and a lot more context.

The query editor is where most of the day happens, so it is more than a place to hold text. IntelliSense works from a live model of your schema and data, while SQLly directives use ordinary SQL comments to remember how you want the result to look.

In this section

• IntelliSense — Completions that pay attention to your query, schema, and, when useful, the data itself.
• GROUP BY check — A grouped query that selects a column it neither groups nor aggregates is underlined as you type, with the reason and a one-click fix.
• Execution & cancellation — Run the statement you mean to run, then stop it cleanly when the plan changes.
• SQLly directives — Small SQL comments that remember how you want results shaped, formatted, and charted.
• SQL formatter — Tidy up a query without changing what it means. The formatter is careful on purpose.
• Command palette — One fuzzy-search stop for commands, connections, settings, and places you need to get to.
• Customizable keybindings — Keep the shortcuts your hands already know, or make a new set that fits your workflow.
• Tab switcher — Move between open queries with Ctrl+Tab and a preview that helps you pick the right one.
• Query plans — Turn an execution plan into useful findings, a navigable tree, or a diagram you can follow.
• DDL source navigation — Open an object's definition right from the query instead of going on a tree-hunting expedition.
• Open dialog — Find SQL files and database definitions with fuzzy search and a preview before you commit.