Free and open source

Free to use for any purpose, source code available under GPL-3.0 license

Cross database

MySQL, PostgreSQL, MS SQL, Oracle, MongoDB, SQLite and others

Cross platform

Works on Windows, Linux, MacOS and in WEB browser

...

DB Connections

Connect to multiple databases, directly or through SSH tunnel

Data Editor

Browse or edit data in your tables or views, filter by column value.

SQL Editor and SQL Generator

Edit SQL queries with auto-complete suggestions

Export and Import

Export and import from/to CSV, JSON or Excel. Use JavaScript scripting support

NoSQL Database Support

Connect to MongoDB or Redis, browse or filter JSON document data

SQL/MongoDB query builder

Visually design query or combine data from SQL or MongoDB databases

Schema editor and deployer

Edit table schema with keys and indexes. Use database compare tool, deploy your DB models.

Plugins

Use custom plugins for import/export formats

NDJSON viewer

Powerful viewer for NDJSON/JSON lines format

Other

ER diagrams, dark theme, charts, maps. Configurable keyboard shortcuts

Web app configuration, authorization

Web app authorization using OAuth or with LDAP/Active directory

Administration (Premium)

Administration of authentization, users, roles, connections

Online Demo Application

Still not convinced? Try this compelling list of features in our online demo app

Works with Databases

Latest News

Version 5.5.0 - ClickHouse support, improved imports/exports, separate-schema mode for big databases

I am glad to announce new release of DbGate - 5.5.0. There is a huge set of improvements coming with this release, but the main hightlight is long-awaited support of ClickHouse database engine.

Version 5.4.0 - Administration UI, Azure CosmosDB support, MongoDB improvements

I’m excited to announce the new release of DbGate, version 5.4.0! After a long wait, we’re introducing support for a new database engine: Azure CosmosDB. CosmosDB is a cloud-based, document-oriented database from Microsoft, and its support is available exclusively in the Premium edition.

Announcement about Premium version

I am glad to announce a partnership between me (Jan Prochazka, DbGate developer) and Sprinx Systems company. We decided to create new product from DbGate, DbGate Premium, with commercial license and paid support. Also we are commited to support opensource world, so current DbGate will remain as free and opensource product (newly under GPL-3.0 license).

Support us

DbGate is GPL-3.0 licensed open-source project. If it helps your bussiness, please consider supporting our SQL client!

Become a sponsor / backer Recommend DbGate Rate on G2