DbGate

The Smartest SQL+noSQL Database Client

Download for Linux Download for Windows Download for MacOS Download Video preview Try it online

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

Data Grid screenshot
Query console screenshot
Diagram screenshot
Redis connection screenshot
Export dialog screenshot
Dark mode screenshot
Query designer screenshot
MongoDB save dialog screenshot
Database compare screenshot
...

DB Connections

DB Connections Connect to multiple databases, directly or through SSH tunnel

Data Editor

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

SQL Editor and SQL Generator

SQL Editor and SQL Generator Edit SQL queries with auto-complete suggestions

Export and Import

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

NoSQL Database Support

NoSQL Database Support Connect to MongoDB or Redis, browse or filter JSON document data

SQL+noSQL query builder (Premium)

SQL+noSQL query builder (Premium) Visually design query or combine data from SQL or MongoDB databases

Database compare (Premium)

Database compare (Premium) Compare SQL database structure - tables, columns, views. Deploy changes

Schema editor and deployer

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

NDJSON viewer

NDJSON viewer Powerful viewer for NDJSON/JSON lines format

Other

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

Web app configuration, authorization

Web app configuration, authorization Web app authorization using OAuth or with LDAP/Active directory

Administration (Premium)

Administration (Premium) Administration of authentization, users, roles, connections

Online Demo Application

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

Works with Databases

Cross-platform MySQL Client
MySQL
Cross-platform MS SQL Database Manager
SQL Server
Cross-platform Oracle Database Manager
Oracle
Cross-platform PostgreSQL Client
PostgreSQL
Cross-platform SQLite Client
SQLite
Online MongoDB Client and database Editor
MongoDB
Cross-platform MariaDB Client
MariaDB
Cross-platform Amazon Redshift Client
Redshift
Cross-platform CockroachDB Client
CockroachDB
Cross-platform Redis Client
Redis
Cross-platform CosmosDB client
CosmosDB
Cross-platform ClickHouse client
ClickHouse

Latest News

Version 6.1.0 - fulltext search in model

I am glad to announce new DbGate release, 6.1. It comes relatively shortly after 6.0, but it brings some new key features, lot of fixes and improvements of concepts introduced in 6.0.

Published: Dec 18, 2024

Major release 6.0.0

We are happy to announce new major release, 6.0. The new version brings significant usability changes and more intuitive workflows.

Published: Dec 5, 2024

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.

Published: Sep 25, 2024

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

You could also purchase PREMIUM edition.