SQL Server · supported engine

A SQL Server GUI and typed T-SQL workbench.

A pure-Rust TDS connection with encrypted SQL authentication, typed T-SQL, estimated and actual XML showplans, DMV monitoring, and gated user and role administration.

Included with Mongrel Try free for 7 days

SQL Server 2022 & 2025 · SSH tunneling · encrypted TDS

Execution plans, decoded

The showplan Mongrel would build for your query.

Click any operator below to see subtree cost, row estimates, and what Mongrel would suggest. Same view you get inside the workbench.

// Clustered Index Scan · PK__orders

Full scan of the clustered primary key - 80,000 rows read to find 18,402. Mongrel proposes a nonclustered index on (status, created_at) with INCLUDE columns.

-- sales.dbo.orders · sql-prod-03
SELECT TOP (20)
  o.id, o.total, o.status,
  c.email AS customer_email
FROM dbo.orders AS o
INNER JOIN dbo.customers AS c
  ON c.id = o.customer_id
WHERE o.created_at > '2026-06-01'
  AND o.status = 'paid'
ORDER BY o.created_at DESC;

-- 412ms · clustered index scan, 80,000 rows read
-- ✓ Proposal: nonclustered (status, created_at) INCLUDE

CREATE NONCLUSTERED INDEX ix_orders_status_created
  ON dbo.orders (status, created_at)
  INCLUDE (total, customer_id);

SQL Server surface

What Mongrel ships for SQL Server.

Typed T-SQL editor

Autocomplete and tagged parameters for T-SQL: exact integers, decimals, binary data, UUIDs, Unicode, and temporal values in the result grid.

XML showplans

Capture estimated and actual execution plans as native XML showplans. Compare estimated vs actual rows per operator and spot bad statistics.

Index management

Create and drop indexes with a reviewed T-SQL preview, including filtered indexes. The Index Advisor turns showplan missing-index hints into ready-to-run CREATE INDEX statements with INCLUDE columns.

Schema snapshots & drift

Capture schema snapshots and diff any two - added, removed, and changed objects across dev, staging, and production. Transactional data sync keeps tables aligned.

DMV monitoring

Profiling samples over sys.dm_exec_requests and sys.dm_os_wait_stats, plus instance, database, and session overviews. See wait types, CPU, and blocking session IDs on active requests.

Backup & restore

Encrypted logical T-SQL archives with typed rows. Restore selected objects, remap schemas, and move databases between SQL Server versions.

AI explain & rewrite

Paste a query and its showplan. The assistant suggests T-SQL rewrites and indexes for you to review - generated SQL never runs automatically.

User & role administration

Gated administration for logins, users, and roles. Review server-level and database-level permissions before any change is applied.

Import, export, copy

CSV, JSON, and SQL INSERT exports. Copy databases between SQL Server instances - schema-aware, with a reviewed plan.

Connect SQL Server in 30 seconds.

7-day trial. macOS, Windows, Linux. No credit card.

Download Mongrel