SQLite · supported engine

A SQLite GUI for local database files.

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

Tiny file, big insights

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 and drop indexes from the UI and inspect what already exists. Index Advisor turns EXPLAIN QUERY PLAN output into practical create-index suggestions.

Views & triggers

Create and drop views and triggers from SQL, with driver-aware linting. Inspect the full definition behind every object.

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, JSON Lines, and SQL inserts. Copy selected tables, views, and triggers between SQLite files with merge or replace.

Backup & restore

Whole-file online backups via VACUUM INTO, on demand or scheduled, with file-level restore. Run integrity_check before you trust a file.

Migrations & diff

Save schema snapshots, diff them against the live file to track drift, and apply migration scripts transactionally.

Open a SQLite file in 30 seconds.

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

Download Mongrel