...

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+noSQL query builder (Premium)

Visually design query or combine data from SQL or MongoDB databases

Database compare (Premium)

Compare SQL database structure - tables, columns, views. Deploy changes

Schema editor and deployer

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

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

AI Assistant (Premium)

Context-aware AI assistant will help you to build, complete or change your SQL queries

Deploy on AWS

Single-click deploy on Amazon EC2 cluster

Online Demo Application

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

Works with Databases

Latest News

Version 6.2.0 - AI Assistant, Cassandra support

I am happy to announce new release of DbGate - 6.2.0.

This release brings two important highlights:

Long awaited Apache Cassandra support (for all editions)
AI Assistant for query console (for Premium only)

5 Best Free PostgreSQL Database Clients in 2025

Managing PostgreSQL databases efficiently requires a reliable GUI client. In this article, we’ll compare five popular free and open-source PostgreSQL database management tools: DbGate, pgAdmin, DBeaver, HeidiSQL, and Beekeeper Studio. Some of these tools offer also paid editions, but we compare only features, which are available for free and with source codes.

Amazon - DbGate available on AWS

Today we accomplished important achievement - DbGate could be installed on Amazon web services.

Previously, to run the web version, you had to deploy Docker containers or install NPM packages on the server with DbGate, which required some configuration.

If you are familiar with Amazon web services, installing web version of DbGate is now task consisting of a few clicks. You have then available administration of users, connections and roles, and you could grant permissions for connections to some users.

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.