The database IDE that reads your schema.

A native Rust app for ten engines. Completions, hovers, and query plans come from your real tables.

Download ZQLZ Watch trailer

Free for local work, no account
·
macOS, Windows, Linux
·
Early build v0.0.12

ZQLZanalytics.events

ZQLZ showing a PostgreSQL analytics.events table with the connection tree, result grid, and column inspector

Local-first

Unlimited local database work without an account. Connections and history live on your machine.

One native window

Schema tree, schema-aware SQL editor, result grid, visual EXPLAIN, and table designer in one native window.

Ten engines

SQLite, PostgreSQL, MySQL, MariaDB, SQL Server, Turso, DuckDB, ClickHouse, MongoDB, and Redis in one app.

Watch a database move from file to answers

ZQLZ opens a database, finds schema context, runs SQL, and turns a slow query into a readable plan.

Schema, SQL, results, plans.

ZQLZ keeps database context on screen while you move from object discovery to query execution and plan analysis.

See every schema object before you write a query

Browse tables, views, functions, triggers, and partitions per connection, with row counts, owners, and keys in the object list.

Saved connections in one tree
Partitions and parent tables
Copy CREATE TABLE

Schema browser

ZQLZ object list showing PostgreSQL partitions of analytics.events with row counts and primary keys

An editor that knows your schema

Completions, hovers, and diagnostics come from a SQL language server that reads your real tables, CTEs, and foreign keys.

Schema-aware completion
Hover for columns and foreign keys
Unknown tables flagged as you type

SQL editor

Read results with types beside them

A native grid renders large result sets, and the inspector shows each column's type, nullability, and indexes.

JSONB, arrays, enums, and domains
Export to CSV, JSON, or SQL INSERT
Query history per connection

Results

ZQLZ result grid showing PostgreSQL UUID, JSONB, array, and enum columns with the column inspector

Design schema changes as reviewable SQL

Table, trigger, and sequence designers generate the DDL as you edit. Object versioning keeps a history of functions, views, and triggers.

Table designer with SQL previewTrigger and sequence designersObject versioning with diffs

ZQLZ table designer editing the columns of a PostgreSQL table

Designers

See why a query is slow

EXPLAIN plans render as a graph with costs and suggestions, so a sequential scan or a missed partition is obvious.

Visual EXPLAINPlan suggestionsProblems panel per query

ZQLZ visual EXPLAIN plan for a PostgreSQL query with per-node costs

Query analysis

Ten engines, one workspace.

Relational, embedded, analytical, document, and key-value databases share the same native workspace. Local workflows stay free.

Compare every driver

SQLite

Local database files with the full workflow, from schema to designer.

PostgreSQL

Schemas, partitions, JSONB, enums, domains, designers, and visual EXPLAIN.

MySQL

Databases, routines, events, and users, with table and trigger designers.

MariaDB

Its own connection type on the MySQL driver, with sequences.

SQL Server

SQL or Windows authentication, schemas, procedures, and triggers.

Turso

Remote libSQL databases with the SQLite workflow.

DuckDB

Embedded analytics files and in-memory databases.

ClickHouse

Columnar analytics over the HTTP interface.

MongoDB

Collections, pipelines, and indexes, with document editing.

Redis

Key browser and typed value editor, with TTLs.

Open your database in ZQLZ

SQLite, PostgreSQL, MySQL, SQL Server, MongoDB, Redis, and more, in one native workspace.

Download ZQLZ See release notes