SQLlyDatabase tools
Right-click a database, open Tools, and work within that database.
Right-click a database in the Object Explorer, open Tools, and work inside it. Sixteen tools, all scoped to the database you picked - grouped below by the kind of afternoon you are having.
Understand it
Relationship Graph
The tables and foreign keys as a pannable ER diagram, exportable to SVG, Mermaid, or DBML.
Document Schema
The whole schema as Markdown, ready for a repo or a wiki.
Query Builder
Tables as cards, join lines from real keys, live SQL underneath.
Designers
Visual editors for object structure, without hand-writing the DDL.
Watch it
Activity Monitor
Live sessions, blocking chains, expensive queries, and wait stats.
Query Insights
Top-query statistics from Query Store, pg_stat_statements, or Performance Schema.
Index Analyzer
Real index read/write counters, least-read first, with a scripted DROP INDEX.
Disk Usage
This database's files - size, max, and growth.
Extended Events
Event sessions with running state and per-session detail.
Query History
Search your own local execution log and send any statement back to the editor.
Move data in, out, and across
Import / Export
CSV, JSON, Excel, or a SQLly export file, in or out, through a script-first wizard.
Data Transfer
Copy table data to another connection, database, and schema with live progress.
Backup / Restore
Back up and restore, with the destructive half scripted first.
Test Data Generator
Deterministic, dialect-correct INSERTs built from real column metadata.
Compare and govern
Schema Compare
Two connections' schema side by side, with a review-only migration script.
Data Compare
Table data across connections, with a review-only sync script.
Security
Users, roles, membership, and access within this database.
Tenant Scoping
Configure the multi-tenant missing-filter guard for this database.
Each tool states its engine coverage on its own page. The read-only monitors map onto each engine's equivalent views where one exists; a few - Extended Events, for example - are SQL Server features and are documented as such.
In this section
- Security — Users, roles, membership, and access for the selected database.
- Backup / Restore — Back up and restore the database, with destructive steps scripted first for review.
- Activity Monitor — Live sessions, blocking chains, expensive queries, and wait stats over the connection's DMVs.
- Designers — Visual object designers for building and altering database objects without hand-writing DDL.
- Import / Export — Load a CSV, JSON, Excel, or SQLly Export file into a table - or export out - through a script-first wizard.
- Schema Compare — Compare schema across two connections and generate a review-only migration script.
- Data Compare — Compare table data across connections and generate a review-only sync script.
- Data Transfer — Copy table data to another connection, database, and schema with live progress.
- Query Insights — Bounded top-query statistics from Query Store, pg_stat_statements, or Performance Schema.
- Disk Usage — The selected database's file layout - logical files, size, max, and growth.
- Index Analyzer — Real index usage counters, least-read first, with a script-first DROP INDEX for the ones you choose.
- Test Data Generator — Deterministic, dialect-correct INSERT scripts built from a table's real column metadata.
- Relationship Graph — An interactive ER diagram of the database's tables and foreign keys.
- Query Builder — A visual query builder - tables as cards, foreign-key join lines, and live SQL.
- Document Schema — Generate Markdown documentation of the database's schema, ready for a repo or wiki.
- Tenant Scoping — Configure the multi-tenant missing-filter guard: whether it runs, the tenant column, and the tenants table.
- Query History — Search the local execution log, keep pinned snippets, and send any statement back to the editor.
- Extended Events — List Extended Events sessions with running state and per-session detail; start and stop are script-first.