Free and open source

Free to use for any purpose, source code available under MIT license

Cross database

Supports MySQL, PostgreSQL, MS SQL, 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

Online Demo Application

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

Latest News

Version 5.2.3 - Data duplicator

I am glad to announce new release of DbGate - 5.2.3. It brings lot of smaller improvements, and one maybe a bit cryptic feature - data duplicator. Also, as good software should have only useful features, one big feature was completely removed - data sheet editor.

Works with Databases

Download

Support us

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

Become a sponsor / backer