MongrelDB, from the source.
Embedded native table and SQL workflows backed by the public MongrelDB crates - browsing, querying, schema, and snapshot backups, built into every Mongrel build.
Built into every Mongrel build · embedded · open-source crates
See what MongrelDB does with your query.
Click any step below to follow a query from SQL to native execution - what EXPLAIN reports, and how an index changes the plan. Same EXPLAIN you get inside the workbench.
// SELECT · status = 'paid'
The SQL subset is parsed and translated into MongrelDB Kit's native query AST - or write the native JSON query directly. Either way you get paged results with cancellation.
// orders · local Kit database SELECT id, total, created_at FROM orders WHERE status = 'paid' ORDER BY created_at DESC LIMIT 20; // EXPLAIN → table: orders // index_accelerated: false · exact: false // pushed: [status] // Table → Indexes → New index: (status, created_at) // EXPLAIN again → index_accelerated: true
What Mongrel ships for MongrelDB.
Table browser & editor
Browse tables with filters, sorting, and paging. Insert, update, and delete rows in place, with typed columns and batch inserts.
EXPLAIN & push-down insight
Explain any SELECT to see index acceleration, plan exactness, and which filter conditions are pushed into the engine.
SQL + native JSON queries
Run the SQL subset - SELECT with DISTINCT, DML, transactions with savepoints - translated to native Kit queries, or write native JSON queries directly.
Index management
Create and drop single and multi-column indexes from the UI. EXPLAIN shows whether a query's predicate is index-accelerated.
Schema analysis
Profile a table in the Schema Analyzer: row counts, present and missing values, cardinality, and numeric min/max/avg per column.
Schema, views & triggers
Create and alter tables, columns, constraints, and indexes - plus views, triggers, and stored procedures - all applied through Kit migrations.
AI query assistant
Generate queries from natural language with your schema and indexes as context. Review the result and accept it - nothing runs automatically.
Built-in, zero setup
Backed by the public MongrelDB crates and embedded in every Mongrel build. No server, no credentials, no plugin to install.
Import, export & backup
JSON, CSV, and TSV import/export per table, plus full-database snapshot backups (VACUUM INTO) you can open as a new connection.