DbGate Database Client

DbGate is a free and open-source database client and administration tool that supports multiple database engines, designed as a fast, lightweight alternative to DBeaver and DataGrip. Created by Jan Prochazka, the project supports SQL and NoSQL databases through a unified interface with both desktop and web modes. Key features include: database support (MySQL, PostgreSQL, SQL Server, Oracle, MongoDB, Redis, SQLite, MariaDB, CockroachDB, Amazon Redshift, and ClickHouse connections via configurable connection profiles), SQL editor (syntax highlighting, autocomplete, query formatting, query history, and multi-tab editing with result grid display), form and table view (data browsing with filterable, sortable grid view and editable form view with foreign key expansion), data editing (insert, update, and delete records with transaction support and batch operations), query designer (visual query builder for SELECT statements with JOIN, WHERE, GROUP BY, and ORDER BY clause construction), database structure (browse tables, views, stored procedures, functions, triggers, and indexes with DDL viewing and editing), ER diagrams (entity-relationship diagram generation for visualizing table relationships and foreign keys), data export and import (CSV, JSON, Excel, SQL INSERT statements, and clipboard export with configurable formats), data comparison (compare and synchronize data between databases with diff visualization), schema comparison (compare database structures and generate synchronization scripts), stored procedure debugger (step-through debugging for SQL Server and PostgreSQL stored procedures), web and desktop (runs as desktop app via Electron or as web application accessible via browser), and cross-platform (Windows, macOS, Linux desktop and Docker web deployment).