Database 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. Twenty tools, all scoped to the database you picked, grouped below by the kind of afternoon you are having.

Understand it

Relationship Graph
An interactive ER diagram of the database's tables and foreign keys.
Document Schema
Generate Markdown documentation of the database's schema, ready for a repo or wiki.
Query Builder
A visual query builder - tables as cards, foreign-key join lines, and live SQL.
Designers
Visual object designers for building and altering database objects without hand-writing DDL.
Descriptions
Edit table, view, and column descriptions and write them back to the server as comment DDL.

Watch it

Activity Monitor
Live sessions, blocking chains, expensive queries, and wait stats over the engine's own session views - SQL Server, PostgreSQL, MySQL, ClickHouse, Oracle, and Redis.
Query Insights
Bounded top-query statistics from Query Store, pg_stat_statements, Performance Schema, the ClickHouse query log, or the Redis slow log.
Index Analyzer
Real index usage counters, least-read first, with a script-first DROP INDEX for the ones you choose.
Disk Usage
The selected database's file layout - logical files, size, max, and growth.
Extended Events
List Extended Events sessions with running state and per-session detail; start and stop are script-first.
Query History
Search the local execution log, keep pinned snippets, and send any statement back to the editor.

Move data in, out, and across

Import / Export
Load a CSV, JSON, Excel, or SQLly Export file into a table - or export 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 the database, with destructive steps scripted first for review.
Test Data Generator
Deterministic, dialect-correct INSERT scripts built from a table's real column metadata.
Import profiles
Save an import's column mapping and options as a named, reusable profile per table.
Scheduled tasks
Run built-in dumps, native backups, and saved-query exports on a schedule while SQLly is open.
Copy as CLI command
Copy the sqlly-cli command equivalent to a dump, backup, or export, ready for cron or a runbook.

Compare and govern

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.
Security
Users, roles, membership, and access for the selected database.
Tenant Scoping
Configure the multi-tenant missing-filter guard: whether it runs, the tenant column, and the tenants table.
Nothing here writes behind your back. Every tool that changes data or structure (restore, drop, sync, transfer, import) produces SQL in a query tab for you to read and run. The grids and monitors that only read are live and immediate.

Each tool states its engine coverage on its own page, and the Databases page tabulates all of it. The read-only monitors map onto each engine's equivalent views where one exists: SQL Server's DMVs, PostgreSQL's pg_stat views, ClickHouse's system tables, Oracle's V$ views, Redis's INFO and CLIENT LIST; a few (Extended Events, for example) are SQL Server features and are documented as such. Redis has no schema, so the compare, transfer, structure and test-data tools say so there and point you at the key browser.