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
| id | name | plan | |
|---|---|---|---|
| 1041 | Ketut Ardana | ketut@ardana.id | team |
| 1042 | wayan@sari.co | pro | |
| 1043 | Made Putra | made.putra@mail.id | free |
| 1044 | Nyoman Dewi | nyoman@dewi.net | pro |
| 1045 | Ayu Lestari | ayu@lestari.id | team |
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.