MotionQL
MySQL and MariaDB

MySQL and MariaDB, down to the deadlock graph

A MySQL workbench that shows what the server is doing: the Performance Schema digest workbench, InnoDB locks with a deadlock graph, unused indexes, users and privileges, and mysqldump backups.

  • MySQL 8.0, 8.4 and 9.x
  • MariaDB
  • Percona Server for MySQL
  • TiDB
  • Amazon RDS and Aurora MySQL
  • Amazon RDS for MariaDB
MotionQL's MySQL Performance tab listing statement digests by total time

The MySQL Performance tab: statement digests, waits, locks and replication in one place.

MySQL and MariaDB SQL

What you get for MySQL and MariaDB

Recognised on connect

MySQL, MariaDB, Percona, TiDB, RDS and Aurora are detected from the server, and RDS and Aurora can sign in with AWS IAM.

Performance tab

Statement digests, waits and table IO, unused and redundant indexes, the processlist with a blocking tree and audited KILL, InnoDB locks with a deadlock graph and replication status.

Visual Explain and Explain Analyze

Plans as a tree, with Explain Analyze rolled back in a separate session so it never changes your data.

Users and privileges

Create users and roles, set passwords, expiry and resource limits, and grant down to the column, with a DDL preview that masks passwords.

Objects and definitions

Procedures, functions, triggers, events and MariaDB sequences in the tree with Show DDL, and MariaDB time travel with As of.

Backups and test data

mysqldump backups and restores with a live log, schedulable as a task, plus a test data generator that fills foreign keys from parent rows.

Same app, same habits

And everything every connection gets

Each database keeps its own tools, and shares one workspace with the others.

Features to look at next

Also in relational: PostgreSQL, SQL Server, Oracle.

Your next query deserves a better IDE.

Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.