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.