DbGate - (no)SQL database client
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.
DbGate is licensed under GPL-3.0 license and is free to use for any purpose.
Supported databases
- MySQL
- MariaDB
- PostgreSQL
- CockroachDB
- Amazon Redshift (Premium)
- SQL Server
- Oracle
- SQLite
- libSQL/Turso (Premium)
- Cloudflare D1 (Premium)
- DuckDB
- Firebird
- ClickHouse
- Apache Cassandra
- MongoDB
- MongoDB 4 - Legacy (Premium)
- Redis
- Azure Cosmos DB (Premium)
- Amazon DynamoDB (Premium)
- Firestore (Premium)
Supported APIs (Premium)
- GraphQL
- OData
- OpenAPI (REST)
Features
- Browse table data with many filtering options, Excel-like filters, multi-value filters
- 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, next themes available from DbGate Cloud
- Huge support for work with related data - master/detail views, foreign key lookups, expanding columns from related tables in flat data view
- Query designer - visual SQL query builder without writing SQL code. Complex conditions like WHERE NOT EXISTS.
- Query perspectives – innovative nested table view over complex relational data, something like query designer on MongoDB databases
- 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, NDJSON, XML, DBF
- Archives - backup your data in NDJSON files on local filesystem (or on DbGate server, when using web application)
- NDJSON data viewer and editor - browse NDJSON data, edit data and structure directly on NDJSON files. Works also for big NDSON files
- Charts, export chart to HTML page
- AI powered database chat
- Show GEO data on map, export map to HTML page
- For detailed info, how to run DbGate in docker container, visit docker hub
- Extensible plugin architecture
One-Click Deploy
How to contribute
Any contributions are welcome. If you want to contribute without coding, consider following:
- Tell your friends about DbGate or share on social networks - when more people will use DbGate, it will grow to be better
- Purchase a DbGate Premium license
- Create issue, if you find problem in app, or you have idea to new feature. If issue already exists, you could leave comment on it, to prioritise most wanted issues
- Create some tutorial video on youtube
- Become a backer on GitHub sponsors or Open collective
- Add a SQL script to Public Knowledge Base
- Where a small coding is acceptable for you, you could create plugin
- Create a new custom theme and share it on DbGate Cloud
Thank you!
Why is DbGate different
There are many database managers now, so why DbGate?
- Works everywhere - Windows, Linux, Mac, Web browser (+mobile web is planned), without compromises in features
- Based on standalone NPM packages, scripts can be run without DbGate (example - CSV export )
- Many data browsing functions based using foreign keys - master/detail, expand columns, expandable form view
Design goals
- Application simplicity - DbGate takes the best and only the best from old DbGate, DatAdmin, DbMouse and SQL Database Studio
- Minimal dependencies
- Frontend - Svelte
- Backend - NodeJs, ExpressJs, database connection drivers
- JavaScript + TypeScript
- App - electron
- Platform independent - runs as web application in single docker container on server, or as application using Electron platform on Linux, Windows and Mac
This is the beginning of the README. Read the rest at the original. Read the full README ↗
