DbGate — Cross-Platform Open Source Database Client

Introduction

DbGate is an open-source database management client that supports a wide range of SQL and NoSQL databases. It runs as a desktop app or a self-hosted web application, providing a tabbed interface for writing queries, browsing schemas, editing data, and importing/exporting across MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, CockroachDB, and others.

What DbGate Does

• Connects to multiple database engines from a single interface
• Provides a SQL editor with auto-completion, syntax highlighting, and execution plans
• Browses table schemas, indexes, views, and stored procedures visually
• Edits data inline with a spreadsheet-like grid supporting filtering and sorting
• Imports and exports data between databases, CSV, JSON, and Excel formats

Architecture Overview

DbGate is built with Svelte for the frontend and Node.js for the backend. The desktop version packages both via Electron. The web/Docker version runs the same Node.js backend as an HTTP server. Database connections go through engine-specific Node.js drivers (mysql2, pg, tedious, mongodb). Query results stream to the UI for handling large result sets efficiently.

Self-Hosting & Configuration

• Run the Docker image for team access via browser
• Connect to databases via hostname, SSH tunnel, or SSL/TLS
• Store connection profiles locally or share them via a configuration file
• Supports read-only connection mode for safe production access
• Authentication for the web version via environment variable configuration

Key Features

• Multi-database: MySQL, PostgreSQL, SQL Server, SQLite, MongoDB, CockroachDB, MariaDB, and more
• Query editor with auto-complete, parameter binding, and saved snippets
• Data compare and sync between two databases or tables
• Diagram view for visualizing table relationships
• Plugin system for extending database support and adding features

Comparison with Similar Tools

• DBeaver — Java-based, heavier; DbGate is lighter and offers a web deployment option
• Adminer — PHP single-file tool; DbGate has richer features and multi-DB support
• pgAdmin — PostgreSQL-only; DbGate covers many database engines
• TablePlus — commercial with paid tiers; DbGate is fully free and open source
• CloudBeaver — DBeaver's web edition; DbGate is simpler to deploy and configure

FAQ

Q: Can I connect to cloud-hosted databases like AWS RDS or Azure SQL? A: Yes, DbGate connects to any reachable database instance. Configure SSL and SSH tunnels for secure cloud access.

Q: Does DbGate support MongoDB? A: Yes, MongoDB is a first-class citizen with collection browsing, document editing, and aggregation pipeline support.

Q: Is there a way to share connections with my team? A: In the Docker web version, connections configured via environment variables or config files are shared across all users.

Q: How does DbGate handle large query results? A: Results are streamed progressively, so even million-row queries display without exhausting browser memory.

Sources

• https://github.com/dbgate/dbgate
• https://dbgate.org/docs