Connection Organization

Give every connection enough context that the right database is easy to spot before you touch it.

A connection can carry three independent pieces of context, Client, Project, and Environment, as well as its Server. Each is a first-class entity with its own color, icon, and safety policy, so the explorer can group connections around the question you are asking.

What you can assign to each

Manage clients, projects, and environments in one place: the Manage Clients, Projects & Environments dialog. They share the same properties, from their basic identity to a set of query protections.

PropertyWhat it is
NameThe label. The only required field - everything else is optional.
ColorAn optional #rrggbb color, typed as hex or picked from a color wheel, with a live preview swatch. It tints the entity's badges and group headers in the explorer and status bar. (There's no fixed preset palette - any color is fair game.)
IconAn optional custom image - browse to or type the path of a png, jpg/jpeg, gif, svg, ico, bmp, or webp file. It's your own artwork; there's no built-in icon set to choose from.

Query protections

The same nine safety toggles are available for every client, project, and environment. Most tighten safety; two deliberately relax a guard.

ToggleWhat it does
Production environmentMarks this as production: connections are read-only until you unlock writes for a timed window, and every data change asks for confirmation showing the exact SQL. (Seeded on for the built-in Production environment.)
Wrap execution in transaction + rollbackWraps each batch in a transaction that rolls back automatically - a safety net that makes writes reviewable before they commit for real.
Block all but SELECTBlocks INSERT, UPDATE, DELETE, and every other non-SELECT statement.
Require confirmation dialog before runningAsks for confirmation before running data-changing statements.
Require AI review for data changesRequires an AI-generated review before any data-changing statement runs.
Allow unconstrained UPDATE relaxesPermits an UPDATE with no WHERE without the extra confirmation that would otherwise fire.
Allow unconstrained DELETE relaxesPermits a DELETE with no WHERE without the extra confirmation.
Require Touch ID to connectSaved with the client, project, or environment; the Touch ID prompt itself is not enforced yet (see Verify to connect).
Require Touch ID for non-SELECTSaved with the client, project, or environment; the Touch ID prompt itself is not enforced yet (see Identity check for writes).
SQLly
SQLly entity management dialog with name, color, icon, and query protectionsSQLly entity management dialog with name, color, icon, and query protections
The Manage Clients, Projects & Environments dialog: name, color (with picker and swatch), icon, and the Query Protections checkboxes.
Safety inherits down the tree. A policy on a client, project, or environment applies to every tagged connection. These tiers can only tighten safety, never loosen it; the two “Allow unconstrained” choices remain per-connection. That makes “SELECT-only for production” one switch, with no quiet opt-out on an individual connection.

Switch how the explorer groups everything from the sidebar header (All / Client / Project / Environment / Server).

In this section

Clients
Use clients as the top-level home for the connections that belong to the same customer or owner.
Projects
Group related databases by the work they support, rather than hoping the server name tells the whole story.
Environments
Make development, staging, and production unmistakable variants of the same target.
Entra ID auth & Azure discovery in progress
Sign in with Entra (Azure SQL and Azure Redis), find Azure SQL targets, and get a hand with firewall access when it is needed.
Export & import connections
Move servers, databases, and logins - with or without passwords - plus label colors and icons to another machine in one file, picking exactly what to include.
Connection file format
How a SQLly connection file is laid out - labels, shared logins, tunnel profiles, and connections - with every key it accepts and a complete example.
TLS modes, CA & client certificates
Choose how PostgreSQL, MySQL, ClickHouse, libSQL and Redis connections encrypt and verify, with your own CA, client certificates, or the OS trust store.