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.