DbGate

DbGate is an open-source desktop app that provides a unified interface for managing multiple databases. It supports a wide range of SQL and NoSQL systems, including MySQL, PostgreSQL, MongoDB, Redis, and SQLite. The software is designed for users who need to work with several different database types simultaneously within a single tool, reducing the need to switch between multiple specialized clients.

The application is cross-platform and available for Windows, Linux, and macOS via Electron. It can also be deployed as a web application using a Docker container or an NPM package, allowing it to run in a web browser. This flexibility makes it suitable for both local development on a workstation and centralized server-side administration for teams.

Key features

• Visual SQL query builder for creating complex queries without writing code
• Schema comparison and synchronization tools to align database structures
• Data browsing with Excel-like filtering and multi-value filter options
• ER diagram generation for visualizing database relationships
• SQL editor with code completion, formatting, and join utilities
• Import and export support for CSV, Excel, JSON, NDJSON, and XML
• Specialized views for MongoDB JSON collections and Redis tree structures
• Data visualization through charts and GEO data mapping

Built with Svelte on the frontend and Node.js on the backend, DbGate utilizes an extensible plugin architecture that allows users to add custom functionality. It focuses heavily on handling related data through master/detail views, foreign key lookups, and the ability to expand columns from related tables in a flat data view. This approach simplifies navigation in complex relational schemas and makes it easier to manage tables with a high number of columns via a dedicated form view.

The tool is intended for database administrators, data engineers, and developers who require a versatile client that functions identically across desktop and web environments. It also includes a Node.js scripting interface for automation and an AI-powered database chat for query assistance.

DbGate is a platform-independent manager that balances simplicity with advanced data engineering capabilities.