SQLite

Fully functional local workflow — the reference database for ZQLZ.

Ready

SQLite is the first driver in ZQLZ and the one the team dogfoods daily. Point ZQLZ at any local database file and get schema browsing, a schema-aware SQL editor, results, the table designer, and import/export without a server or credentials.

Capabilities

Connections

Ready

Open local SQLite files directly, with open mode, journal mode, foreign keys, and extension loading.

Schema browser

Ready

Tables, views, and triggers, with each table's fields, indexes, foreign keys, and checks.

SQL editor

Ready

Schema-aware completion, hover with foreign keys, and diagnostics for unknown tables and columns.

Results and export

Ready

Native result grid with export to CSV, JSON, or SQL INSERT.

Table and trigger designers

Ready

Edit columns, indexes, foreign keys, and triggers with a SQL preview.

Visual EXPLAIN

Ready

Query plans rendered as a graph.

Import/export

Ready

CSV and schema-preserving UDIF transfers, plus SQL dumps.

In the app

zqlz workspacesqlite

JSON objects and arrays stored as TEXT, with each column's declared type in the inspector.

ZQLZ object list showing six SQLite views, one with spaces in its name — Every view in the file, including one with spaces in its name.

ZQLZ SQL editor with a SQLite CTE, json_extract, and a rank() window function — CTEs, json_extract, and window functions, highlighted and schema-aware.

ZQLZ visual EXPLAIN graph for a SQLite query with nested loops and a subquery scan — SQLite's query plan drawn as a graph: nested loops, the subquery scan, and temp B-trees.

ZQLZ table designer editing a SQLite orders table — The table designer, with Indexes, Foreign Keys, Checks, and SQL Preview one tab away.

ZQLZ grid of a SQLite 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

Open any .sqlite, .db, or .db3 file directly from disk. No connection string needed.

← All databases

SQLite

Fully functional local workflow — the reference database for ZQLZ.

Download ZQLZ View roadmap

Ready

Capabilities

Connections

Ready

Open local SQLite files directly, with open mode, journal mode, foreign keys, and extension loading.

Schema browser

Ready

Tables, views, and triggers, with each table's fields, indexes, foreign keys, and checks.

SQL editor

Ready

Schema-aware completion, hover with foreign keys, and diagnostics for unknown tables and columns.

Results and export

Ready

Native result grid with export to CSV, JSON, or SQL INSERT.

Table and trigger designers

Ready

Edit columns, indexes, foreign keys, and triggers with a SQL preview.

Visual EXPLAIN

Ready

Query plans rendered as a graph.

Import/export

Ready

CSV and schema-preserving UDIF transfers, plus SQL dumps.

In the app

zqlz workspacesqlite

JSON objects and arrays stored as TEXT, with each column's declared type in the inspector.

Connecting

Open any .sqlite, .db, or .db3 file directly from disk. No connection string needed.

← All databases