SQLite · supported engine

SQLite files, first-class.

Open any local database file and get full CRUD, schema, index, view, and trigger management, lint and EXPLAIN QUERY PLAN, import/export, backup/restore, and migrations — no server required.

Included with Mongrel Try free for 7 days

Local .db / .sqlite files · WAL · no server needed

Live · click to inspect

The query plan Mongrel would show you.

Click any node below to see what EXPLAIN QUERY PLAN reports and what Mongrel would suggest. Same view you get inside the workbench.

// SEARCH · orders USING INDEX idx_orders_status_created

After the fix: status = ? seeks straight into the index. created_at order comes free from the index, so no temp B-tree is built.

-- app.db · journal_mode=WAL
SELECT
  o.id, o.total, o.status,
  c.name AS customer_name
FROM orders o
JOIN customers c ON c.id = o.customer_id
WHERE o.status = 'paid'
ORDER BY o.created_at DESC
LIMIT 20;

-- 820ms · SCAN orders + temp B-tree sort
-- ✓ Proposal: index on (status, created_at)

CREATE INDEX idx_orders_status_created
  ON orders (status, created_at);

-- after: 3ms · SEARCH USING INDEX, 20 rows

SQLite surface

What Mongrel ships for SQLite.

Local files, no server

Open .db, .sqlite, and .sqlite3 files directly. WAL mode, attached databases, and read-only inspection built in.

Row & bulk CRUD

Edit rows inline or in bulk with type-aware editors for TEXT, INTEGER, REAL, and BLOB values — NULLs included.

Schema browser

Tables, columns, foreign keys, and PRAGMA introspection. See the exact DDL behind every object in the file.

Index management

Create, drop, and rebuild indexes from the UI. See which queries each index serves and refresh ANALYZE stats.

Views & triggers

Create, edit, and drop views and triggers with syntax-checked DDL. Inspect trigger firing order per table.

Lint & EXPLAIN QUERY PLAN

EXPLAIN QUERY PLAN rendered as a tree. Spot SCAN vs SEARCH, temp B-trees, and covering-index opportunities.

Import, export, copy

CSV, JSON, and SQL dumps. Copy data between SQLite files or any other engine — schema-aware.

Backup & restore

Online backups, VACUUM INTO snapshots, and .dump archives. Run integrity_check before you trust a file.

Migrations & diff

Compare two database files, generate reversible migrations, and apply them transactionally.

Open a SQLite file in 30 seconds.

7-day trial. macOS, Windows, Linux. No credit card.

Download Mongrel