SQL Anywhere · supported engine

SQL Anywhere, fully at home.

SQL Anywhere 16/17 over DBCAPI with TLS/mTLS — typed bound SQL, logical and physical backup/restore, profiling, user and role administration, and schema design, through your installed SAP client runtime.

Included with Mongrel Try free for 7 days

SQL Anywhere 16/17 · TLS/mTLS

Live · click to inspect

The plan Mongrel would build for your query.

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

// Seq Scan · SalesOrders

Full sequential scan of SalesOrders — no index on OrderDate. The optimizer had no cheaper path. This is the bottleneck.

-- sales · sqlanywhere-demo
SELECT TOP 20
  so.ID, so.OrderDate, so.Region,
  c.CompanyName
FROM SalesOrders so
KEY JOIN Customers c
WHERE so.OrderDate > '2026-06-01'
ORDER BY so.OrderDate DESC;

-- 1.9s · seq scan on SalesOrders
-- ✓ Index Consultant: (OrderDate, Region)

CREATE INDEX IX_OrderDate_Region
  ON SalesOrders (OrderDate, Region);

SQL Anywhere surface

What Mongrel ships for SQL Anywhere.

Typed bound SQL

Watcom-SQL with typed, bound parameters over DBCAPI. TOP/START AT paging, KEY JOIN syntax, and host variables handled natively.

Graphical plan & profiling

Inspect the optimizer's graphical plan with per-node cost and row estimates, plus request-level logging and procedure profiling.

Index consultant

Mongrel surfaces the indexes the Index Consultant would recommend, with the queries that benefit and one-click CREATE INDEX.

Backup & restore

Logical unload/reload and physical image backups from the UI. Schedule encrypted archives and restore to a point in time.

Schema design & ER diagrams

Design tables, keys, and publications visually. Auto-generated ER diagrams from foreign keys, with reversible DDL generation.

User & role administration

Browse users, roles, and object privileges. Grant and revoke with review-first DDL, over TLS or mutual-TLS connections.

AI explain & rewrite

Paste a query and its plan. The assistant rewrites it, proposes indexes, and shows the predicted plan before you run anything.

SAP client runtime

Mongrel discovers your installed SAP SQL Anywhere client runtime in common locations, or accepts a folder you select — nothing bundled.

Import, export, copy

CSV, JSON, and SQL unload formats. Copy data between SQL Anywhere and any other engine — schema-aware.

Connect SQL Anywhere in 30 seconds.

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

Download Mongrel