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.

PRACTICAL PICKSPreferredPickOur Preferred PickA small free app for files and servers$0

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 Pick
Newcomer assessment

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.

Free desktop apps for browsing SQLite, PostgreSQL and MySQL databases
FeatureDBXDbGateDBeaver CommunityJetBrains DataGrip
Best fitPreferred 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 matterSQLite files and servers in one free app from a company, if you will not save passwords that matterA full database IDE, free only for personal and other non-commercial use
Databases in the free editionSQLite, PostgreSQL, MySQL, MariaDB, SQL Server, DuckDB, Redis, MongoDB and many more; no paid editionSQLite, PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, MongoDB, Redis, DuckDB and others; libSQL, Redshift and some cloud sources are PremiumSQLite, PostgreSQL, MySQL, MariaDB and many other relational engines; NoSQL and cloud drivers are PROThe 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 freeApache 2.0, any useGPL-3.0; "free to use for any purpose", per its project pageApache 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 supportA "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 editionResults or selections to CSV, TSV, JSON, Markdown, XLSX or SQL statements; whole database or schema to an SQL fileTables, filtered data or query results to CSV, JSON, Excel, XML, SQL and more; multi-table export includedResults, tables or grid to CSV, JSON, SQL, HTML, XML, Markdown, TXT and more; XLSX and Parquet are PROSQL INSERT or UPDATE statements, CSV, TSV, Excel, Markdown, HTML and JSON, one file per table
Saved passwordsIn the system keychain since 0.6.21 (September 2026); the portable Windows build keeps its key beside the dataEncrypted with a per-install key that is stored, encrypted with a key from the public source, in the same folder; can skip savingStored under a key DBeaver says is public in its source; stronger storage is paidSystem 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, 20260.6.69, November 10, 2026; 434 releases since the first on April 29, 20267.3.6, November 12, 2026; first releases May 202026.2.4, November 2, 2026; minor releases about every two weeksNot 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
Database job and edition
FeatureDBXDbGateDBeaver CommunityJetBrains DataGrip
Best fitPreferred 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 matterSQLite files and servers in one free app from a company, if you will not save passwords that matterA full database IDE, free only for personal and other non-commercial use
Databases in the free editionSQLite, PostgreSQL, MySQL, MariaDB, SQL Server, DuckDB, Redis, MongoDB and many more; no paid editionSQLite, PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, MongoDB, Redis, DuckDB and others; libSQL, Redshift and some cloud sources are PremiumSQLite, PostgreSQL, MySQL, MariaDB and many other relational engines; NoSQL and cloud drivers are PROThe full IDE, identical to the paid product per JetBrains, with SQLite, PostgreSQL and MySQL support
Desktop systemsWindows 10 and 11 (x64), macOS (Apple silicon and Intel), Linux; a Docker web version tooWindows (x64, ARM64), macOS (universal), Linux deb, Snap and AppImage; a Docker web version tooWindows 10+, macOS 11+, Linux; x86 and ARM builds with Java bundledWindows, 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 freeApache 2.0, any useGPL-3.0; "free to use for any purpose", per its project pageApache 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 queryData grid with database-side WHERE and ORDER BY, filters and an SQL editor with completion; edits shown as SQL before savingData browser with filters and sorting and an SQL editor; editing query results is PremiumData editor and SQL editor with tasks and maintenance toolsData 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 appNot documented in the pages we readCipher options documented on its SQLite page without a paid markerNot checked
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
Inspecting and getting data out
FeatureDBXDbGateDBeaver CommunityJetBrains 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 supportA "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 editionResults or selections to CSV, TSV, JSON, Markdown, XLSX or SQL statements; whole database or schema to an SQL fileTables, filtered data or query results to CSV, JSON, Excel, XML, SQL and more; multi-table export includedResults, tables or grid to CSV, JSON, SQL, HTML, XML, Markdown, TXT and more; XLSX and Parquet are PROSQL INSERT or UPDATE statements, CSV, TSV, Excel, Markdown, HTML and JSON, one file per table
Export caveatGrid exports cover the loaded result or selection, and an export row limit applies; check the row countFilters apply to exported table data; a table backup is SQL, not a server backupRows and DDL scripts, not users, permissions or a server backupRows and scripts, not users, permissions or a server backup
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
Local state, privacy and continuity
FeatureDBXDbGateDBeaver CommunityJetBrains DataGrip
Saved passwordsIn the system keychain since 0.6.21 (September 2026); the portable Windows build keeps its key beside the dataEncrypted with a per-install key that is stored, encrypted with a key from the public source, in the same folder; can skip savingStored under a key DBeaver says is public in its source; stronger storage is paidSystem 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 datadbx.db: connections, saved SQL, history and settings; secrets in the keychainData folder: connections, the encryption key file, SQL files and settingsDBeaverData workspace: connections, credentials file, scripts and diagramsIDE settings and project files; we did not inspect them
Network use it documentsNo DBX account; contacts only your databases, chosen AI provider, sync service, plugin sources and updatesBuilt-in updater; optional DbGate Cloud storage; usage data not documented in the pages we readUsage statistics with an opt-out; AI sends table and column names after you confirmAnonymous usage statistics; detailed code-related data collected by default and can be switched off; JetBrains Account required
Latest release, checked November 12, 20260.6.69, November 10, 2026; 434 releases since the first on April 29, 20267.3.6, November 12, 2026; first releases May 202026.2.4, November 2, 2026; minor releases about every two weeksNot checked in this review
Who stands behind itOne lead developer known by the handle t8y2, with 411 contributors; no company or full name published; donations and sponsorsIts author, Jan Procházka, with Sprinx Systems, which sells PremiumDBeaver Corp, which sells the PRO editionsJetBrains s.r.o. of Prague
Recent security recordOne critical advisory (CVE-2026-55642) in the Docker web service, fixed in 0.5.51; the desktop app was not affectedSeveral critical and high-severity 2026 advisories, including code execution in the desktop app; all fixed, none open on November 122026 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 listedNot checked
App runtime, checked November 12, 2026Tauri with the system web view; no bundled ChromiumElectron 44.7.2, supported until March 2027Bundled OpenJDK 25, still supported; no bundled browser engineJetBrains Runtime; support dates not public
Leaving laterData stays in your database; remove dbx.db and the keychain entries separatelyData stays in your database; remove the data folder separatelyData stays in your database; remove the workspace folder separatelyData stays in your database; IDE settings stay on your computer
Sources for local state, privacy and continuity

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

$0Apache 2.0 · no paid edition

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

$0GPL-3.0 · Premium editions paid

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

$0Apache 2.0 · PRO editions paid

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

$0Non-commercial licence · commercial $10.90 a month

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.

Suggest a product

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.

ToolPublic sourcesWhat remains uncertain
DbGateProject 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.
DBXProject 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 CommunityHomepage, 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 DataGripPricing 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 appsPricing 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.

This is a researched comparison, not a product review. Method: evidence standard, editorial picks.