Hunt downthe exact row.

A native, precise database client. In a forest of millions of rows, Mantidb is the lighthouse that takes you straight to the one you're looking for.

Download for MacOther platforms

Apple Silicon & Intel · macOS 14+ · iOS 17+

Report an issueRelease notes
public /orders
Search or run a command⌘K
SQL
status=paid✕created_at>2026-01-01✕+ Filter
1–300 of ~284,112 rows · 18 ms‹›
id
customer
total
currency
status
created_at
20480
Lucía Herrera
12.00
USD
paid
2026-10-21 09:00
20483
Noah Fischer
91.19
MXN
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
EUR
pending
2026-10-20 11:26
20489
Mateo Rossi
249.57
USD
paid
2026-10-20 12:39
20492
Emma Laurent
328.76
USD
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
MXN
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
EUR
paid
2026-10-18 15:18
20501
Liam O'Connor
566.33
USD
paid
2026-10-18 16:31
20504
Valentina Cruz
645.52
USD
paid
2026-10-17 17:44
20507
Kenji Mori
724.71
MXN
pending
2026-10-17 09:57
20510
Olivia Brooks
803.90
EUR
paid
2026-10-16 10:10
20513
Hugo Martin
883.09
USD
failed
2026-10-16 11:23
20516
Camila Torres
62.28
USD
paid
2026-10-15 12:36
20519
Jonas Weber
141.47
MXN
paid
2026-10-15 13:49
DataStructureIndexes
↓ 2.4 KB/s ↑ 312 B/s+ RowCommit ⌘S
public /orders
Search or run a command⌘K
SQL
status=paid✕created_at>2026-01-01✕+ Filter
1–300 of ~284,112 rows · 18 ms‹›
id
customer
total
currency
status
created_at
20480
Lucía Herrera
12.00
USD
paid
2026-10-21 09:00
20483
Noah Fischer
91.19
MXN
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
EUR
pending
2026-10-20 11:26
20489
Mateo Rossi
249.57
USD
paid
2026-10-20 12:39
20492
Emma Laurent
328.76
USD
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
MXN
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
EUR
paid
2026-10-18 15:18
20501
Liam O'Connor
566.33
USD
paid
2026-10-18 16:31
20504
Valentina Cruz
645.52
USD
paid
2026-10-17 17:44
20507
Kenji Mori
724.71
MXN
pending
2026-10-17 09:57
20510
Olivia Brooks
803.90
EUR
paid
2026-10-16 10:10
20513
Hugo Martin
883.09
USD
failed
2026-10-16 11:23
20516
Camila Torres
62.28
USD
paid
2026-10-15 12:36
20519
Jonas Weber
141.47
MXN
paid
2026-10-15 13:49
DataStructureIndexes
↓ 2.4 KB/s ↑ 312 B/s+ RowCommit ⌘S
DarkLight

Supports a whole set of relational databases and more

Native drivers for each one, plus the engines that speak their protocol.

  • PostgreSQL
  • MySQL
  • MariaDB
  • SQLite
  • SQL Server
  • Redis
  • MongoDB
  • CockroachDBvia PostgreSQL
  • Redshiftvia PostgreSQL
  • Neonvia PostgreSQL
  • Supabasevia PostgreSQL
  • Azure SQLvia SQL Server
  • Valkeyvia Redis
  • KdKeyDBvia Redis
  • Dragonflyvia Redis

Made for Mac. Windows and Linux, coming soon.

  • macOS14 or later
  • iOS17 or later
  • WindowsComing soon
  • LinuxComing soon

Thoughtful UI that's easy to use

public /orders
Search or run a command⌘K
SQL
id
customer
total
status
created_at
20480
Lucía Herrera
12.00
paid
2026-10-21 09:00
20483
Noah Fischer-Lang
91.19
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
pending
2026-10-20 11:26
20489
Mateo Rossi
0.00
refunded
2026-10-20 12:39
20492
Emma Laurent
328.76
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
paid
2026-10-18 15:18
20501
Liam O'Connor
566.33
paid
2026-10-18 16:31
DataStructureIndexes
3 changesPreviewDiscard+ RowCommit ⌘S

Inline edit

Edit data rows, table structure, or query results directly with just a click.

public /orders
Search or run a command⌘K
SQL
statusINpaid, refunded✕total>100✕+ Filter
1–300 of ~48,120 rows · 12 ms
status▾IN▾
paid, refunded
✓Enabled
RemoveApply
id
customer
total
status
created_at
20480
Lucía Herrera
12.00
paid
2026-10-21 09:00
20483
Noah Fischer
91.19
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
pending
2026-10-20 11:26
20489
Mateo Rossi
249.57
paid
2026-10-20 12:39
20492
Emma Laurent
328.76
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
paid
2026-10-18 15:18

Advanced filters

Quickly see the records you need using multiple advanced filters.

public /orders
Search or run a command⌘K
SQL
id
customer
total
status
created_at
20480
Lucía Herrera
12.00
paid
2026-10-21 09:00
20483
Noah Fischer-Lang
91.19
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
pending
2026-10-20 11:26
20489
Mateo Rossi
249.57
refunded
2026-10-20 12:39
20492
Emma Laurent
328.76
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
paid
2026-10-18 15:18
20501
Liam O'Connor
566.33
paid
2026-10-18 16:31
UPDATE "public"."orders" SET "customer" = 'Noah Fischer-Lang' WHERE "id" = 20483;
UPDATE "public"."orders" SET "status" = 'refunded' WHERE "id" = 20489;
DELETE FROM "public"."orders" WHERE "id" = 20495;
DataStructureIndexes
3 changesPreviewDiscard+ RowCommit ⌘S

Code review

Always stay in control of what you have changed on your database.

public /orders
Search or run a command⌘K
SQL
id
customer
total
status
created_at
20480
Lucía Herrera
12.00
paid
2026-10-21 09:00
20483
Noah Fischer
91.19
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
pending
2026-10-20 11:26
20489
Mateo Rossi
249.57
refunded
2026-10-20 12:39
20492
Emma Laurent
328.76
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
paid
2026-10-18 15:18
20501
Liam O'Connor
566.33
paid
2026-10-18 16:31
DataStructureIndexes
2 changesPreviewDiscard+ RowCommit ⌘S
⚠
Run 2 statements on Acme Production?

PRODUCTION · Confirm + Touch ID for writes. Review the SQL below; it runs in a single transaction.

UPDATE "public"."orders" SET "status" = 'refunded' WHERE "id" = 20489;
DELETE FROM "public"."orders" WHERE "id" = 20495;
CancelRun

Safe mode

Prevent any mistakes from being made on your production database.

public /orders
Search or run a command⌘K
SQL
id
customer
total
status
created_at
20480
Lucía Herrera
12.00
paid
2026-10-21 09:00
20483
Noah Fischer
91.19
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
pending
2026-10-20 11:26
20489
Mateo Rossi
249.57
paid
2026-10-20 12:39
20492
Emma Laurent
328.76
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
paid
2026-10-18 15:18
20501
Liam O'Connor
566.33
paid
2026-10-18 16:31
Export orders

Table · ~284,112 rows · 2 filters

Format
CSVJSONSQL INSERTExcel (XLSX)
Columns5 of 6
AllNone
✓id✓customer✓totalcurrency✓status✓created_at
CancelExport…

Export & import

Export tables and results to CSV, JSON, SQL or Excel, and import CSV, JSON or SQL files.

public /orders
ord⌘K
SQL
id
customer
total
status
created_at
20480
Lucía Herrera
12.00
paid
2026-10-21 09:00
20483
Noah Fischer
91.19
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
pending
2026-10-20 11:26
20489
Mateo Rossi
249.57
paid
2026-10-20 12:39
20492
Emma Laurent
328.76
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
paid
2026-10-18 15:18
20501
Liam O'Connor
566.33
paid
2026-10-18 16:31
▦ordersTable
▦order_itemsTable
◉orders_by_monthView
★Orders this weekFavorite
↗Export…⇧⌘E
⟲SELECT * FROM orders WHERE status = 'pending'History

Open anything

Jump to any table, schema, view or function instantly from the keyboard.

public /orders
Search or run a command⌘K
SQL
‹›orderscustomersQuery 1 •
id
customer
total
status
created_at
20480
Lucía Herrera
12.00
paid
2026-10-21 09:00
20483
Noah Fischer
91.19
paid
2026-10-21 10:13
20486
Aiko Tanaka
170.38
pending
2026-10-20 11:26
20489
Mateo Rossi
249.57
paid
2026-10-20 12:39
20492
Emma Laurent
328.76
failed
2026-10-19 13:52
20495
Diego Ramírez
407.95
paid
2026-10-19 14:05
20498
Sofia Lindqvist
487.14
paid
2026-10-18 15:18
20501
Liam O'Connor
566.33
paid
2026-10-18 16:31
20504
Valentina Cruz
645.52
paid
2026-10-17 17:44
▶ Run CurrentRun All
⌘↩ run current
SELECT status, count(*)
FROM orders
GROUP BY status;
3 rows · 9 ms
paid38,402
pending6,911
failed2,807

Multiple tabs & windows

Keep tables and queries in tabs, and split the window to work on two at once.

… and so much more

Metrics Board

Build internal dashboards fast and simply.

Metrics — Acme Production
Overview⌃⌄
+ Add WidgetEvery 30 s⌃⌄
Orders per day
18 ms···
Revenue · last 30 days
11 ms···
1,284,310.5revenue
Revenue by currency
24 ms···
USDMXNEUR
Recent orders
9 ms···
idcustomertotalstatus
20480Lucía Herrera12.00paid
20483Noah Fischer91.19paid
20486Aiko Tanaka170.38pending
20489Mateo Rossi249.57paid
20492Emma Laurent328.76failed
20495Diego Ramírez407.95paid
20498Sofia Lindqvist487.14paid
20501Liam O'Connor566.33paid
20504Valentina Cruz645.52paid
4 widgets·Read-only queries
Updated 10:42:18 AM

A smart query editor

We've built the best practices for SQL editing into the default to help you boost your productivity.

  • Instant autocomplete
  • Highlight syntax
  • Split panes
  • SQL query reformatter
  • Favorite & history
  • Streaming results
public /Query 1
Search or run a command⌘K
SQL
‹›ordersQuery 1
Run CurrentRun All Stop Save Format
⌘↩ run current · ⇧⌘↩ run all · ⌥⌘F format · limit 1,000 rows
1-- Top customers this month
2SELECT c.name, count(*) AS orders, sum(o.total) AS revenue
3FROM orders o
4JOIN customers c ON c.id = o.customer_id
5WHERE o.status = 'paid'
6 AND o.created_at >= date_trunc('month', now())
7GROUP BY c.name
8ORDER BY revenue DESC
9LIMIT 10;
10
11SELECT o.cu
12FROM orders o;
currency
customer
customer_id
SELECT c.name, count(*) AS orders, sum(o.total) AS revenue FROM orders o JOIN customers c …
10 rows · 14 ms
nameordersrevenue
1Lucía Herrera4218,940.20
2Aiko Tanaka3716,212.75
3Mateo Rossi3515,804.00
4Emma Laurent3113,377.40
5Diego Ramírez2912,950.10
6Sofia Lindqvist2611,028.65
7Noah Fischer2410,311.90

Elegant in every detail

Clean & focused

No clutter, no noise. Every pixel is there to help you get the job done.

High performance

Native build that opens and queries in milliseconds.

Shortcut keys

Keep your hands on the keyboard for every action.

Always improving

Frequent releases shaped by community feedback.

Quick support

Real humans answering your questions, fast.

Want to see Mantidb in action?

Download now