SQL Server · supported engine

SQL Server, without the yellow bars.

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 2016+ · Azure SQL · encrypted TDS

Live · click to inspect

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 inline types for T-SQL: table-valued parameters, hierarchyid, geography, and SQL-variant aware result grids.

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, alter, and rebuild clustered and nonclustered indexes. Surface missing-index DMV suggestions with impact scores and include columns.

Schema sync & drift

Compare schemas across instances, generate T-SQL migration scripts, and detect drift between dev, staging, and production.

DMV monitoring

Live dashboards over sys.dm_exec_requests, sys.dm_os_wait_stats, and sys.dm_db_index_usage_stats. See blocking chains as they form.

Query store insights

Track plan regressions over time. Pinpoint which statement changed plans and force the last known good plan from the UI.

AI explain & rewrite

Paste a query and its showplan. The assistant rewrites the T-SQL, proposes indexes, and shows the predicted plan — it never executes.

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 T-SQL dumps. Copy data between SQL Server, Azure SQL, and any other engine — schema-aware.

Connect SQL Server in 30 seconds.

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

Download Mongrel