SQL Anywhere · supported engine

SQL Anywhere, right 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

Good advice, anywhere

The plan Mongrel would build for your query.

Click any node below to see cost, row estimates, and what Mongrel would suggest. Same plan detail 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 advisor: (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.

Plan & profiling

Inspect the optimizer's plan with per-node cost and row estimates, plus live engine counters and request-level performance diagnostics.

Index advisor

Mongrel reads the optimizer plan for your query, flags sequential scans over unindexed filter columns, and offers one-click CREATE INDEX.

Backup & restore

Logical archives and physical image backups from the UI. The physical path drives dbbackup from your installation and publishes a new offline image on restore.

Schema designer

Design tables, columns, and keys visually. Review-first DDL with plan, validate, and apply steps before anything touches the server.

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 and proposes indexes for you to review 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, JSON Lines, and SQL unload formats. Transactional, cancellable database copy between SQL Anywhere databases.

Connect SQL Anywhere in 30 seconds.

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

Download Mongrel