SQLly vs Basevolt
Basevolt is a local-first admin panel for your own databases, made by independent developer Dylan Yu. It’s an Electron app that turns PostgreSQL, MySQL, SQLite and Cloudflare D1 tables into grid, kanban, gallery and dashboard views, with webhooks, action buttons, and an MCP server so an AI agent can set the panel up. It isn’t a SQL client in the usual sense - we found no SQL editor in it. SQLly is a paid, closed-source SQL workbench. They overlap less than you’d think. Here’s the honest breakdown.
Last reviewed: November 2026
The short version
A deep SQL workbench
One Rust codebase drawn on the GPU on macOS, Windows, and Linux, with no browser engine. Thirty engines, IntelliSense that reads your data, layered safety guardrails, schema compare, and a full set of script-first admin tools.
An admin panel for apps you’ve built
An Electron app with a React front end and a small local server inside. It reads your existing schema and gives you grid, kanban, gallery and dashboard views, display-only field renames, related records, webhooks with delivery logs, and an MCP server. Version 0.16.0 (November 2026), built by one developer, with a $99-a-year Pro plan.
Feature by feature
SQLly’s column uses the same honest status badges as the features page and the docs. For Basevolt we list what its website, FAQ, changelog, update feeds and the 0.16.0 macOS app bundle show. Basevolt isn’t open source, so we couldn’t read its source the way we can for open-source tools.
| Capability | SQLly | Basevolt |
|---|---|---|
| Runs on macOS, Windows & Linux | YesmacOS is signed and notarized; Windows and Linux are a supported beta, on amd64 and arm64. | YesSigned and notarized macOS dmgs, Windows installers for x64 and arm64, and a Linux AppImage and .deb for x86_64 only. |
| Intel Macs | NoApple Silicon only. | YesSeparate Intel and Apple Silicon dmgs; macOS 11 or later. |
| How the app is built | NativeOne Rust codebase, rendered on the GPU (Metal, Direct3D, Vulkan). How it works | ElectronA React and TanStack front end, with a bundled Node server that talks to your database through pg, mysql2 and better-sqlite3. Updates through electron-updater. |
| Download size | SmallermacOS dmg 65.6 MB, Windows x64 zip 60.9 MB, Linux x64 tarball 76.2 MB. | Largerv0.16.0: Apple Silicon dmg 124.7 MB, Windows x64 installer 96.5 MB, .deb 90.1 MB, AppImage 136.4 MB. |
| Free to use | Free tierTwo saved servers, one cloud account, and a reminder to pay about every five hours. Pricing | Free tierHobby: two projects on one machine, with no account. Views, dashboards, webhooks and MCP are all included. |
| Paid license | One-time$100 for SQLly 1.x, or $200 Lifetime. Pricing | YearlyPro is $99 a year: unlimited projects and data sources, sync across up to three machines, and a perpetual fallback to the version you had when you stop paying. |
| Open source | NoLifetime licenses carry a source-escrow promise if SQLly is ever discontinued. | NoNo public repository that we could find. |
| PostgreSQL, MySQL, SQLite | YesPlus wire-compatible services such as Supabase and Neon. Full list | YesLocal SQLite files too, and services such as Supabase that speak these protocols. |
| Cloudflare D1 & remote SQLite | No | YesD1 directly, and remote SQLite through sqlited, the maker’s single-binary SQLite HTTP server with a D1-compatible API. |
| SQL Server & MariaDB | YesPlus Azure SQL (Entra sign-in in progress). Full list | NoNeither is listed. MariaDB may work through its MySQL driver, but Basevolt doesn’t say so. |
| DuckDB, ClickHouse, Oracle, libSQL/Turso, Redis | YesNative drivers; DuckDB is bundled. A full Redis toolset. Per-engine coverage | No |
| SQL editor | YesThe center of the app, with a searchable query history with pins, an SQL library, and a formatter. Query history | NoNone that we could find on its site or in the app bundle. Its AI chat can query data, and an agent can run read-only SQL over MCP. |
| IntelliSense | YesAlias- and scope-aware, JOIN ON from foreign keys, real column values in WHERE. IntelliSense |
NoThere’s no editor to complete in. |
| Edit table data | YesA row editor generated from the table’s own metadata. Row editor | YesRecord forms, plus inline grid editing since 0.16.0. |
| Kanban & gallery views | NoResults are a grid, with pivot and chart tabs. | YesGrid, kanban and gallery views, with multi-condition filters, multi-field sort and full-text search. |
| Dashboards & charts | ChartsPivot, charts, conditional formatting, computed columns, and diffs on any result. Pivot | YesLive dashboards with charts, metrics, tables and text, which an agent can build for you. |
| Webhooks & action buttons | No | YesButtons on records that call a webhook, with delivery logs. |
| Import & export data | YesImport CSV, JSON and Excel; export CSV, JSON, SQL, and Excel with live formulas and a pivot sheet. Export | CSVImport a CSV as a table (new in 0.16.0) and export a view as CSV. |
| ER diagrams | YesExport to SVG, Mermaid, or DBML. Relationship Graph | YesDataMap, an auto-laid-out map of your tables. It also links related records when no foreign keys are defined. |
| SSH tunnels & TLS | YesSSH hops, SOCKS and HTTP proxies, and TLS modes. TLS | PartialAn SSL switch; in the 0.16.0 code it turns off certificate verification. No SSH tunnel option and no SSH library in the bundle that we could find. |
| Saved passwords | OS keychainConnection files are plain text; passwords live in the keychain. | Encrypted fileIts FAQ says credentials are encrypted and stored locally. We found AES encryption in its own store, but no keychain integration. |
| Query plans, activity & schema compare | YesActivity Monitor, Query Insights, schema and data compare, and backup and restore; the plan viewer is in progress. Tools | NoNot on its site or in its changelog. |
| Guardrails in the editor | YesSELECT-only connections, no UPDATE/DELETE without WHERE, auto-rollback, tenant checks, prod in red. Safety |
-We couldn’t confirm a read-only connection mode. |
| AI assistant | YesLocal models (Ollama, MLX), your own endpoint, or opt-in cloud providers. | YesA built-in chat that queries data and builds views and dashboards, with your own Claude, OpenAI or Gemini key. A one-click setup works with no key. |
| MCP server | YesSchema reads and a single SELECT in a read-only transaction that is always rolled back; writes come back to you as proposals. How reads are kept read-only |
YesLocal, in every plan. About 37 tools: views, fields, dashboards and webhooks, plus create, update and delete for records. Its run_sql tool allows only SELECT-style statements, checked by keyword. |
| Sync across machines | FilesConnections and settings are plain files you can sync yourself. Everything is a file | ProCross-device sync for up to three machines on Pro. |
| Usage analytics | NoneThe app has no telemetry today. | AptabaseThe 0.16.0 bundle includes the Aptabase analytics SDK and sends an app_started event with version and platform. Its privacy policy doesn’t mention app analytics. |
A dash means we couldn’t confirm it from Basevolt’s own materials - check its changelog for the current state.
Where SQLly is different
Basevolt is about looking after an app’s data without writing SQL. SQLly is about writing the SQL, and the work around it.
A real SQL editor
Query history, an SQL library and a formatter, with completions that pull a column’s real distinct values into a WHERE clause, write a join’s ON clause from actual foreign keys, and flag a GROUP BY mistake as you type.
No webview, half the download
SQLly draws its own UI on the GPU, and large results stream to disk, so the grid stays flat on memory whether you fetch 50 rows or 50 million. The macOS dmg is about half the size of Basevolt’s.
Spill-to-disk results →Guardrails beyond a permission check
Read-only connections that refuse file-reading and shell-escape tricks, a hard stop on UPDATE/DELETE with no WHERE, auto-wrapped transactions, and prod painted red - inherited down your client, project, and environment tree.
An agent that can only read
SQLly’s MCP server runs one SELECT in a transaction that is always rolled back, and anything that would change data comes back to you as a proposal. Basevolt’s MCP can create, update and delete records directly.
SSH, TLS, and the keychain
SSH hops, SOCKS and HTTP proxies, and TLS modes for the servers that need them. Passwords stay in the OS keychain and never leave it through import or export.
TLS →More engines and admin tools
SQL Server, MariaDB, DuckDB, ClickHouse, Oracle, libSQL/Turso and Redis, plus schema compare with sync and rollback scripts, data compare, cross-engine transfer, and an activity monitor.
Tools →When Basevolt is the better choice
Basevolt is probably the better fit if:
- You want an admin panel, not a query tool. Kanban boards, gallery cards, dashboards of what needs attention today, and record pages that open their related records. SQLly has none of that - it gives you a grid and a SQL editor.
- You want buttons that do things. Basevolt’s action buttons and webhooks, with delivery logs, turn a table into a small back office. SQLly has no webhooks.
- Your app runs on Cloudflare D1. Basevolt connects to D1 and to remote SQLite through sqlited. SQLly doesn’t connect to either.
- You’d rather an AI agent set the panel up. Point Claude Code or Cursor at its MCP server and the agent builds your views, fields and dashboards.
- You’re on an Intel Mac. Basevolt ships an Intel dmg; SQLly needs Apple Silicon.
A couple of honest caveats in the other direction: Basevolt is at version 0.16.0 and built by one developer, Pro is a yearly subscription rather than a one-time license, and we found no SSH tunnel support, so a database behind a bastion host is out of reach for now.
Questions
Is Basevolt free?
Partly. Basevolt’s Hobby plan is free with no account, for two projects on one machine. Pro is $99 a year for unlimited projects and sync across up to three machines, and if you stop paying you keep the version you had. SQLly is free for hobbyists (two saved servers), with a one-time $100 SQLly 1.x license and a $200 Lifetime license for everyone else.
Which databases do SQLly and Basevolt support?
Both connect to PostgreSQL, MySQL and SQLite. Basevolt adds Cloudflare D1 and remote SQLite through its sqlited HTTP server, which SQLly does not support. SQLly adds SQL Server, MariaDB, DuckDB, ClickHouse, Oracle, libSQL/Turso and Redis, plus documented wire-compatible services such as Neon, Supabase and Aurora - 30 engines in all.
Does Basevolt have a SQL editor?
We couldn’t find one. Basevolt is built around grid, kanban, gallery and dashboard views of your tables. The closest things are its AI chat, which can query your data, and its MCP server’s run_sql tool, which lets an agent run read-only queries. SQLly is a SQL editor first, with IntelliSense that reads your schema and data, result tools, and admin tools.
Other comparisons
Point both at the same database
The quickest way to choose is to open your own tables in each. SQLly is free on macOS, Windows, and Linux, with no account required.