Features
A guided tour of SQLly, arranged around the work you are here to do.
SQLly is built around one simple idea: the tool should know enough about your database to be genuinely helpful. These guides follow the shape of real work, writing a query, understanding its result, keeping a collection of connections straight, and not breaking production on a Friday.
The daily loop
- Query14 topics
- A place to write SQL with a little less busywork and a lot more context.
- Results20 topics
- Read the answer, shape it for the task, and take it with you when you are done.
- SQLly directives7 topics
- Small SQL comments that remember how a result looks: its columns, widths, formats, colors, pivot, and chart.
- Databases
- The 30 engines SQLly connects to today, from SQL Server and PostgreSQL to DuckDB, ClickHouse, Oracle and Redis, which tools work on each, and how to connect.
Knowing your schema
- Multi-modal schema5 topics
- Bring live databases, local DDL, work in progress, and Git context into one useful picture.
- Intelligence5 topics
- Tools that help SQLly explain your database in plain language without pretending it knows more than it does.
- Tools2 topics
- The admin tools SQLly opens from the Object Explorer's right-click Tools menu - some for a whole server, some scoped to a single database.
Not breaking things
- Safety & guardrails6 topics
- Put a thoughtful pause in front of risky work while keeping ordinary reads pleasantly boring.
- Identity gates6 topics
- Use your operating system's identity check where a mistake would be expensive, and leave routine work alone.
Keeping it all straight
- Server Explorer7 topics
- Keep connections and their schema close at hand, organized for the way you think about your work.
- Connection Organization7 topics
- Give every connection enough context that the right database is easy to spot before you touch it.
- Files & sync2 topics
- Keep your SQLly world in plain files, then choose if and how those files travel with you.
How it feels and where it runs
- Speed & access5 topics
- The engineering behind a responsive workbench, remote reach when you need it, and privacy when you do not.
- Platforms2 topics
- The same native SQLly workbench on the desktops where real database work happens.
- Themes
- Twelve color themes, each in Light and Dark, plus a System mode that follows your OS from day to night.
These guides explain both shipping features and work still in progress, and each page says which it is. For the full status-tagged list, visit Features. The engineering underneath is written up in Platform.
Also in this section
- Redis tools13 topics
- Redis tools: key view and streams, IntelliSense, Cluster and Sentinel, profiler, Pub/Sub, memory analysis, bulk actions, ACL users, and value formats.