SQLly vs DB Pro
DB Pro is a commercial database client from a two-person team in the UK: a desktop app for macOS, Windows and Linux, a self-hosted browser version called Studio, AI on your own API key, and dashboards you can build from a table in two clicks. SQLly overlaps on the basics and then goes a different way - deeper into writing SQL, guardrails and DBA tools. 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 inside. Thirty engines, IntelliSense that reads your data, layered safety guardrails, plans, compare, and a full set of script-first admin tools. Agents get read-only access; anything that writes comes back to you as a proposal.
A friendly data studio with dashboards
An Electron app with a data browser, a Monaco-based SQL editor, a visual schema explorer, dashboards, a workflow builder and an AI sidebar, over ten engines including MongoDB and DynamoDB. A self-hosted Studio puts the same workspace in a browser for a team. Version 2.10.2 shipped on 29 October 2026, and the team posts a devlog most months.
Feature by feature
SQLly’s column uses the same honest status badges as the features page and the docs. For DB Pro we list what its own site, Show HN post and 2.10.2 release files show.
| Capability | SQLly | DB Pro |
|---|---|---|
| Runs on macOS, Windows & Linux | YesmacOS is signed and notarized; Windows and Linux are a supported beta, on amd64 and arm64. | YesmacOS, Windows x64, and Linux x64 and arm64 as AppImage, .deb and .rpm. |
| Intel Macs | NoApple Silicon only. | YesA separate Intel DMG. |
| How the app is built | NativeOne Rust codebase, rendered on the GPU (Metal, Direct3D, Vulkan). How it works | ElectronElectron, React, tRPC and Drizzle per its Show HN post; the 2.10.2 package bundles Chromium, Monaco and Glide Data Grid. |
| Download size | 65.6 MBmacOS DMG. Windows x64 zip 60.9 MB, Linux x64 tarball 76.2 MB. | 204.4 MBmacOS Apple Silicon DMG (2.10.2). Windows installer 156.5 MB, Linux AppImage 214.3 MB. |
| Free to use | Free tierTwo saved servers, one cloud account, and a reminder to pay about every five hours. Pricing | Free tier2 connections, 3 open tabs, 5 saved queries, 2 dashboards, 1 device. Its pricing table marks import and export as paid. |
| Paid price | $100 / $200SQLly 1.x license $100 one-time; Lifetime $200. | $99 or $9.99/moOne-time licence with 1 year of updates on 2 devices, shown at $59 with a promo code; or $9.99 a month with updates while subscribed. |
| Open source | NoLifetime licenses carry a source-escrow promise if SQLly is ever discontinued. | NoIts GitHub repository holds a README and images, not code. |
| PostgreSQL, MySQL, MariaDB, SQLite, SQL Server | YesPlus Azure SQL (Entra sign-in in progress) and hosted compatibles - 30 engines in all. Full list | YesPlus named connectors for Supabase, Neon and PlanetScale Postgres. |
| ClickHouse, Redis, Turso/libSQL | YesRedis also covers Valkey, KeyDB, DragonflyDB, ElastiCache and MemoryDB. Redis | YesRedis key browser for every key type, with memory and client metrics. |
| Oracle Database, DuckDB | YesNative drivers; DuckDB is bundled. Per-engine coverage | No |
| MongoDB, Amazon DynamoDB | No | YesBoth are listed as supported on the desktop app. |
| SSH tunnels | YesSSH hops, SOCKS and HTTP proxies, and Kubernetes. Engine docs | YesPassword or key authentication. |
| Import connections from other tools | YesDataGrip, DBeaver, pgAdmin, Azure Data Studio, DbGate, TablePlus, Navicat, Redis Insight and pg_service.conf - without passwords. Compatibility | -Its TablePlus page says it doesn’t read TablePlus connection files, so you recreate connections by hand. We found no importer documented. |
| IntelliSense | YesAlias- and scope-aware, JOIN ON from foreign keys, real column values in WHERE. IntelliSense |
PartialSchema-aware autocomplete for tables, columns and aliases, plus saved queries with version history. |
| Edit table data | YesA row editor generated from the table’s own metadata. Row editor | YesInline edits, with a review of pending inserts, updates and deletes before commit. |
| Pivot, charts & result diff | YesPivot, charts, conditional formatting, and diffs on any result. Pivot | PartialCharts live in dashboards. No pivot or result diff documented. |
| Dashboards | NoCharts sit on a result; there’s no dashboard canvas. The Server Dashboard shows server health, not your data. | YesMetric, chart, sparkline, map and table tiles with auto-refresh; the AI can build one from a table. |
| Import & export data | YesCSV, JSON, Excel, SQL, and more. Export | PartialExport to CSV, JSON or SQL; import CSV, JSON or SQL scripts. No Excel documented. |
| ER diagrams | YesExport to SVG, Mermaid, or DBML. Relationship Graph | YesA visual schema explorer with image export, and an ERD designer that exports SQL. |
| Execution plan viewer | In progressPlain-language findings, tree, and diagram across nine engines. Query plans | - |
| Schema & data compare | YesRisk-graded schema diffs and table diffs, with sync scripts. Schema Compare | - |
| Sessions, blocking & query cancel | YesActivity Monitor with blocking chains, top queries, waits, Server Dashboard. Activity Monitor | PlannedViewing active connections and cancelling a running query are on its roadmap, not started. |
| Indexes, users & permissions | YesDesigners, Edit Structure, and an index analyzer. Designers | PlannedIndex, user, role and maintenance tools are on its roadmap, not started. |
| Guardrails in the editor | YesSELECT-only connections, no UPDATE/DELETE without WHERE, auto-rollback, tenant checks. Safety |
PartialWarnings for destructive queries; the AI chat blocks write queries. |
| AI assistant | YesLocal models (Ollama, MLX), your own endpoint, or opt-in cloud providers; no default provider. On-device AI | YesOpenAI, Anthropic, Google, OpenRouter or Ollama on your own key, with off, schema-only and schema-and-data permission levels. |
| MCP server for AI agents | YesSchema tools and a read-only SELECT that is always rolled back; writes come back to you as proposals. How reads are kept read-only |
-None documented on its site. |
| Workflows & scheduled jobs | YesScheduled tasks and cross-engine Data Transfer. Tools | YesA drag-and-drop workflow builder for scheduled exports, transformations and cleanup jobs. |
| Browser version for a team | NoThe browser preview at sqlly.app/app is a demo. A bridge and relay let the desktop app reach remote databases. | YesStudio: one Docker image, free for 2 users, with roles, shared queries and dashboards, an audit log and scoped tokens. |
A dash means we couldn’t confirm it from DB Pro’s own materials - check its site and devlog for the current state.
Where SQLly is different
DB Pro puts its effort into a friendly browser, dashboards and team sharing. SQLly puts it into the SQL and the server.
A third of the download, no browser inside
SQLly’s macOS DMG is 65.6 MB; DB Pro’s is 204.4 MB, because it ships Chromium. Large results stream to disk past 50,000 rows or 64 MiB, so the grid stays flat on memory whether you fetch 50 rows or 50 million.
Spill-to-disk results →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 costs about 5 ms per keystroke.
Guardrails, not only warnings
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.
The DBA tools are already here
Activity monitor with blocking chains, Query Store and pg_stat_statements insights, SQL Agent, Extended Events, index analyzer, schema and data compare, and backup as reviewable scripts. DB Pro lists sessions, query cancel and index tools on its roadmap as not started.
Tools →A grid that does analysis
Pivot, charts, conditional formatting, computed columns, result diffs, and Excel export with live formulas and a pivot sheet. A one-line SQL comment saves the layout so it travels with the query.
SQLly directives →Bring your connections, let agents read
SQLly imports connections from DataGrip, DBeaver, TablePlus, Navicat, pgAdmin and more. Its MCP server lets an agent run one SELECT in a read-only transaction that is always rolled back; a write comes back to you as a proposal.
When DB Pro is the better choice
DB Pro is probably the better fit if:
- You need MongoDB or DynamoDB. DB Pro connects to both next to your SQL databases; SQLly connects to neither.
- You want dashboards. DB Pro builds tile dashboards from your tables, refreshes them on a timer, and the AI can draft one in two clicks. SQLly charts a single result and has no dashboard canvas.
- Your team wants a browser workspace. Studio is one Docker command, free for two users, and shares connections, queries and dashboards with roles and an audit log. SQLly has no shared web version.
- You’re on an Intel Mac. DB Pro ships an Intel build; SQLly needs Apple Silicon.
- You’d rather pay less up front, or monthly. At the $59 promo price DB Pro’s one-time licence costs less than SQLly 1.x, and $9.99 a month is an option SQLly doesn’t offer. Note that the one-time licence covers one year of updates.
- You mostly browse tables and run simple queries. If you don’t need plans, compare or admin tools, DB Pro’s simpler layout may suit you better.
One caveat in the other direction: DB Pro’s own pages disagree with each other. Its pricing page caps the free plan at 2 connections and 3 tabs while its FAQ says the free plan has no limit on local connections, and the one-time licence appears at $59, $79 and $99 on different pages. Check the pricing page before you buy.
Questions
Is DB Pro free?
DB Pro has a free desktop plan with limits: 2 connections, 3 open tabs, 5 saved queries, 2 dashboards, 2 table tags and 1 device, and its pricing table lists data import and export as paid features. Paid plans are a $99 one-time licence with one year of updates on 2 devices, shown at $59 with a promo code in November 2026, or $9.99 a month. The self-hosted Studio is free for up to 2 users. SQLly is free for hobbyists with two saved servers, and costs $100 one-time for SQLly 1.x or $200 for Lifetime.
Which databases do SQLly and DB Pro support?
Both connect to PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, ClickHouse, Redis and Turso (libSQL), and both work with hosted Postgres such as Supabase and Neon. DB Pro adds MongoDB and Amazon DynamoDB. SQLly adds Oracle Database, DuckDB, Azure SQL (Entra sign-in in progress) and Redis-compatible services such as Valkey and Amazon ElastiCache - 30 engines in all.
Is DB Pro a native app?
DB Pro’s comparison pages call it a true native app, but it is built on Electron: its Show HN post lists Electron, React and tRPC, and the 2.10.2 Linux package ships Chromium with a 332 MB app.asar. Its macOS download is 204.4 MB. SQLly is a single Rust app drawn on the GPU with no browser engine, and its macOS download is 65.6 MB.
Other comparisons
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.