// sqlly vs basevolt

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

SQLly

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.

Basevolt

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.

Feature comparison of SQLly and Basevolt
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.

IntelliSense →

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.

Safety & guardrails →

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.

How reads are kept read-only →

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.

// try it yourself

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.