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

IntelliSense4 topics
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.
Query parameters
Write :id, ? or $1 where a value goes, type the value above the results, and run without editing the SQL.
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 in progress
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.
AI error fix in place
When AI explains a failed statement, replace the broken statement with its fix in one undoable edit.
Git for the SQL library
See what changed in your SQL library, preview the diff, and commit - without leaving SQLly.
Move a tab to another window
Send a query tab to a new or existing window, text, connection and all.