See every change before it reaches your database.

Lontar is a free desktop client for PostgreSQL, MySQL, MariaDB and SQLite. Browse tables, write SQL, and edit rows in a grid. Your edits wait until you commit them, and the commit is one transaction.

Free for everyone. Linux, Windows and macOS.

  • PostgreSQL
  • MySQL
  • MariaDB
  • SQLite
idnameemailplan
1041Ketut Ardanaketut@ardana.idteam
1042Wayan SarWayan Sariwayan@sari.copro
1043Made Putramade.putra@mail.idfree
1044Nyoman Dewinyoman@dewi.netpro
1045Ayu Lestariayu@lestari.idteam
3 pending changes
BEGIN;
DELETE FROM customers WHERE id = 1043;
UPDATE customers SET name = 'Wayan Sari'
  WHERE id = 1042;
INSERT INTO customers (id, name, email, plan)
  VALUES (1045, 'Ayu Lestari', …);
COMMIT;

Everything you reach for every day

A small, fast app built with Go and a native web view. No Electron, no account, no setup wizard.

Browse and query

Open a table with one click, or write SQL in as many query tabs as you like.

  • Tables load in pages, with sorting, multi-column sort and a filter bar
  • SQL editor with schema-aware completion; run a statement, a selection or the whole script
  • Each query tab keeps its own connection, so BEGIN, SET and temp tables carry over
  • Follow a foreign key to the referenced row with one click
  • Structure view: columns, indexes, foreign keys, checks, triggers and DDL
  • Sidebar lists functions, procedures, sequences, types, triggers and events, each with its DDL
  • Explain and Explain analyze show the query plan as a collapsible tree
  • Format SQL, and open and save .sql files

Edit without surprises

Changes are staged, not written. You see every one of them before anything is saved.

  • Changed cells, new rows and deletions are marked in the grid until you commit
  • Preview SQL shows exactly what the commit will do
  • One commit is one transaction: if any row fails, nothing is saved
  • Results of a plain single-table SELECT can be edited the same way
  • Undo and redo staged changes; type-aware editors for dates, JSON, enums and bytes

Connect safely

Production databases deserve a second look, and Lontar gives it to them.

  • Safe mode per connection: off, confirm every write, or read-only in the database itself
  • SSH tunnels through a bastion or a chain of up to three jump hosts, with host keys checked on every hop
  • SSL/TLS with CA and host name verification, and client certificates
  • Passwords live in the system keychain, or in an encrypted file when there is none
  • Several connections open at once; switch between them from the keyboard

Move data in and out

Get a table or a query result into a file, or a file into a table.

  • Export to CSV, JSON or SQL INSERT statements
  • Import CSV, JSON and NDJSON files into an existing table
  • Run a SQL file or a dump (pg_dump, mysqldump, sqlite3 .dump) with progress, cancel and safe-mode checks
  • Copy selected cells as tab-separated text, paste ranges back in
  • Command palette and keyboard shortcuts for everything
  • Light and dark themes

Work with AI assistants

Let an assistant look at your data, on your terms.

  • Built-in MCP server (lontar mcp) serves the connections you enable for AI access
  • Reads run in read-only transactions that are rolled back
  • Writes are DML only and need your approval each time
  • Every query is recorded in the history

Stay up to date

Updates are optional and verified.

  • Check for updates on demand, or let Lontar check automatically
  • Downloads are verified against an ed25519-signed checksum list before install
  • A sectioned settings dialog keeps preferences in one place

Free. All of it.

There is no paid edition and nothing locked behind one. Every feature on this page is in the download.

No account
Download it and connect. Nothing to sign up for.
No telemetry
Lontar talks to your databases, and to GitHub only when you check for updates.
Open source
Apache-2.0. Read the code, build it yourself, or contribute on GitHub.
Signed updates
Updates are checked against a signed checksum list before they are installed.

Ready when your database is.

Download Lontar