DbGate

Open Source Database Manager for SQL Server, MySQL, PostgreSQL, SQLite, MongoDB, Redis and more

DbGate is modern, fast and easy to use (no)SQL database client

Try it online - demo.dbgate.org - online demo application
Download application for Windows, Linux or Mac from dbgate.org
Run web version as NPM package or as docker image

Features

Table data editing, with SQL change script preview
Edit table schema, indexes, primary and foreign keys
Light and dark theme
Master/detail views
Create and export ER diagrams from existing database
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)
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
Archives - backup your data in JSON files on local filesystem (or on DbGate server, when using web application)
Charts
For detailed info, how to run DbGate in docker container, visit docker hub
Extensible plugin architecture

Pricing:

Open Source
Free

Platforms:

Mac OSX
Linux
Docker
Windows
Web
Node JS

Visit website status page

Verify DbGate

DbGate Reviews and details

Screenshots and images

Landing page //
2023-10-21

Badges

Promote DbGate. You can add any of these badges on your website.

<a href='https://www.saashub.com/dbgate?utm_source=badge&utm_campaign=badge&utm_content=dbgate&badge_variant=color&badge_kind=approved' target='_blank'><img src="https://cdn-b.saashub.com/img/badges/approved-color.png?v=1" alt="DbGate badge" style="max-width: 150px;"/></a>

Show embed code

Social recommendations and mentions

We have tracked the following product recommendations or mentions on various public social media platforms and blogs. They can help you see what people think about DbGate and what they use it for.

Document your database simply and easily
This tool doesn't let you run SQL queries or create tables. SchemaSpy describes and visualizes an already-created database. To work directly with SQL, I recommend https://www.beekeeperstudio.io/ or https://dbgate.org/. - Source: Hacker News / 3 months ago
Is Pg Admin 4 slow and clunky or is it my PC?
Try https://dbeaver.io/ or https://dbgate.org/ (which can work in web mode). Source: 11 months ago
Why is pgAdmin such trash?
You should try https://dbgate.org/. Source: about 1 year ago
Show HN: Slashbase – open-source collaborative IDE for databases in browser
The two open source SQL IDEs I really like are https://www.beekeeperstudio.io/ and https://dbgate.org/ . Both very nice for my somewhat simple querying needs. - Source: Hacker News / over 1 year ago
Database GUIs in JavaScript
DbGate is the most feature rich client from this list. It uses multi-connection and multi-database in one window paradigm, with tabs labeled with asociated database. It has interesting data-navigating features, like master/detail and form views, and excel-like data editing. Also you could use features which you may know from classical clients, like query designer or ER diagram viwer. It is the only client from... - Source: dev.to / over 1 year ago
New to MySQL, tips about client tools
You could also try DbGate. https://dbgate.org . It's free and open source, cross platform, runs as application and also as web client. DbGate author here. Source: over 1 year ago
I created Scrumdog – a program to download Jira Issues to a local database
You might also try https://www.beekeeperstudio.io/ or https://dbgate.org/ for working with databases (SQLite and others). I really like the UIs of each and they're both open source- supported by donations if you find either useful. - Source: Hacker News / almost 2 years ago
Is there a GUI tool to edit table records?
Take a look at DBGate (https://dbgate.org/), it's not perfect but it's pretty good, it works in the browser, and it allows you to edit data in tables. The easiest way to run it is probably as a Docker. Source: about 2 years ago

External sources with reviews and comparisons of DbGate

15 Best MySQL GUI Clients for macOS

Finally, let’s have an overview of DbGate – a free, cross-platform, and cross-database GUI client that covers both SQL-based and NoSQL systems. It allows connecting to multiple databases, browsing and editing table schemas and actual data, writing SQL queries with autocompletion, building queries visually, as well as creating ER diagrams, charts, and maps based on your data. Treat it as a non-ambitious database...

Source: blog.devart.com

Do you know an article comparing DbGate to other products?
Suggest a link to a post with product alternatives.

Suggest an article

Generic DbGate discussion

This is an informative page about DbGate. You can review and discuss the product here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.