# DbGate — Cross-Platform Open Source Database Client

> An open-source database management tool supporting MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, and more with a modern tabbed interface for queries, data editing, and schema browsing.

## Install

Save in your project root:

# DbGate — Cross-Platform Open Source Database Client

## Quick Use
```bash
# Desktop: download from dbgate.org for Windows, macOS, or Linux
# Docker (web version):
docker run -d -p 3000:3000 --name dbgate dbgate/dbgate
```

## 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

---
Source: https://tokrepo.com/en/workflows/asset-76f1645a
Author: AI Open Source