// sqlly vs dbforge studio

SQLly vs dbForge Studio

dbForge Studio for SQL Server is Devart’s long-running Windows IDE for SQL Server: schema and data compare, source control, a T-SQL debugger, tSQLt unit tests, a profiler, a monitor, a test data generator, a documenter, and CI plugins, sold in four editions. Devart also makes Studios for MySQL, PostgreSQL and Oracle, and bundles all four as dbForge Edge. SQLly is a younger, native workbench for macOS, Windows, and Linux that covers a lot of the same daily work and some of the deep end. Here’s where each one stands.

Last reviewed: November 2026

The short version

SQLly

One native workbench, three operating systems

One Rust codebase drawn on the GPU on macOS, Windows, and Linux. Thirty engines, IntelliSense that reads your data, layered safety guardrails, schema and data compare, activity monitoring, and script-first admin tools. A $100 or $200 one-time license, or free for hobbyists.

dbForge Studio

The full SQL Server suite, on Windows

A .NET Windows application, now at version 2026.2.82 (October 2026), with years of SQL Server tooling behind it: compare and sync, source control, debugger, unit tests, profiler, monitor, data generator, documenter, and DevOps plugins. Standard, Professional and Enterprise run $249.95 to $549.95 a year, or $499.95 to $1,099.95 perpetual. macOS and Linux need CrossOver.

Feature by feature

SQLly’s column uses the same honest status badges as the features page and the docs. For dbForge Studio for SQL Server we list what Devart’s own site, editions table, and docs state, and note which edition a feature needs.

Feature comparison of SQLly and dbForge Studio for SQL Server
Capability SQLly dbForge Studio
Windows YesA supported beta on x64 and arm64; the x64 zip is 60.9 MB. YesIts home platform. The installer is 140.09 MB.
macOS & Linux YesNative. macOS is signed and notarized (Apple Silicon only); Linux is a supported beta. PartialThrough CrossOver (Devart lists CrossOver 21) with .NET Framework 4.7.2 installed into the bottle, or under Parallels Desktop.
How the app is built NativeOne Rust codebase, rendered on the GPU (Metal, Direct3D, Vulkan). How it works .NETA Windows desktop app on .NET Framework 4.7.2 or later.
Free to use Free tierTwo saved servers, one cloud account, and a reminder to pay about every five hours. Pricing ExpressFree with a limited feature set; the app drops to it after the 30-day Enterprise trial.
Paid licenses One-time$100 for SQLly 1.x, $200 Lifetime. Yearly or perpetualStandard $249.95/yr or $499.95, Professional $399.95/yr or $799.95, Enterprise $549.95/yr or $1,099.95.
SQL Server & Azure SQL YesSQL Server and Azure SQL (Entra sign-in in progress). Engine list YesSQL Server 2000 (limited) through 2025, Azure SQL Database and Managed Instance, Synapse, Fabric, Amazon RDS, Entra MFA.
Other engines YesPostgreSQL, MySQL, MariaDB, Oracle, SQLite, DuckDB, ClickHouse, libSQL, Redis and wire-compatibles - 30 in all, in the same app. Separate StudiosMySQL/MariaDB, PostgreSQL and Oracle each have their own Studio; dbForge Edge bundles all four.
Code completion YesAlias- and scope-aware, JOIN ON from foreign keys, real column values in WHERE. IntelliSense YesCompletion, phrase completion, alias mapping, refactoring; limited in Express, advanced in Professional.
Formatter & code analysis PartialA formatter and a live GROUP BY check. YesFormatter profiles in every edition; T-SQL Code Analyzer from Professional.
T-SQL debugger No YesStandard and up.
Execution plans & profiling In progressPlain-language findings, tree, and diagram on nine engines. Query plans YesQuery Profiler with plan diagrams, wait stats and side-by-side comparison of runs, Standard and up.
Server activity & monitoring YesActivity Monitor with blocking chains, waits and expensive queries; Server Dashboard; Query Store insights; Extended Events. Activity Monitor YesMonitor (CPU, waits, top queries, sessions, data I/O) in every edition; Server Events Profiler from Professional.
Schema compare & sync YesRisk-graded diffs with sync and rollback scripts, across engines, plus snapshots. Schema Compare YesProfessional and up, with a command line, object mapping and snapshots; script folders and version control as sources in Enterprise.
Data compare & sync YesData Compare YesProfessional and up, with a command line.
Source control for database objects PartialA git panel for script folders and local DDL files overlaid on the live schema; no object-level source control. YesEnterprise: Git, TFVC, SVN, Perforce, Vault, Mercurial and Azure DevOps, with object history.
Unit tests No YestSQLt-based, Enterprise.
CI/CD automation PartialExport, backup, dump and restore dialogs copy the equivalent sqlly-cli command. YesCommand-line interfaces from Professional; PowerShell cmdlets and Jenkins, TeamCity, Azure DevOps and Bamboo plugins in Enterprise.
Test data generation YesTest data generator Yes200+ generators, inter-column dependencies, RegExp and Python; Professional and up.
Database documentation PartialA one-step Markdown data dictionary. Document schema YesHTML, PDF or Markdown documentation, Enterprise.
Visual designers & diagrams YesDesigners and a Relationship Graph exported to SVG, Mermaid or DBML. YesTable and view editors and database diagrams in every edition.
Security management YesLogins, users, roles and permissions. Security YesVisual editors for logins, users, roles, schemas and permissions in every edition.
Results: pivot, charts & reports YesPivot, charts, conditional formatting, computed columns, result diffs, Excel export with live formulas. Pivot YesPivot Table Designer, Master-Detail Browser and a data reporting tool, Standard and up.
Large result sets YesStreams and spills to disk past 50,000 rows or 64 MiB; memory stays flat at 50 million rows. Streaming -Couldn’t confirm from Devart’s materials.
Guardrails in the editor YesSELECT-only connections, no UPDATE/DELETE without WHERE, auto-rollback, tenant checks, prod in red. Safety PartialConnection coloring from Standard; Execution Warnings in Enterprise.
AI assistant YesLocal models (Ollama, MLX), your own endpoint, or opt-in cloud providers; no default provider. On-device AI YesCloud-only, on OpenAI and Anthropic models, sending metadata not data. Free plan with 200,000 tokens a month; 20 million for $9.95/month or $99.95/year, a separate license.
MCP server for AI agents YesSchema tools and a read-only SELECT that is always rolled back; writes come back to you as proposals. Read-only enforcement -Devart sells separate MCP Servers; we found none built into the Studio.
Redis YesKey editing, Cluster and Sentinel, ACLs, pub/sub, memory analyzer. Redis No

Perpetual prices are the ones Devart’s ordering page shows; a perpetual license includes an initial support and upgrade period that you can extend. Subscriptions also come in two- and three-year terms. A dash means we couldn’t confirm it from Devart’s own materials.

Where SQLly is different

dbForge Studio goes deep on SQL Server lifecycle work on Windows. SQLly goes wide on platforms and engines, and spends its depth on the editor, results, and safety.

Native on every OS you use

SQLly runs natively on macOS, Windows, and Linux, from one Rust codebase, so a Mac or Linux user doesn’t need CrossOver, a .NET Framework bottle, or a Windows VM to get the same tool as the Windows user next to them.

Cross-platform →

Thirty engines, one app, one license

SQL Server, PostgreSQL, MySQL, Oracle, DuckDB, ClickHouse, Redis and more live in one window. With Devart you buy a Studio per engine or dbForge Edge at $749.95 a year or $1,499.95 perpetual.

Supported engines →

Guardrails for the person typing

Read-only connections that refuse file-reading and shell-escape tricks, a hard stop on UPDATE/DELETE without WHERE, auto-wrapped transactions, tenant checks, and an optional AI review before a data change - inherited down your client, project, and environment tree.

Safety & guardrails →

AI that can stay on your machine

SQLly has no default AI provider. Point it at Ollama or MLX on your laptop, at your own endpoint, or opt in to a cloud provider. dbForge’s AI Assistant runs on OpenAI and Anthropic models through Devart.

On-device AI →

Results that don’t run out of memory

Rows stream to disk past 50,000 rows or 64 MiB, so a 50-million-row result uses about as much memory as a small one. Pivot, charts, computed columns and Excel export with live formulas sit on top.

Spill-to-disk results →

Pay once, under $200

A SQLly 1.x license is $100 and Lifetime is $200, with no subscription. dbForge Studio for SQL Server Professional, the edition with compare and data generation, is $399.95 a year or $799.95 perpetual.

Pricing →

When dbForge Studio is the better choice

dbForge Studio has many years of SQL Server work behind it, and in several areas it is simply further along. It’s probably the better fit if:

  • You debug T-SQL. dbForge has a T-SQL debugger from Standard up. SQLly has none.
  • Your database lives in source control. Enterprise links database objects to Git, TFVC, SVN, Perforce and others, compares against script folders, and runs tSQLt unit tests. SQLly’s git support covers script folders, not database objects.
  • You deploy from CI. Command-line compare, data generation and documentation, PowerShell cmdlets, and plugins for Jenkins, TeamCity, Azure DevOps and Bamboo are things SQLly doesn’t match.
  • You read execution plans every day. dbForge’s Query Profiler is finished and compares runs side by side; SQLly’s plan view is still marked in progress.
  • Your team is on Windows and on SQL Server only. Then SQLly’s cross-platform and multi-engine reach is worth less to you, and dbForge’s depth is worth more.
  • You work with Azure Synapse, Microsoft Fabric, or a very old SQL Server. Devart lists Synapse pools, Fabric Data Warehouse, and SQL Server back to 2000 (with limits); SQLly doesn’t document any of them.

One caveat in the other direction: on a Mac or Linux machine dbForge runs through a compatibility layer, so test your daily workflow in CrossOver before you buy for a mixed team.

Questions

How much does dbForge Studio for SQL Server cost?

Devart sells four editions. Express is free with a limited feature set and is what the app falls back to after the 30-day Enterprise trial. Standard is $249.95 a year or $499.95 perpetual, Professional $399.95 a year or $799.95 perpetual, and Enterprise $549.95 a year or $1,099.95 perpetual. The paid AI Assistant is a separate license. SQLly is free for hobbyists, $100 one-time for a SQLly 1.x license, or $200 for Lifetime.

Does dbForge Studio run on macOS or Linux?

Devart describes dbForge Studio as a Windows-native application. Its docs explain how to run it on macOS and Linux inside CrossOver, the CodeWeavers compatibility layer based on Wine, with .NET Framework 4.7.2 installed into the same bottle, or under Parallels Desktop. SQLly is a native app on macOS, Windows and Linux built from one Rust codebase.

Is SQLly a replacement for dbForge Studio?

For some people. SQLly covers the daily SQL Server work - editor, IntelliSense, results, schema and data compare, activity monitoring, test data - on three operating systems and 30 engines. dbForge Studio has things SQLly does not: a T-SQL debugger, tSQLt unit tests, source control for database objects, CI plugins and a much longer track record. If your team depends on those, stay with dbForge.

// 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.