DbGate
THE SMARTEST SQL & NOSQL database manager·dbgate.io
DbGate is a fast, easy-to-use database client and SQL editor supporting MySQL, PostgreSQL, Oracle, SQL Server, SQLite, MongoDB, Redis and other SQL/NoSQL engines. It runs as a desktop application on Windows, macOS and Linux, and as a web application (self-hosted via Docker or hosted editions), with an open-source Community edition and paid Premium/Team editions adding administration, cloud storage and AI features.
What it's for
Features 20
- Administration interface for users, roles, connections and authentication
- AI-powered Database Chat for natural-language SQL generation and execution
- API endpoint browsing for REST, GraphQL, and oData services
- Batch data updates and macros
- ChatGPT account connection enabling OpenAI Codex models in desktop app
- Cross-platform desktop apps and web app via Docker/Azure/Amazon distribution
- Customizable themes with an AI Theme Assistant
- Data browser with advanced filtering and related-table browsing
- Data compare and database model deployment, usable via CLI for CI/CD
- DbGate Cloud for storing and sharing connections and SQL scripts
- ER diagrams, charts, and GEO data map visualization
- Import and export in SQL, CSV, JSON, XML, NDJSON, Excel, DBF, YAML formats
- Localization into multiple languages
- Master-detail views and foreign key lookups
- Public knowledge base of SQL scripts
- Query console with parameter support and code-completion
- Query designer with joins across SQL tables, MongoDB collections, CosmosDB/DynamoDB
- Query history
- Redis GUI supporting Strings, Hashes, Lists, Sets, Sorted Sets, JSON, and Streams
- Server Chat for AI-assisted querying across multiple databases on a connection
At a glance
Integrations
Resources
Pricing
Azure and AWS editions are priced by compute usage starting at $0.02 per hour rather than a flat monthly fee. DbGate Shopify App pricing starts from $3.90/month. DbGate Central and DbGate Lite are separate hosted products with their own pricing/free access.
Free 30 day trial
1 user
Free 30 day trial
2+ users
Open-source, Unlimited connections, Wide SQL databases support, DocumentDB (MongoDB) support, Redis GUI, Community support, Desktop and web applications, Readonly access to DbGate Cloud shared folders
Max 5 connections in DbGate Cloud; Max 5 SQL files in DbGate Cloud
Free 15 day trial
Free demo available
Free 30 day trial
Unlimited users
Free 30 day trial
Unlimited users
For universities and schools
Validity: one year, free renewal if student/teacher status confirmed
No login required
Runs locally in browser; no installation; data stays in browser