// sqlly vs rainfrog

SQLly vs rainfrog

rainfrog is “a database tool for the terminal”: an MIT-licensed Rust program built on Ratatui, with vim-style keys, a query editor with history and favorites, and a single binary of 8 to 20 MB compressed. SQLly is also written in Rust, but it’s a desktop app with a GPU-drawn window. This isn’t two versions of the same thing - it’s terminal vs desktop, and each wins in different places.

Last reviewed: November 2026

The short version

SQLly

A desktop SQL workbench

One Rust codebase drawn on the GPU on macOS, Windows, and Linux. Thirty engines, IntelliSense that reads your data, a grid built for analysis, layered guardrails, and a full set of script-first DBA tools. It needs a screen; it won’t run over SSH.

rainfrog

A small, fast terminal client

A Ratatui TUI with schema and table browser, a vim-like query editor with completions, session history, favorites saved as .sql files, and CSV export. Six databases, PostgreSQL best tested. Free under MIT, about 5,400 GitHub stars, and still 0.x: v0.4.6 shipped on 24 September 2026.

Feature by feature

SQLly’s column uses the same honest status badges as the features page and the docs. For rainfrog we list what its README, source and release page state.

Feature comparison of SQLly and rainfrog
Capability SQLly rainfrog
Kind of app DesktopOne Rust codebase, rendered on the GPU (Metal, Direct3D, Vulkan). How it works TerminalA Rust TUI built on Ratatui. Runs in any terminal, including over SSH and inside tmux.
Runs on macOS, Windows & Linux YesmacOS is signed and notarized; Windows and Linux are a supported beta, on amd64 and arm64. YesRelease binaries for macOS (Apple Silicon and Intel), Linux (x86_64, aarch64, i686, glibc and musl), Windows x64, and Android under Termux.
Intel Macs NoApple Silicon only. YesAn x86_64 macOS build is on every release.
Download size 61-76 MBmacOS dmg 65.6 MB, Windows x64 zip 60.9 MB, Linux x64 tarball 76.2 MB. 8-20 MBv0.4.6 tarballs: 18.9 MB macOS arm64, 16.3 MB Windows x64, 18.1 MB Linux x64 glibc, 8.0 MB Linux x64 musl (no DuckDB).
Install from a package manager PartialDirect downloads, plus a Mac App Store edition. Download Yescargo, Homebrew, Arch pacman, nix, conda, pixi, a Docker image, and an install script.
Free to use Free tierTwo saved servers, one cloud account, and a reminder to pay about every five hours. Pricing YesNo paid tier and no account.
Open source NoLifetime licenses carry a source-escrow promise if SQLly is ever discontinued. YesMIT on GitHub.
PostgreSQL, MySQL, SQLite YesPlus MariaDB and hosted compatibles - 30 engines in all. Full list YesPostgreSQL is its tier-1 driver; MySQL and SQLite are tier 2. Redshift works through the PostgreSQL driver.
DuckDB & Oracle YesDuckDB is bundled. Per-engine coverage PartialDuckDB is tier 2 and missing from the Android, i686 and musl builds. Oracle is tier 3 and needs Oracle Instant Client installed.
SQL Server & Azure SQL YesSQL Server, plus Azure SQL (Entra sign-in in progress). No
ClickHouse, libSQL/Turso, Redis YesNative drivers, with Redis key editing, Cluster and Sentinel. Redis No
Saved connections & keychain passwords YesConnections organised by client, project and environment; passwords in the OS keychain. Organisation YesConnections in a TOML config file, or a URL, flags, or DATABASE_URL; passwords can be saved to the platform keychain.
SSH tunnels YesSSH hops, SOCKS and HTTP proxies, and Kubernetes. Engine docs NoNot built in - but you can run rainfrog on the remote box itself over SSH, which a desktop app can’t.
Vim keybindings PartialAn optional Vim mode in the query editor; the rest of the app is mouse and shortcuts, all rebindable. Keybindings YesVim-like keys across the menu, editor, history and results. The README notes they don’t match vim exactly.
Autocomplete YesAlias- and scope-aware, JOIN ON from foreign keys, real column values in WHERE. IntelliSense PartialSQL keyword, schema, buffer and file-path completions, with a debounce and trigger length you can set.
Edit in an external editor YesOpen in External Editor sends the tab’s SQL to VS Code, Zed, Sublime and others. Command palette YesAlt+e or F6 opens the query in your $EDITOR.
Multi-statement scripts YesWhole scripts, GO batches, and run-selection. Execution PartialOne statement per run. F7 bypasses the parser, with no validation and no rollback.
Query history & saved queries YesA searchable execution log with pins, plus an SQL library that can be a git repository. Query history YesSession history, and favorites saved as one .sql file each, filterable with /.
Confirm before a data change YesHard stop on UPDATE/DELETE with no WHERE, SELECT-only connections, auto-rollback, tenant checks. Safety YesUPDATE and DELETE run in a transaction and ask before committing, showing rows affected. DROP, TRUNCATE and ALTER ask first too. No read-only connection mode.
Edit table data YesA row editor generated from the table’s own metadata. Row editor NoYou write the UPDATE yourself.
Large results YesStreams and spills to disk past 50,000 rows or 64 MiB; flat memory at 50 million rows. Streaming -Couldn’t confirm limits from its docs. Table preview fetches 100 rows.
Pivot, charts & result diff YesPivot, charts, conditional formatting, computed columns, and diffs on any result. Pivot No
Export results YesCSV, JSON, SQL, and Excel with live formulas and a pivot sheet. Export PartialCSV to your Downloads folder. The README warns that export blocks the app, so large exports freeze it.
Table designers & DDL YesDesigners and Edit Structure. Designers PartialShortcuts to view table metadata and properties.
Execution plans In progressPlain-language findings, tree, and diagram across nine engines. Query plans PartialYou can run EXPLAIN and read the text output; EXPLAIN ANALYZE of a write asks first.
Schema & data compare, ER diagrams YesRisk-graded schema diffs, data compare, and a Relationship Graph. Schema Compare No
Activity monitor & DBA tools YesSessions, blocking chains, Query Insights, SQL Agent, backup/restore as scripts. Tools No
AI assistance & MCP YesLocal or opt-in cloud models; sqlly-cli mcp gives agents read-only access. Read-only enforcement No

A dash means we couldn’t confirm it from rainfrog’s own materials - check its repository for the current state.

Where SQLly is different

rainfrog keeps to a small job and does it in a terminal. SQLly is built for the hours after the first query.

More engines, and SQL Server first-class

SQL Server, MariaDB, ClickHouse, libSQL/Turso and Redis aren’t in rainfrog. SQLly covers them with plans, dashboards, activity monitors and compare tools per engine, and documents wire-compatibles such as CockroachDB, Neon and Aurora.

Engine list →

Autocomplete that knows your data

SQLly can pull a column’s real distinct values into a WHERE clause, write a join’s ON clause from actual foreign keys, and underline a GROUP BY mistake as you type. A 0.5 MB script still edits at about 5 ms a keystroke.

IntelliSense →

A grid that does analysis

Pivot, charts, conditional formatting, computed columns, result diffs, and Excel export with a pivot sheet. Results stream to disk, so 50 million rows use about as much memory as 50.

SQLly directives →

Guardrails beyond a confirm prompt

rainfrog’s confirm-before-commit is a good default. SQLly adds SELECT-only connections that refuse file-reading and shell-escape tricks, a hard stop on UPDATE/DELETE with no WHERE, tenant checks, and prod painted red - inherited down your client, project, and environment tree.

Safety & guardrails →

Script-first admin tools

Activity monitor, Query Insights, SQL Agent, schema and data compare, index analyzer, test data, disk usage, and cross-engine data transfer live under one Tools menu. Anything destructive opens as SQL in a tab for you to read first.

Tools →

Edit rows without writing the UPDATE

A row editor built from the table’s metadata, plus table designers and Edit Structure, so routine changes don’t mean hand-writing DDL and DML.

Row editor →

When rainfrog is the better choice

rainfrog is probably the better fit if:

  • You work over SSH or in tmux. rainfrog runs on the server next to the database, in a terminal you already have open. SQLly needs a desktop session.
  • You want your hands to stay on the home row. rainfrog uses vim-style keys in every pane: the table list, the editor, history and results. SQLly’s Vim mode covers the editor, not the whole app.
  • Footprint matters. An 8 MB musl tarball for Linux, against SQLly’s 61-76 MB downloads, and it installs from Homebrew, pacman, nix, conda or cargo in one line.
  • Open source, or free at any company size, is a requirement. rainfrog is MIT with no paid tier. SQLly’s source is closed, and its free tier isn’t available inside organisations with more than 100 employees.
  • You’re on an Intel Mac, a 32-bit Linux box, or Android. rainfrog ships x86_64 macOS, i686 Linux and Termux builds. SQLly needs Apple Silicon on the Mac and has no phone app.
  • You just need a quick look at a Postgres table. If you don’t need plans, compare, or admin tools, a terminal client that starts in a blink is hard to beat.

One honest caveat the other way: rainfrog’s own README calls it under active development, warns of breaking changes, and recommends against using it with write access on a production database.

Questions

Is rainfrog free?

Yes. rainfrog is free and open source under the MIT license, with no paid tier and no account. You install it with cargo, Homebrew, pacman, nix, conda, pixi, Docker or a release binary. SQLly is free for hobbyists, with a one-time $100 SQLly 1.x license and a $200 Lifetime license for everyone else.

Which databases do SQLly and rainfrog support?

Both connect to PostgreSQL, MySQL, SQLite, DuckDB and Oracle. rainfrog also lists Amazon Redshift through its PostgreSQL driver; its prebuilt Android, i686 and musl binaries leave DuckDB out, and Oracle needs the Oracle Instant Client installed. SQLly adds SQL Server, Azure SQL (Entra sign-in in progress), MariaDB, ClickHouse, libSQL/Turso and Redis, plus documented wire-compatible services such as CockroachDB, Neon, Supabase and Aurora - 30 engines in all.

Does SQLly have a terminal UI like rainfrog?

No. SQLly is a desktop app drawn on the GPU, so it needs a graphical session. Its sqlly-cli runs from a terminal for command-line use and as an MCP server for AI agents, but it is not a full-screen terminal client. If you need to query a database from an SSH session or inside tmux, rainfrog is built for that and SQLly is not. SQLly does have optional Vim keybindings in its editor.

// try it yourself

Point both at the same database

The quickest way to choose is to run your own queries in each. SQLly is free on macOS, Windows, and Linux, with no account required.