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.
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.