████████╗███████╗██████╗ ███╗ ██╗
╚══██╔══╝██╔════╝██╔══██╗████╗ ██║
██║ █████╗ ██████╔╝██╔██╗ ██║
██║ ██╔══╝ ██╔══██╗██║╚██╗██║
██║ ███████╗██║ ██║██║ ╚████║
╚═╝ ╚══════╝╚═╝ ╚═╝╚═╝ ╚═══╝
tern is a SQL client for your terminal with fuzzy history, schema-aware autocomplete and query plans you can actually read. One binary, zero config, works with Postgres, MySQL and SQLite.
A live session against a demo database. Type help or click a command.
Things you stop noticing after a week, then can't live without.
Ctrl-R searches every query you ever ran, across machines, ranked by how often it worked.
Tables, columns and foreign keys completed as you type, including joins it can infer.
EXPLAIN turned into a tree with costs, hot spots and a one-line suggestion.
UPDATE without WHERE asks twice. DROP in production asks you to type the table name.
Send any result to jq, csv or your clipboard with a single pipe character.
Static, no runtime, starts in 11 ms. Runs on Linux, macOS, Windows and your Raspberry Pi.
Cold start to first result, 10k runs, M3 laptop, lower is better.
Free for you. Paid when your team wants shared history.