DbGate

lastmod 2022-11-25created 2022-11-254 edits

DbGate - open-source cross-platform (no)SQL DB client

Features

• Svelte + Electron
• Runs on Windows/Linux/Mac and in web browsers
• Connects to MySQL/PostgreSQL/SQL Server/MongoDB
  • Multiple simultaneous connections, SSH tunnel support
• Grid-style data browser & editor
  • FK master/detail view, FK lookup
  • One-click Group By
  • Batch editing (macros)
• Query editor & SQL generator
  • Syntax highlighting and code autocompletion
  • Join wizard
  • Automatic SQL generation from the current DB (Create/Drop/Insert/Truncate..)
• CSV/Excel/JSON Export & Import
  • Formats can be extended with plugins
  • Scripting support with JavaScript
  • Supports copying tables between DBs
• Native MongoDB driver support
  • Collection data, JSON view..
  • Supports queries using the MongoDB API
• NPM-style plugin architecture

See also

• Database
• Slashbase - open-source web IDE for collaborative DB development
• Beekeeper Studio - open-source SQL editor and DB manager
• DbGate - open-source cross-platform (no)SQL DB client
• DBeaver - Eclipse-based DB management tool

Favorite site

• DbGate | Open Source (no)SQL Database Client