Dameng DM8, natively.
Native DM8 connections with typed SQL, schema and dependency inspection, EXPLAIN on real DM plan operators, same-server copy and data sync, user and admin tooling, and encrypted archive backup and restore.
DM8 native driver · TLS
The plan Mongrel would build for your query.
Click any operator below to see cost, cardinality, and what Mongrel would suggest. Same view you get inside the workbench.
// SSEK · idx_orders_cust_created
Secondary index seek on idx_orders_cust_created. Range seek on customer_id + created_at replaces a full CSCN2 scan of orders.
-- SALES · dm8-prod-1 SELECT o.order_id, o.total_amt, o.status, c.email AS customer_email FROM sales.orders o JOIN sales.customers c ON c.customer_id = o.customer_id WHERE o.created_at >= DATE '2026-06-01' AND o.status = 'PAID' ORDER BY o.created_at DESC LIMIT 20; -- 486ms · CSCN2 full scan on orders -- ✓ Proposal: composite (customer_id, created_at) CREATE INDEX idx_orders_cust_created ON sales.orders (customer_id, created_at);
What Mongrel ships for Dameng.
Native DM8 SQL
Typed SQL over the native DM8 driver with schema-aware completion, bound parameters, and cancellable execution.
EXPLAIN & plan inspection
Run EXPLAIN and walk the real DM plan tree - NSET, SLCT, SSEK, CSCN, HASH JOIN - with cost and cardinality per node.
Schema & dependency inspection
Browse schemas, tables, views, and procedures. Trace object dependencies before you alter or drop anything.
Index advice
A conservative advisor reads the EXPLAIN plan and recommends a CREATE INDEX only where a full table scan appears. Review the DDL, then run it yourself.
Copy & sync
Copy tables between schemas on the same DM8 server, or preview and apply primary-key data sync. Import and export in CSV, JSON, JSON Lines, and SQL.
User & role administration
Browse users, roles, and grants. Privileged actions stay gated behind the connecting account's own rights.
Archive backup & restore
Encrypted archive backups of schemas and data, with dependency-ordered restore into the same or another DM8 instance.
Session & activity monitoring
Instance, tablespace, and active-session overviews, plus bounded top-SQL and session profiling samples - the V$ views you already know, in one panel.
AI explain & rewrite
Paste a query and its plan. The assistant rewrites it and proposes indexes - nothing executes without your review.