Use your SQL Server login credentials. Leave the database blank to list every database you own.
Select a table from the sidebar, create a new one, or run a SQL query.
Select a database from the sidebar to get started.
Largest tables
Server
schema.table
This table has no primary key, so rows can be viewed but not edited or deleted.
Columns
Name
Type
Nullable
Identity
Default
PK
Primary key
Nullable columns can't be part of the primary key - uncheck Nullable on the column first.
Indexes
None
Foreign keys
None
Check constraints
None
Default constraints
None
Extended properties
None
Full-Text Index
Column profile
Scans the full table to compute null/distinct counts and min/max per column - not run automatically.
Column
Type
Nulls
Distinct
Min
Max
Foreign keys from other tables, and views/procedures/functions that reference this table.
Type
Object
Detail
schema.view
VIEW
Name
Type
Nullable
schema.routine
PROCEDURE
Parameters
Name
Type
Direction
No parameters.
Definition
New Table
Generate with AI
Drafts the name, columns, and primary key below for you to review — nothing is created until you click Create table.
Columns
Primary key
Nullable columns can't be part of the primary key - uncheck Nullable on the column first.
Add columns first.
Check constraints
SQL query
Runs as your own SQL login against the selected database — anything you could do in SSMS, you can do here.
Fills the SQL box below for you to review — nothing runs until you click Run.
Query
Search
Finds a value across every table in this database — each table is checked for an exact match on number/GUID columns and a partial match on text columns.
Schema diagram
Tables and their foreign key relationships in this database. Click a table to open it.
Activity
What's happening on this database right now - who's connected, resource trends, who's blocking whom, and any recent deadlocks.
Session trend
Resource usage
I/O activity
Logical reads
Statement types
Open transactions
Recent deadlocks
Blocking chains
Activity
What's happening across every database on this instance right now - who's connected, resource trends, who's blocking whom, and any recent deadlocks.
Session trend
Resource usage
I/O activity
Logical reads
Statement types
Open transactions
Recent deadlocks
Blocking chains
Query Store
Top queries by resource consumption, from SQL Server's own Query Store history.
Index fragmentation
Reorganize runs online with minimal locking and compacts the index in place - it won't fully eliminate fragmentation, but it's safe to run anytime. Rebuild drops and recreates the index from scratch: fragmentation goes back to near 0% and statistics get refreshed, but it costs more resources and can lock the table more heavily. Rule of thumb: reorganize for lighter fragmentation (10-30%), rebuild once it's heavier (30%+).
Missing Indexes
Indexes SQL Server's optimizer estimates would have helped recent queries. Advisory only - review before creating anything.
Statistics Health
Statistics with rows modified since their last update, worst first. A high modified % means the optimizer may be working from stale row estimates - consider updating.
Deadlocks
Recent deadlocks that touched this database, captured by the always-on system_health session (which is instance-wide - deadlocks are filtered down to this database here). This is a small ring buffer, not a full history - older deadlocks roll off as new ones (or other system_health events) happen.
Deadlocks
Recent deadlocks across every database on this instance, captured by the always-on system_health session. This is a small ring buffer, not a full history - older deadlocks roll off as new ones (or other system_health events) happen.
Wait Statistics
What SQL Server has spent the most time waiting on, server-wide, since the service last started - the classic first stop for "why is this slow". Common background/housekeeping wait types are filtered out. A high Signal Wait % points to CPU pressure rather than resource contention.
Unused Indexes
Nonclustered indexes with zero recorded reads, and indexes that are redundant with a wider index on the same leading columns - both cost writes and storage for little or no benefit. Usage stats reset when the service restarts or an index is rebuilt, so a recently-restarted server will show everything as unused - check "Since" before dropping anything.
Disk Usage
Actual storage per table - data, indexes, and space SQL Server has reserved but isn't using. Row count alone can't tell you this - two tables with the same row count can have very different footprints.
Database Properties
Recovery, compatibility, and other database-level settings - read-only for now.
General
Automatic
Recovery
Query Behavior
State & Security
SQL Agent Jobs
SQL Server Agent jobs on this server. Unless you're a sysadmin, only jobs that run against this database or that you own are shown.
Full-Text Search
Manage full-text catalogs on this database - create one here, then add a full-text index to a table from its Structure tab.
Permissions
Database users/roles and the explicit GRANT/DENY permissions in this database.
Users & roles
Name
Type
Member of
Explicit permissions
Principal
Permission
State
On
Share Access
Which database(s)?
What can this link do?
The SQL Query Editor is disabled because table/view access is restricted below - raw SQL could otherwise bypass that restriction.
Tables
Views
Table/view restrictions aren't available when a share grants more than one database - every table and view is visible in each one.
Search and Schema Diagram show the whole database, not just the tables above. Backup Manager Access is bigger still - it hands over the real login's full, unrestricted SqlBackupManager session, covering every database it owns, not just this one.
Manage Shares
Active
Expired
Revoked
Revoked links are automatically removed after 30 day(s).
Row
Execute
@
(disabled)
Column
New index
Columns
New Full-Text Catalog
New Full-Text Index
Columns
Chart results
Y axis (values) - pick up to 6 numeric columns
New foreign key
Composite (multi-column) foreign keys aren't supported here - use the SQL tab for those.
New check constraint
New default constraint
New extended property
New SQL Agent job
Steps
Schedule
On these days
Every
Are you sure?
Dump Database
This builds a single .sql file with a CREATE TABLE statement and an INSERT for every row, plus every view, function, stored procedure, and trigger's definition - everything needed to recreate the database elsewhere.
How long it takes depends entirely on how much data is in here - a small database finishes in seconds, a big one could take a while. You'll get a toast the moment it starts; after that, check your browser's own downloads for progress - the file streams straight to disk as it goes, so there's no "finished" signal this page can show you.
It uses GO batch separators around views/procedures/functions/triggers, same as sqlcmd/SSMS/Azure Data Studio - this app's own SQL tab understands GO too, or paste it into any of those instead. Common data types and cross-object references within this same database are handled, but we can't guarantee the output for every edge case a real database can throw at it - treat it as a strong starting point, not a guaranteed drop-in restore, and check it over before relying on it.
This briefly disconnects every existing connection to the database - this app's, SSMS, anything else - right before the dump starts, then reconnects everyone once it's read-only. It stays read-only (blocking writes from everywhere) until the dump finishes, then the same brief disconnect happens once more switching it back. Without this, changes made while the dump is running can end up only partially captured.
Import CSV
CSV column
Table column
Generate rows
Fills in random, made-up data based on each column's name and type (e.g. a column named Email gets a fake email address) - not real people's information.
Two-Factor Authentication
Scan this with your authenticator app, or enter the code manually, then confirm with the 6-digit code it generates.
Enter a current code to confirm disabling two-factor authentication.