MySQL

Connections, schema browsing, queries, and designers.

Download ZQLZ View roadmap

Ready

MySQL shares the schema browser, editor, and designers used for SQLite and PostgreSQL.

Capabilities

Connections

Ready

Host, port, database, and credentials, with SSL modes, a CA certificate, and SSH tunnels.

Schema browser

Ready

Databases, tables, views, functions, procedures, triggers, and events, plus users, grants, and server variables.

SQL editor and results

Ready

Schema-aware completion and the same native result grid.

Visual EXPLAIN

Ready

Query plans rendered as a graph.

Designers

Ready

Table and trigger designers, plus forms for events, functions, and procedures.

In the app

ZQLZ grid of a MySQL customers table with BINARY(16), SET, and JSON columns — BINARY(16) keys, SET and JSON columns in the grid, with full column types in the inspector.

ZQLZ object list of MySQL tables with engine, row format, collation, and a partitioned orders table — Every table with its engine, size, collation, and comment, and the partitioned orders table marked as such.

ZQLZ SQL editor with a MySQL CTE, the ->> JSON operator, and a RANK() window function — CTEs, the ->> JSON operator, and window functions, highlighted and schema-aware.

ZQLZ visual EXPLAIN graph for a MySQL query with nested loop joins and a covering index lookup — MySQL's plan as a graph, down to the covering index lookup on orders.

ZQLZ table designer for a MySQL orders table with ENUM, DECIMAL, DATETIME(6), and JSON columns — The table designer keeps ENUM values, precision, and the composite primary key intact.

ZQLZ grid of a MySQL table named select with mixed-case and spaced columns and emoji values — A table named select, mixed-case and spaced columns, emoji and right-to-left values.

Connecting

Host, port, database, user, and password, with SSL mode, a CA certificate, and an optional SSH tunnel.

← All databases

MySQL

Connections, schema browsing, queries, and designers.

Download ZQLZ View roadmap

Ready

MySQL shares the schema browser, editor, and designers used for SQLite and PostgreSQL.

Capabilities

Connections

Ready

Host, port, database, and credentials, with SSL modes, a CA certificate, and SSH tunnels.

Schema browser

Ready

Databases, tables, views, functions, procedures, triggers, and events, plus users, grants, and server variables.

SQL editor and results

Ready

Schema-aware completion and the same native result grid.

Visual EXPLAIN

Ready

Query plans rendered as a graph.

Designers

Ready

Table and trigger designers, plus forms for events, functions, and procedures.

In the app

Connecting

Host, port, database, user, and password, with SSL mode, a CA certificate, and an optional SSH tunnel.

← All databases