DbGate

A SQL and NoSQL database client that lets users browse, edit, query, visualize, and import/export data across engines such as MySQL, PostgreSQL, Oracle, SQL Server, SQLite, MongoDB and Redis. It is for developers, database administrators, data engineers, analysts and IT operations teams in organizations of all sizes as well as individual users. It is delivered as an open-source application that runs as a desktop app on Windows, macOS and Linux and as a web app via browser and Docker, with a cloud option and team administration features.

Key features

• Data browser and editor with filtering
• Master-detail views and foreign key lookups
• Batch updates and macros
• Query console with code completion
• Query history and parameter support
• AI database chat with natural language
• Import and export multiple tables
• Support for SQL, CSV, JSON, XML formats
• Support for Excel, DBF, YAML, NDJSON
• Query designer with cross-database joins
• ER diagrams and chart visualization
• GEO data display on map
• Data compare and synchronization
• Database model compare and deploy
• Redis GUI for all data types
• API endpoints for REST and GraphQL
• Cloud storage for connections and queries
• Team administration for users and roles
• Modern UI with light and dark themes