Free desktop database browsers: DBX, DbGate, DBeaver Community and JetBrains DataGrip
DBX and DbGate score level among the free desktop apps that open both SQLite files and database servers; we name DBX, narrowly ahead of DBeaver Community, because it keeps saved passwords in the system keychain and exports to Excel and SQL. Just remember that its read-only setting is enforced by the app, not the database.
DBX
An Apache-licensed app that opens SQLite files and PostgreSQL, MySQL and many other databases, keeps saved passwords in the system keychain and exports to CSV, Excel and SQL, scoring level with DbGate in our weighted scores.
Its read-only mode relies on DBX’s own SQL checks, not the database, and its lead developer is known by the handle t8y2, with no company or full name published.
Why DBX is our PickTeam behind DBX? Get your award badge
No Rising Star selected
DBX, our Rising Star in October, is now our Pick. The other newer apps we found lack a documented read-only mode, a named operator, a patched security fix or a stable release.
We could not check every candidate, so this is not a claim that no qualifying newer app exists.
Who is this article for? People who need to browse, filter, query and export data from an existing SQLite file or a PostgreSQL or MySQL database they are authorized to reach, on their own Windows, macOS or Linux computer, without buying a license.
About 32 min read
What Preferred Pick, Rising Star and Ready to Rock mean
The quick list
All four can be used free, DataGrip only for non-commercial use. Compare which databases each free edition opens, how it protects data you only mean to read and what it lets you export.
DbGate Community, DBX and DBeaver Community are free, open-source apps with no account or per-seat charge; DbGate and DBeaver also sell paid editions. JetBrains DataGrip is free only for personal and other non-commercial use and needs a JetBrains Account; its commercial licence is listed at $10.90 a month. Checked November 12, 2026.
The comparison at a glance
Compare which databases each free edition opens, how it protects data you only mean to read, what it exports and what it stores on your computer.
Order follows our verdict for a free desktop database browser: the Pick, then the next three highest-scoring apps. It is not measured speed, usability or security. All tools remain selectable.
Hides matching answers for the selected tools. Unknowns and unverified claims stay visible.
| Feature | DBX | DbGate | DBeaver Community | JetBrains DataGrip |
|---|---|---|---|---|
| Best fit | Preferred Pick: a small free app for files and servers that keeps passwords in the system keychain, if you accept a project led by one developer known by a handle (narrow lead) | Level with the Pick: files and servers for free, with a read-only option we could not confirm in the free edition, if you will not save passwords that matter | SQLite files and servers in one free app from a company, if you will not save passwords that matter | A full database IDE, free only for personal and other non-commercial use |
| Databases in the free edition | SQLite, PostgreSQL, MySQL, MariaDB, SQL Server, DuckDB, Redis, MongoDB and many more; no paid edition | SQLite, PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, MongoDB, Redis, DuckDB and others; libSQL, Redshift and some cloud sources are Premium | SQLite, PostgreSQL, MySQL, MariaDB and many other relational engines; NoSQL and cloud drivers are PRO | The full IDE, identical to the paid product per JetBrains, with SQLite, PostgreSQL and MySQL support |
| Cost, checked November 12, 2026 | $0; no paid edition; donations and sponsors | $0 Community; Premium and Team Premium are paid | $0; PRO editions are paid | $0 under the non-commercial licence; the commercial licence is listed at $10.90 a month |
| License and who may use it free | Apache 2.0, any use | GPL-3.0; "free to use for any purpose", per its project page | Apache 2.0, any use; site calls Community "recommended for personal projects" | JetBrains non-commercial agreement: learning, hobby, open-source and content creation; any use as part of a business needs a paid licence; needs a JetBrains Account |
| Read-only control in the free edition | "Read-only connection" enforced by DBX’s own SQL checks, not the database; writes can be unlocked for 1 or 5 minutes after a confirmation | "Is read only" option: the database’s read-only session where supported, otherwise no SQL runs (vendor guide; no edition marker, not confirmed in the free build) | Read-only connection setting plus data, structure, script and import restrictions; depends on driver support | A "Read-only" data source option blocks edits in the data editor; changes may still be possible in the query console if the driver does not support it |
| Getting data out in the free edition | Results or selections to CSV, TSV, JSON, Markdown, XLSX or SQL statements; whole database or schema to an SQL file | Tables, filtered data or query results to CSV, JSON, Excel, XML, SQL and more; multi-table export included | Results, tables or grid to CSV, JSON, SQL, HTML, XML, Markdown, TXT and more; XLSX and Parquet are PRO | SQL INSERT or UPDATE statements, CSV, TSV, Excel, Markdown, HTML and JSON, one file per table |
| Saved passwords | In the system keychain since 0.6.21 (September 2026); the portable Windows build keeps its key beside the data | Encrypted with a per-install key that is stored, encrypted with a key from the public source, in the same folder; can skip saving | Stored under a key DBeaver says is public in its source; stronger storage is paid | System keychain on macOS and Linux or a KeePass database with a master password, per JetBrains help pages read through search copies |
| Latest release, checked November 12, 2026 | 0.6.69, November 10, 2026; 434 releases since the first on April 29, 2026 | 7.3.6, November 12, 2026; first releases May 2020 | 26.2.4, November 2, 2026; minor releases about every two weeks | Not checked in this review |
Free desktop apps for an existing SQLite file or an authorized PostgreSQL or MySQL database. Public-source research checked October 19 and 20 and November 12, 2026: no installs, connections, queries, exports or read-only tests by us. DBX leads DBeaver Community by 0.03 on our weighted scores, a narrow lead, and DbGate scores the same as DBX. Saved client settings are not a backup of the database. Next substantive review: December 18, 2026.
All features and sources 18 criteria
Open the groups that matter to you. They compare the same selected tools. “Planned” means future work, not an available feature. Sources include the published conditions.
Database job and edition
Show 7 criteria
| Feature | DBX | DbGate | DBeaver Community | JetBrains DataGrip |
|---|---|---|---|---|
| Best fit | Preferred Pick: a small free app for files and servers that keeps passwords in the system keychain, if you accept a project led by one developer known by a handle (narrow lead) | Level with the Pick: files and servers for free, with a read-only option we could not confirm in the free edition, if you will not save passwords that matter | SQLite files and servers in one free app from a company, if you will not save passwords that matter | A full database IDE, free only for personal and other non-commercial use |
| Databases in the free edition | SQLite, PostgreSQL, MySQL, MariaDB, SQL Server, DuckDB, Redis, MongoDB and many more; no paid edition | SQLite, PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, MongoDB, Redis, DuckDB and others; libSQL, Redshift and some cloud sources are Premium | SQLite, PostgreSQL, MySQL, MariaDB and many other relational engines; NoSQL and cloud drivers are PRO | The full IDE, identical to the paid product per JetBrains, with SQLite, PostgreSQL and MySQL support |
| Desktop systems | Windows 10 and 11 (x64), macOS (Apple silicon and Intel), Linux; a Docker web version too | Windows (x64, ARM64), macOS (universal), Linux deb, Snap and AppImage; a Docker web version too | Windows 10+, macOS 11+, Linux; x86 and ARM builds with Java bundled | Windows, macOS and Linux |
| Cost, checked November 12, 2026 | $0; no paid edition; donations and sponsors | $0 Community; Premium and Team Premium are paid | $0; PRO editions are paid | $0 under the non-commercial licence; the commercial licence is listed at $10.90 a month |
| License and who may use it free | Apache 2.0, any use | GPL-3.0; "free to use for any purpose", per its project page | Apache 2.0, any use; site calls Community "recommended for personal projects" | JetBrains non-commercial agreement: learning, hobby, open-source and content creation; any use as part of a business needs a paid licence; needs a JetBrains Account |
| Browse, filter and query | Data grid with database-side WHERE and ORDER BY, filters and an SQL editor with completion; edits shown as SQL before saving | Data browser with filters and sorting and an SQL editor; editing query results is Premium | Data editor and SQL editor with tasks and maintenance tools | Data editor and query console of the full IDE, per JetBrains help pages read through search copies |
| Encrypted SQLite (SQLCipher) | Compiled in by default, per its build guide; not checked in the app | Not documented in the pages we read | Cipher options documented on its SQLite page without a paid marker | Not checked |
These selected tools have matching answers in this group. Turn off “Show differences only” to see them.
Sources for database job and edition
Checked October 19 and 20 and November 12, 2026. DbGate project page and edition comparison; DBX project page, downloads and getting started; DBeaver Community, downloads, license and SQLite settings; JetBrains DataGrip pricing and free licence and non-commercial agreement. No app supplies a database server or access you do not already have.
Inspecting and getting data out
Show 3 criteria
| Feature | DBX | DbGate | DBeaver Community | JetBrains DataGrip |
|---|---|---|---|---|
| Read-only control in the free edition | "Read-only connection" enforced by DBX’s own SQL checks, not the database; writes can be unlocked for 1 or 5 minutes after a confirmation | "Is read only" option: the database’s read-only session where supported, otherwise no SQL runs (vendor guide; no edition marker, not confirmed in the free build) | Read-only connection setting plus data, structure, script and import restrictions; depends on driver support | A "Read-only" data source option blocks edits in the data editor; changes may still be possible in the query console if the driver does not support it |
| Getting data out in the free edition | Results or selections to CSV, TSV, JSON, Markdown, XLSX or SQL statements; whole database or schema to an SQL file | Tables, filtered data or query results to CSV, JSON, Excel, XML, SQL and more; multi-table export included | Results, tables or grid to CSV, JSON, SQL, HTML, XML, Markdown, TXT and more; XLSX and Parquet are PRO | SQL INSERT or UPDATE statements, CSV, TSV, Excel, Markdown, HTML and JSON, one file per table |
| Export caveat | Grid exports cover the loaded result or selection, and an export row limit applies; check the row count | Filters apply to exported table data; a table backup is SQL, not a server backup | Rows and DDL scripts, not users, permissions or a server backup | Rows and scripts, not users, permissions or a server backup |
These selected tools have matching answers in this group. Turn off “Show differences only” to see them.
Sources for inspecting and getting data out
DbGate connection guide, export guide and changelog; DBX write safety, data grid and database export; DBeaver connection restrictions, data transfer formats and export; DataGrip help on data sources and data extractors, read through search-engine copies because the pages render empty for our fetcher. Read-only settings were not tested and do not replace a read-only database account.
Local state, privacy and continuity
Show 8 criteria
| Feature | DBX | DbGate | DBeaver Community | JetBrains DataGrip |
|---|---|---|---|---|
| Saved passwords | In the system keychain since 0.6.21 (September 2026); the portable Windows build keeps its key beside the data | Encrypted with a per-install key that is stored, encrypted with a key from the public source, in the same folder; can skip saving | Stored under a key DBeaver says is public in its source; stronger storage is paid | System keychain on macOS and Linux or a KeePass database with a master password, per JetBrains help pages read through search copies |
| What the app saves beside your data | dbx.db: connections, saved SQL, history and settings; secrets in the keychain | Data folder: connections, the encryption key file, SQL files and settings | DBeaverData workspace: connections, credentials file, scripts and diagrams | IDE settings and project files; we did not inspect them |
| Network use it documents | No DBX account; contacts only your databases, chosen AI provider, sync service, plugin sources and updates | Built-in updater; optional DbGate Cloud storage; usage data not documented in the pages we read | Usage statistics with an opt-out; AI sends table and column names after you confirm | Anonymous usage statistics; detailed code-related data collected by default and can be switched off; JetBrains Account required |
| Latest release, checked November 12, 2026 | 0.6.69, November 10, 2026; 434 releases since the first on April 29, 2026 | 7.3.6, November 12, 2026; first releases May 2020 | 26.2.4, November 2, 2026; minor releases about every two weeks | Not checked in this review |
| Who stands behind it | One lead developer known by the handle t8y2, with 411 contributors; no company or full name published; donations and sponsors | Its author, Jan Procházka, with Sprinx Systems, which sells Premium | DBeaver Corp, which sells the PRO editions | JetBrains s.r.o. of Prague |
| Recent security record | One critical advisory (CVE-2026-55642) in the Docker web service, fixed in 0.5.51; the desktop app was not affected | Several critical and high-severity 2026 advisories, including code execution in the desktop app; all fixed, none open on November 12 | 2026 releases fixed an XML parser flaw, SQL injection in two drivers and, in 26.2.3, password shell commands that ran without confirmation; no GitHub advisories listed | Not checked |
| App runtime, checked November 12, 2026 | Tauri with the system web view; no bundled Chromium | Electron 44.7.2, supported until March 2027 | Bundled OpenJDK 25, still supported; no bundled browser engine | JetBrains Runtime; support dates not public |
| Leaving later | Data stays in your database; remove dbx.db and the keychain entries separately | Data stays in your database; remove the data folder separately | Data stays in your database; remove the workspace folder separately | Data stays in your database; IDE settings stay on your computer |
These selected tools have matching answers in this group. Turn off “Show differences only” to see them.
Sources for local state, privacy and continuity
DbGate encryption source, app package, 7.3.6, releases, Premium announcement and advisories; DBX credential migration, privacy policy, releases, maintainer profile and advisory; DBeaver secure storage, project security, workspace, statistics, AI privacy, release notes and Java notes; JetBrains non-commercial agreement and password storage help; Electron support schedule. Policy statements are not audited behavior.
What matters when choosing
DBX is our Practical Pick for someone who needs a free desktop app to browse, filter, query and export data from an existing SQLite file or a PostgreSQL or MySQL database they are authorized to reach. First released on April 29, 2026, it is a free, Apache-licensed app of about 25 MB that opens SQLite files and PostgreSQL, MySQL and many other databases on Windows, macOS and Linux. It keeps saved passwords in the operating system’s keychain, exports results to CSV, JSON, Excel and SQL, and has a read-only connection setting, all without a paid edition. Its main limit: that read-only setting is enforced by DBX’s own checks of your SQL rather than by the database, and the project is led by one developer known by the handle t8y2, with no company or full name published, and has no independent test of its read-only mode or exports that we could find. Use a read-only database account with it. DBX project page, write safety, first release
DBX’s lead over DBeaver Community is narrow, and DbGate scored level with DBX. On our weighted scores out of 5, DBX and DbGate both score 4.22, DBeaver Community 4.18 and JetBrains DataGrip 4.10, so a half-point change on one criterion could reorder the top three. DBX and DbGate scored level, and we name DBX because DbGate’s equal score depends on a read-only option that its guide documents but that we could not confirm in its free edition; with that score half a point lower, DBX leads alone. No other app overtakes DBX whether price counts for more or for less. DBX publishes new versions almost daily; independent testing of its read-only mode, or a read-only mode enforced by the database, would make the recommendation firmer. DBX issues, maintainer profile
The most important compromise among the other apps is saved passwords. DbGate encrypts saved passwords with a key it creates for each installation, but keeps that key in the same data folder, itself encrypted with a key written in the public source, so anyone who can copy the folder can decrypt them. DBeaver Community’s default storage has the same weakness. DBX and JetBrains DataGrip store saved passwords more safely. Encryption source, DBeaver project security
No Rising Star selected. DBX, which we named our Rising Star in October, is now our Pick, and an app cannot hold both. We searched again for apps first released in the last 24 months and found none that is available now, passes our safety checks and documents a read-only mode: DB Pro names no operator and lists no read-only mode, Tabularis has an unpatched high-severity advisory in its read-only protection, Openhare and Tuiql document no read-only mode, and Rustable’s maker calls it early software. Details are in “How we researched”.
Disclosure: Practical Picks articles are researched and written with AI, currently Anthropic’s Claude. DBX’s AI assistant can use Claude among other models, and its separate MCP server lets coding agents such as Claude Code query connections set up in DBX. We have no relationship with DBX’s developers or with Anthropic over this article, and the AI features carried no weight in our judgment. DBX features
DbGate scored level with DBX and is the app to choose if you want a named author and company behind it. It opens SQLite files and servers in its free Community edition, has an “Is read only” connection option in its guide that we could not confirm in the free edition, and exports to CSV, JSON, Excel, XML and SQL; its weak point is saved passwords, which you can skip saving. DBeaver Community scored 4.18: it has the longest release record here, a company behind it, a read-only setting that is passed to the database driver and exports to CSV, JSON, SQL and other formats, but its saved passwords use a key DBeaver says is public. Version 26.2.4 was released on November 2, 2026. JetBrains DataGrip scored 4.10: its exports and keychain password storage are strong, but its free licence covers only personal and other non-commercial use, needs a JetBrains Account and collects usage data, including detailed code-related data, by default. DbGate project page, DBeaver Community, DataGrip non-commercial agreement
If all you have is one SQLite file, consider DB Browser for SQLite. It does only SQLite and SQLCipher files, and its “Open Database Read Only” option asks SQLite itself to refuse writes rather than relying on a setting in the app. It exports tables to CSV or JSON and the whole file to an SQL dump. It scored 3.56, mainly on database coverage, and its last stable release, 3.13.1, is from October 16, 2024, though nightly builds continue. Details are in “How we researched”.
These are researched judgments from documentation, license terms, source code, release records and public reports checked October 19 and 20 and November 12, 2026. We did not install any app, open a database or run a query. Three conditions would change our recommendation: confirming that DbGate’s read-only option works in its free edition (the two would then be fully level), a read-only mode enforced by the database in DBX, or a future change to DBeaver’s free license or credential storage. If your job never leaves one SQLite file you must not change, DB Browser for SQLite is an alternative. None of these apps grants access you do not already have or backs up the database it opens.
DBX
Preferred Pick · a small free app for files and servers
Choose DBX if you want one small free app for SQLite files and database servers that keeps saved passwords in your system keychain. Connect with a read-only database account, because its read-only setting relies on DBX’s own checks of your SQL.
Reasons to choose it
- SQLite, PostgreSQL, MySQL and many more, with no paid edition
- Saved passwords go into the system keychain
- Exports to CSV, JSON, Excel and SQL, plus whole-database SQL files
What to watch
- Read-only mode is enforced by the app, not the database, and can be unlocked
- Lead developer known by the handle t8y2; no company or full name published
- Several releases a week and about 1,600 open issues
DBX is an open-source database client whose first release came out on April 29, 2026. It is published under the Apache 2.0 license, which allows any use, and has no paid edition; the project asks for donations and sponsors. Its project page says the desktop app is about 25 MB because it uses the operating system’s own web view through Tauri instead of bundling Chromium, and that it connects to more than 100 databases, including SQLite, PostgreSQL, MySQL and MariaDB; its build guide says SQLCipher support is compiled in by default. The download page offers installers for Windows 10 and 11, macOS on Apple silicon and Intel, and Linux. Version 0.6.69 was released on November 10, 2026. Project page, downloads, first release, getting started
Three things make it a strong fit for this reader. Saved passwords and other secrets go into the operating system’s keychain (Keychain on macOS, Credential Manager on Windows, Secret Service on Linux) rather than a file beside your settings; DBX moved them there from plain text in version 0.6.21 on September 23, 2026, and its portable Windows build is the exception, keeping its key next to the data. The data grid exports a result or selection to CSV, TSV, JSON, Markdown, Excel (XLSX), SQL INSERT or UPDATE statements, and a separate database export writes a whole database or schema to an SQL file. Its privacy policy, dated September 27, 2026, says the app needs no DBX account and contacts only the databases, AI provider, sync service, plugin sources and update servers you use. Credential storage, security upgrade, 0.6.21 release note, data grid and exports, database export, privacy policy
Read the full DBX analysis and sources
Understand its read-only setting before relying on it. Marking a connection read-only makes DBX reject statements it recognizes as writes in its editor, data grid, transfers, command-line tool and MCP server. DBX’s documentation says this enforcement “depends on classifying SQL”, that a write attempt opens a dialog that can unlock writes on that connection for one or five minutes, and that a database account without write permission is the most reliable boundary. The database itself is not told to refuse writes, as it is with DB Browser for SQLite’s read-only opening, so use a read-only database account for anything that matters. Grid exports also follow what is loaded: the documentation says a result export covers the current result and selection, and asks you to check the page, filters and sorting so visible rows are not mistaken for the whole table. Production and write safety, data grid
The strongest reason not to choose it is who stands behind it. DBX is led by one developer known by the handle t8y2, based in Beijing according to the GitHub profile, with no company or full name published; 411 people have contributed. It publishes new versions almost daily (434 releases since April, counting test builds) and had about 1,600 open and 7,400 closed issues and 206 open pull requests on November 12, 2026. Its one published advisory, a critical flaw (CVE-2026-55642) that left the separate Docker web service open to anyone on the network when no password was set, was fixed in version 0.5.51; the advisory says the desktop app, which listens only on the computer itself, was not affected. Repository and issue counts, issues, maintainer profile, advisory GHSA-rqp4-8fxh-22vh
Independent evidence is thin: we found enthusiastic blog coverage, including a May 2026 post that DBX quotes on its homepage, but no independent test of its read-only setting, exports or stability. Choose DbGate or DBeaver Community instead if you want a named author or a company behind the app. Choose DBX if a small app with keychain-stored passwords and free Excel export matters more to you, and you will connect with a read-only database account. Blog review, May 27, 2026
Used DBX? Share your experience to help other readers choose.
DbGate
Level with the Pick · free for files and servers
Choose DbGate when you want a named author and company behind one free app for SQLite files and database servers, with a read-only connection option and exports to CSV, JSON, Excel, XML and SQL. Skip saving passwords for servers that matter, and use a read-only database account for anything important.
Reasons to choose it
- SQLite, PostgreSQL, MySQL and many more in the free edition, for any use
- A read-only option that uses the database’s read-only session where supported
- Exports tables, filtered data or results to CSV, JSON, Excel, XML or SQL, with multi-table export
What to watch
- Anyone who copies its data folder can decrypt saved passwords
- We could not confirm the read-only option in the free build
- Some features have moved between the free and Premium editions
DbGate is a database manager written by Jan Procházka and first published in May 2020. Its project page says the Community edition is licensed under GPL-3.0 and free to use for any purpose; paid Premium and Team Premium editions add features such as editing query results, a query designer and some cloud databases, and the product site names Sprinx Systems, LLC as the company that sells them. Community connects to SQLite, PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, MongoDB, Redis, DuckDB and others, and runs on Windows, macOS and Linux. Community also includes optional DbGate Cloud storage for up to five connections and five SQL files. Version 7.3.6 was released on November 12, 2026. Project page, edition comparison, releases, earliest releases
Two free features fit this reader. The connection dialog has an “Is read only” option; DbGate’s guide says the connection then uses the database’s read-only session where the engine supports one, and otherwise refuses to run SQL at all. The edition comparison does not list it as a paid feature, but we could not confirm it in the Community build, and we did not test it. Exports work from a table, filtered table data or a query result, and Community also exports and imports several tables at once and backs up and restores tables; saved export jobs and the “advanced” import and export tools are listed as Premium. Its guide and changelog cover CSV, JSON, Excel, XML and SQL output. Connection guide, export guide, changelog
Read the full DbGate analysis and sources
The strongest reason not to choose it is saved passwords. DbGate’s source encrypts them with a key generated for each installation, but keeps that key in the same data folder, itself encrypted with a key written in the public source, so anyone who copies the folder can decrypt them. The connection dialog can skip saving the password instead. Encryption source
Keep it current. In 2026 DbGate published several critical and high-severity advisories, including one in which a crafted icon could lead to code running in the desktop app; the latest was published on May 22, 2026, all were fixed, and none was open on November 12. In October the desktop app was built on Electron 38.6.0, which had stopped receiving security fixes in March 2026; version 7.3.6 is built on Electron 44.7.2, which is supported until March 2027. App package, 7.3.6, Electron support dates, security advisories
Choose DbGate if you prefer its interface and free multi-table export, and you will not save passwords for servers that matter. Choose DBeaver Community instead if you want a read-only setting that the vendor documents for its free edition and a company behind the app, and DBX, our Pick, if you want passwords in the system keychain and can accept a project led by one developer known by a handle.
Used DbGate? Share your experience to help other readers choose.
DBeaver Community
Longest record · company-backed and free
Choose DBeaver Community if you want a longer release record and a company behind the app, with a read-only setting passed to the database driver and exports in the free edition. Avoid saving passwords for servers that matter.
Reasons to choose it
- SQLite, PostgreSQL and MySQL in the free edition, for any use
- Read-only connection setting and finer edit restrictions
- Exports to CSV, JSON, SQL and other formats without paying
What to watch
- Saved passwords use a key DBeaver says is public
- Read-only depends on the database driver honoring it
- A broad interface for a single-file job
DBeaver Community is the free, open-source edition of DBeaver Corp’s database tool. The vendor lists MySQL, MariaDB, PostgreSQL and SQLite among the relational databases it supports, with a data editor, SQL editor, task management and maintenance tools. NoSQL, cloud and some enterprise sign-in methods are reserved for paid PRO editions. A SQLite connection points at a file path; a server connection needs the host, account and network access you already have. The download page lists Windows 10 or later, macOS 11 or later and Linux, with x86 and ARM builds, and a bundled Java runtime. We verified that the Community license is Apache 2.0, which permits commercial use; the homepage nonetheless describes Community as “recommended for personal projects”, which is positioning rather than a license condition. Homepage and edition comparison, downloads and system requirements, license, SQLite connection settings
Two free-edition features fit this reader. First, a connection can be marked read-only, and further switches restrict data edits, structure edits, script execution and data import. DBeaver says the read-only setting ensures “no data can be modified or deleted”; we treat that as a vendor claim, because users report that it depends on the database driver honoring read-only mode. Second, the Community data-transfer tools export query results, whole tables or the visible grid to CSV, JSON, SQL, HTML, XML, Markdown, TXT, DbUnit or source code; XLSX and Parquet exports are marked PRO-only. An export is rows or DDL, not a backup of permissions, users or the server itself. Security restrictions, data transfer formats, data export, read-only discussion
Read the full DBeaver Community analysis and sources
The strongest reason not to choose it is credential storage. DBeaver’s security page says Community offers only the “Integrated security” password provider, and that storing database connection credentials in secure storage is available in its Lite, Enterprise and Ultimate editions. By default, database credentials stay in local configuration files. Its project-security page says those files are encrypted with a key published in DBeaver’s source, so they can be decrypted with outside software; a public open-source tool does exactly that. If you must save a password, protect the computer and the DBeaverData folder accordingly, and prefer a read-only database account. Secure storage, project security, dbeaver-creds
Keep it current. DBeaver 26.1.4 (August 2, 2026) added the option to fetch connection passwords from a shell command, and 26.2.3 (October 18, 2026) fixed a command-execution vulnerability by asking for confirmation before running such commands. Version 26.2.4 (November 2, 2026) updated the bundled Java runtime to protect TLS connections from certificates affected by the eMudhra certificate authority key compromise. Earlier 2026 releases fixed an XML parser weakness, SQL injection in two database drivers and vulnerable libraries. Its installers bundle OpenJDK 25, a Java release that still receives security updates, and no browser engine of their own; its GitHub page lists no published security advisories. Release notes, Java notes, GitHub advisories
DBeaver stores connections, scripts and diagrams in a DBeaverData workspace folder separate from the app, so uninstalling does not remove them and copying the folder copies the saved credentials file too. It collects usage statistics about the operating system, user-interface actions and database types, which you can switch off in Preferences; it says it does not collect queries or connection settings. Since 26.1.2 (July 5, 2026) Community includes an AI chat; DBeaver says it sends table and column names to the AI provider you configure only after you confirm, and the feature can be disabled. DBeaver Corp’s privacy policy covers its website and registrations, not the desktop app in detail. Workspace location, statistics collection, AI data privacy, disabling AI, privacy policy
Choose DB Browser for SQLite instead if you will only ever open SQLite files and want a smaller app whose read-only mode is enforced by SQLite. DBeaver’s SQLite page also documents encrypted SQLite connections (SQLCipher and other ciphers) without marking them paid; we did not confirm them in the Community build.
Used DBeaver Community? Share your experience to help other readers choose.
JetBrains DataGrip
Free for non-commercial use only
Consider DataGrip if your use is personal or otherwise non-commercial and you want a full database IDE with strong exports. Its free licence excludes any use as part of a business and needs a JetBrains Account.
Reasons to choose it
- Exports to CSV, Excel, JSON, SQL statements and more
- A read-only data source option, with passwords in the system keychain or a KeePass database
- The same product as the paid IDE
What to watch
- Free only for non-commercial use
- Needs a JetBrains Account; usage data collected by default
- Read-only blocks data-editor edits but depends on the driver in the query console
JetBrains DataGrip is a database IDE from JetBrains s.r.o. of Prague. JetBrains has offered it free for non-commercial use since October 2025: learning and self-education, open-source contributions without commercial benefit, content creation and hobby development. JetBrains says the free licence gives the full product, identical to the paid one. The agreement defines commercial use as use “as part of the Customer’s business activity”, so a reader using it for work needs a paid licence, which JetBrains lists at $10.90 a month on its buy page (checked November 12, 2026). The free licence needs a JetBrains Account. DataGrip pricing and free licence, non-commercial agreement, announcement, October 1, 2025
Its features fit the job. JetBrains’s help pages, which render empty for our fetcher and which we read through search-engine copies on October 20, 2026, describe a “Read-only” data source option that blocks edits in the data editor, with the caveat that changes might still be possible in the query console if the driver does not support the read-only status. Exports cover SQL INSERT and UPDATE statements, CSV, TSV, Excel, Markdown, HTML and JSON, one file per table. Saved passwords go to the system keychain on macOS and Linux or to a KeePass database protected by a master password. Data source options, data extractors, password storage
Read the full JetBrains DataGrip analysis and sources
The strongest reason not to choose it is the licence and the data collection. The non-commercial agreement says the product collects anonymous usage data and, in its default mode, detailed code-related data, and only the code-related part can be switched off; it also allows compliance checks that send usage information. JetBrains’s own buy page says the same. We did not check DataGrip’s current release, advisories or runtime, so those are not scored. Choose DataGrip if your use is non-commercial and you want a full IDE; otherwise choose DbGate or DBeaver Community. Agreement terms
Used JetBrains DataGrip? Share your experience to help other readers choose.
Which product are we missing?
Know a product that belongs in this article? Tell us what it does differently and why it deserves a closer look. Newcomers welcome.
Readers and product teams can suggest candidates. Suggestions inform our research; they do not guarantee inclusion or a recommendation.
Opens an email draft with this article attached as a link. Nothing is sent until you send it.
No email app? Send the product name, website, and this article’s title to admin@practicalpicks.guide.
What people are saying
Public discussion is a check on vendor claims, not a measured reliability score. In a 2023 DBeaver discussion, a SQLite user set a “readonly” driver property and could still start editing cells, without trying to save; another user pointed to the connection’s read-only setting instead. On September 3, 2026, a commenter said the Databricks driver does not support read-only mode, and on September 17 another suggested opening a SQLite file through a read-only URI so the driver enforces it. Together they suggest DBeaver’s setting depends on the driver, which is why we recommend a read-only database account for anything important. DBeaver discussion
A public open-source tool, dbeaver-creds, decrypts DBeaver’s credentials-config.json and prints the stored connection details. It corroborates DBeaver’s own statement that the default encryption key is public. dbeaver-creds
DBX’s homepage quotes enthusiastic coverage from bloggers, and its issue tracker held about 1,600 open and 7,400 closed issues on November 12, 2026, a mix of bug reports and feature requests in Chinese and English; we read that as a sign of a busy, fast-moving project, not as a reliability measure. A 2021 SQLite forum report described a DB Browser for SQLite crash that lost uncommitted edits, and SQLite’s creator explained that uncommitted work can be lost that way; it is a reason to commit changes promptly, not a measure of today’s crash rate. Our October 19 and 20, 2026 searches for breaches, lawsuits, regulator actions, ownership changes and vulnerabilities involving these projects, and our November 12 re-reading of the published advisory pages for DbGate, DBX, DBeaver Community and Tabularis, found nothing beyond the items in this article that changed our conclusions; a search that finds nothing is not proof that nothing exists. SQLite forum report
How we researched
This is public-source research. We did not install any app, open a database, connect to a server, run a query, export data or test a read-only setting, and we did not audit network traffic or credential files. No vendor supplied access, payment or input, and we use no affiliate links. We first compared three apps on September 6, 2026, and rechecked every material claim on October 19, 2026: prices, editions, license terms, supported databases and platforms, read-only controls, export formats, credential storage, privacy statements, releases and security fixes. On October 20, 2026 we searched again for newer apps and for widely used free apps the comparison had left out, and added DBX, DbGate and DataGrip. On November 12, 2026 we re-read the current release, price, license, runtime and advisory pages of the apps charted here and ran a new search for newer apps. We read vendor documentation, pricing and legal pages, release notes, GitHub release, tag and advisory records, Electron’s support schedule, the SQLite documentation, the 3.13.1 source code of DB Browser for SQLite and DbGate’s password-encryption source.
We wrote this for someone who needs to look inside an existing SQLite file or an authorized PostgreSQL or MySQL database on their own computer, without buying a license. We fixed five criteria and their weights before scoring: database coverage in the free edition (25%), read-only protection in the free edition (20%), getting data out in the free edition (20%), saved passwords and client data (15%), and cost, terms and continuity (20%). For the last one, a third is the three-year price of the cheapest plan that does the job, in US dollars before tax, scored against the typical price of the apps we priced (a free app scores 5, a typical price 3.5), and two thirds is terms and continuity. An app whose bundled browser runtime no longer receives security fixes loses half a point on saved passwords and client data, or a full point when support ended more than about 180 days earlier; on November 12 DbGate (Electron 44.7.2) and Beekeeper Studio (Electron 44.3.0) were on supported runtimes, DBeaver bundles a supported Java runtime, and DBX and DB Browser for SQLite bundle no browser engine.
Weighted scores out of 5: DBX 4.22, DbGate 4.22, DBeaver Community 4.18, JetBrains DataGrip 4.10, Harlequin 4.04, DB Browser for SQLite 3.56 and Beekeeper Studio 2.90. DBX and DbGate scored level, and we name DBX because DbGate’s equal score depends on a read-only option we could not confirm in its free edition. DBX’s lead over DBeaver Community (0.03) is smaller than one scoring step on our heaviest criterion, so we call it narrow; no app overtakes DBX whether price counts for more or for less. If DbGate’s read-only score or its terms score were half a point lower, DBX would lead DbGate alone; if DBX’s terms score were half a point lower, DbGate would lead.
For the Rising Star we searched on November 12, 2026 for apps first released in the last 24 months, through Hacker News launch posts, GitHub topic pages, project sites and release pages, and re-tested the candidates screened earlier, counting a launch post as dated evidence for every candidate. A Rising Star must be available now on Windows and macOS, pass our safety checks and document a read-only mode, like any app we label. None qualified. DB Pro (launched November 2025) names no operator or company on its home, FAQ or pricing pages, lists no read-only mode and its pages disagree on its free plan and price. Tabularis (January 2026) has a high-severity advisory in its read-only protection for AI agents that still had no patched release on November 12. Openhare (2026) and Tuiql (May 2026) document no read-only mode. Rustable (November 2026) describes itself as early software and lists unfinished production-readiness work. GoNavi, sqlit and rainfrog could not be dated from the pages we read, and NabuSQL says it has been in production for more than two years. Harlequin, a terminal SQL app first released in May 2023, no longer counts as a newer app; it scored 4.04, with a read-only option enforced by the database for SQLite, PostgreSQL and MySQL, but it runs in a terminal, keeps passwords in plain-text config files or environment variables, and exports results without Excel or SQL dumps. TablePro, BerryDB and Base run only on macOS, and WhoDB and Chat2DB were first released before November 2024. This is not a claim that no qualifying newer app exists, only that none we found met every requirement.
Other apps we looked at. DB Browser for SQLite (3.56) is described above. Beekeeper Studio (2.90) lists import and export, backup and restore, and read-only connection mode among its paid features, and its license says the free edition is intended for individuals, non-profits and businesses with fewer than 10 employees and/or under $1 million in revenue; its Indie plan was $9 a month billed yearly or $18 monthly when we read its pricing page on October 19, 2026, and we could not read that page again on November 12. Navicat Premium Lite, free for commercial use, exports only text formats in its free edition and documents no read-only option. TablePlus costs $99 for a one-time license and its free version is limited to two tabs, two windows and two advanced filters; DB Pro costs $99 one-time and NabuSQL about EUR 50. HeidiSQL’s download page offers Windows and Linux builds but no macOS release; SQLiteStudio, now published as Letos, opens only SQLite files; and Microsoft retired Azure Data Studio on February 28, 2026. We did not read the feature pages of TablePlus, pgAdmin or MySQL Workbench, and DbVisualizer’s pages did not load for us, so these apps are not evaluated and could not change our recommendation on this evidence.
| Tool | Public sources | What remains uncertain |
|---|---|---|
| DbGate | Project page, edition comparison, connection and export guides, changelog, release and tag history, password-encryption source, app package, security advisories, Premium announcement. | Whether “Is read only” is in the Community build and enforced for SQLite; exactly which export formats Community offers; whether the app sends usage data. |
| DBX | Project page and README, downloads, first and latest releases, documentation on write safety, data grid, database export, getting started and credential migration, privacy policy, security advisory, maintainer profile, issue counts, one blog review. | Whether its read-only checks catch every kind of write; how complete grid exports are for large results; how it holds up over a longer record; who stands behind it. |
| DBeaver Community | Homepage, downloads, license, release notes, GitHub advisories page, documentation on security, project security, restrictions, data transfer, export, workspace, statistics and AI privacy, privacy policy, GitHub discussion. | Whether the read-only setting blocks writes on every driver; whether usage statistics are on by default; whether encrypted SQLite works in the Community build. |
| JetBrains DataGrip | Pricing page, non-commercial agreement and announcement, help pages read through search copies. | Current release, advisories and runtime; exact help-page wording; the commercial price for individuals against organizations. |
| Other apps | Pricing and download pages of Beekeeper Studio, TablePlus, DB Pro, NabuSQL and Navicat; release and advisory pages of Harlequin, Tabularis and DB Browser for SQLite; project pages of GoNavi, Openhare, Rustable, Tuiql and sqlit; DB Pro home, FAQ and pricing pages. | Beekeeper Studio’s current price; feature pages of TablePlus; first-release dates of the apps we could not date; whether Rustable’s “early software” label is only caution. |
None of this establishes speed, stability, security in use or whether an export is complete. Next substantive review is due December 18, 2026, or sooner after a license, pricing or credential-storage change. Found a changed price or feature? Contact the editors.
Sources and evidence
Sources were checked October 19, 2026 unless another date is given; sources for DBX, DbGate, DataGrip, the newcomer search, the other apps we evaluated and the runtime checks were checked October 20 or November 12, 2026 as stated. Vendor material establishes what each company documents and offers, not how the app behaves on your computer. Community posts are attributed opinions, not representative samples.
- DbGate (checked November 12, 2026): project page; edition comparison; releases, 7.3.6; earliest releases, May 2020; changelog; guides on connections and export and import; password-encryption source; app package, 7.3.6; security advisories; Premium announcement, June 25, 2024.
- DBX (checked November 12, 2026): project page and README; downloads; first release, April 29, 2026; releases; issues; 0.6.21 credential migration note; documentation on what DBX is, production and write safety, data grid, database export, getting started and credential migration; privacy policy, September 27, 2026; advisory GHSA-rqp4-8fxh-22vh (CVE-2026-55642); maintainer profile.
- DBeaver Community (checked November 12, 2026 for the release, license and advisories; October 19 for the rest): homepage; repository; downloads, system requirements and release cycle, 26.2.4; release notes; GitHub advisories; Apache 2.0 license; documentation on secure storage, project security, connection restrictions, data transfer, data export, SQLite, workspace location, statistics collection, AI data privacy and disabling AI; DBeaver Corp privacy policy.
- JetBrains DataGrip: pricing and free licence, November 12, 2026; non-commercial subscription agreement, version 3.0 and DataGrip free for non-commercial use, October 1, 2025 (read October 19); DataGrip help on data source options, including read-only, data extractors and password storage, read through search-engine copies on October 20 because the pages render empty for our fetcher.
- DB Browser for SQLite: homepage; downloads and releases (November 12, 2026); About and release history; blog; license; privacy policy; wiki on command-line options (edited May 24, 2025) and project files (edited May 2, 2026); 3.13.1 release notes, October 16, 2024; 3.13.1 source files MainWindow.ui and sqlitedb.cpp; SQLite’s write-ahead log documentation.
- Other apps we evaluated: Beekeeper Studio pricing and edition matrix (read October 19, 2026; unreadable November 12), paid feature list and releases (November 12, 2026), app package, 6.2.2 and EULA, updated July 2, 2026; Harlequin project page and releases (November 12, 2026) and export (October 20); Tabularis advisories and advisory GHSA-vqmg-c6j7-6c3j (November 12); Navicat Premium Lite; TablePlus pricing and trial limits; DB Pro pricing; NabuSQL; sqlit; GoNavi; Openhare; Rustable and its capabilities notes; Tuiql; Openhare releases; DB Pro home and FAQ; HeidiSQL downloads and Letos (formerly SQLiteStudio) (October 20); Azure Data Studio retirement.
- Newcomer search and runtime support (November 12, 2026): Hacker News searches for database client, SQLite GUI and SQL client; the GitHub database-gui topic; Electron release schedule; DBeaver Java notes.
- Community evidence: DBX review on xiaoz.org, May 27, 2026; DBeaver read-only discussion, March 2023 to September 2026; dbeaver-creds; SQLite forum report, February 2021.
This is a researched comparison, not a product review. Method: evidence standard, editorial picks.