Desktop SQL editors and IDEs for writing queries, browsing schemas and editing data: cross-platform multi-database clients, JetBrains IDE tooling, native macOS clients and engine-specific editors for SQLite, Oracle and MongoDB.
All sql clients & ides listings
Azure Data Studio
Retired by Microsoft on 28 February 2026; Microsoft recommends VS Code with the mssql extension.
DataGrip
JetBrains database IDE with SQL code analysis and refactoring; free for non-commercial use, paid for commercial use.
DB Browser for SQLite
Free open source editor for SQLite and SQLCipher files with spreadsheet-style editing and CSV import and export.
DBeaver
Popular universal database client supporting almost every engine.
dbForge Studio
Devart feature-rich IDE, with editions for SQL Server, MySQL, Oracle and PostgreSQL.
DbGate
Open source SQL and NoSQL client (MongoDB, Redis) as a desktop or self-hosted web app, with low-cost Premium.
DbVisualizer
Cross-platform JDBC database client with a free edition and a paid Pro edition.
JetBrains Rider Database Tools
DataGrip-level database tools bundled in the Rider .NET IDE; free for non-commercial use, paid for commercial.
MongoDB Compass
MongoDB's free official GUI: queries, aggregation builder, schema analysis, explain plans and embedded mongosh.
Navicat
Commercial multi-database client sold per user, with a free Premium Lite edition and modelling and sync in the paid editions.
Oracle SQL Developer
Oracle's free Oracle Database IDE: desktop app 26.2 plus SQL Developer for VS Code, updated quarterly.
Sequel Ace
Free MIT-licensed macOS client for MySQL and MariaDB, the successor to Sequel Pro.
SQLiteStudio
Free GPL v3 SQLite editor, renamed Letos in 2026, with ERD editor, plugins and a portable build.
TablePlus
Multi-database GUI for macOS, Windows, Linux and iOS; restricted free version, perpetual per-device licence.
Toad
Quest's professional toolset, best known for Oracle and SQL Server.
Comparisons
Free universal client versus JetBrains paid database IDE.
A broad open source client against a lightweight native one.
Two commercial multi-database tools with different strengths and licence models.
Quest's commercial Oracle toolset against Oracle's free tool and its VS Code extension.
Oracle's free tool against a JetBrains multi-database IDE.
Oracle's free tool against a free universal client.
Two cross-platform JDBC clients with different editors and licences.
Quest's paid Toad products, mostly Windows-first, against a free cross-platform universal client.
Open source universal client against a long-established commercial suite.
A full JetBrains IDE against a fast, minimal native client.
Two long-running cross-platform JDBC clients with free and paid editions.
A minimal multi-database client against a full commercial management suite.
Free NoSQL and web mode in DbGate vs DBeaver's larger SQL driver set and Enterprise tools.
Two free SQLite GUIs: feature-rich Letos (formerly SQLiteStudio) vs the simpler DB Browser for SQLite.
Alternatives and buyer guides
Related reading on CodeWithSQL
How we research listings: our editorial method. Other categories: the full SQL tools directory.
Compare before you choose
See the head to head comparisons or browse every category in the tools directory.