DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and MariaDB.

Its features include:

Table data editing, with SQL change script preview
Edit table schema, indexes, primary and foreign keys
Compare and synchronize database structure
ER diagram
Light and dark theme
Master/detail views, foreign key lookups
Query designer
Form view for comfortable work with tables with many columns
JSON view on MongoDB collections
Explore tables, views, procedures, functions, MongoDB collections
SQL editor
- execute SQL script
- SQL code formatter
- SQL code completion
- Add SQL LEFT/INNER/RIGHT join utility
Mongo JavaScript editor, execute Mongo script (with NodeJs syntax)
Redis tree view, generate script from keys, run Redis script
Runs as application for Windows, Linux and Mac. Or in Docker container on server and in web Browser on client.
Import, export from/to CSV, Excel, JSON, XML
Free table editor - quick table data editing (cleanup data after import/before export, prototype tables etc.)
Archives - backup your data in JSON files on local filesystem (or on DbGate server, when using web application)
Charts, export chart to HTML page
For detailed info, how to run DbGate in docker container, visit docker hub
Extensible plugin architecture
Perspectives - nested table view over complex relational data

Suggested keywords:

Beekeeper Studio - Open Source SQL Editor and Database Manager

Newsletter

Related Projects