SQLlyOpen dialog
✓ functionalFind SQL files and database definitions with fuzzy search and a preview before you commit.
Opening SQL should not mean playing hide-and-seek in a stock file panel. SQLly's Open dialog searches your project with the same fuzzy logic as the editor, previews a file before you open it, and can jump straight to a database object's definition.
Two ways to browse
- Folder - walk one directory at a time, with a parent (
..) row and an Up button. Choose Root… points it at a new project folder. - Project SQL - recursively finds every
.sqlfile under the project root at once, each row tagged with the schema and object it defines and whether it was indexed or scanned.
Search that thinks like IntelliSense
The search box uses the same fuzzy matching as code completion,
so you type initials and it finds the name: PuOr matches
PurchaseOrder, SOH matches
SalesOrderHeader, and case never matters. Every
whitespace-separated term has to match, so you can narrow quickly.
Prefix a term to scope it to one kind of object:
| Prefix | Scopes to |
|---|---|
t: / table: | Tables |
v: / view: | Views |
p: / proc: / sproc: | Stored procedures |
f: / function: | Functions |
tr: / trigger: | Triggers |
i: / index: | Indexes |
ty: / type: | Types |
sch: / schema: | A schema name |
"…" | Quote to search literally, prefixes and all |
Preview, reveal, and open
- Syntax-highlighted preview - select a
.sqlfile and its contents render, line-numbered and colorized, before you commit to opening it. Big files preview a slice with a Load Full File button. - Data-model rows - flip on the DDL toggle and the list also offers your live tables and views; choosing one opens its definition directly.
- Reveal in the OS file browser and Copy Path from the preview pane; toggle Show Hidden to include dotfiles.
- New SQL File… creates an empty query file to start from.
Keyboard throughout: ↑/↓ move, Enter opens the file (or descends into a folder, or opens an object's DDL), and Escape clears the search before it closes the dialog.