HeidiSQL only works on Windows systems with 32/64-bit support, it offers an installer and a portable edition that works directly from the disk. Supports batching insertion for ASCII or binary data.In addition to SQL, CSV, JSON exports, it also exports data to LaTeX, Wiki Mark, and PHP Array.HeidiSQL comes with all the handful of SQL features any developer needs, like SQL Query editor, SSH Tunel connection, variables editor, table editor, trigger editor, and large file support.īeyond its rich features set, which may look similar to other software packages on this list, it has many unique features which are: HeidiSQL is a free SQL manager for SQL databases as MySQL, MariaDB, SQLite, PostgreSQL, and Microsoft SQL database. If you prefer the terminal app, you need to install it through NPM. You can obtain Sqlectron for Windows, Linux, and macOS. Sqlectron supports SSL connection and comes with table views, SQL query manager, full-text search option, and SQL auto-complete feature. It also offers seamless support for Cassandra DB which is a NoSQL database. Sqlectron supports several SQL database engines out-of-the box-like PostgreSQL, Redshift, MySQL, MariaDB, Microsoft SQL Server, and SQLite. It comes in two editions: the GUI mode and the terminal app which you can run from your terminal. Sqlectron is an Electron-based, free, open-source SQL editor for various desktops. It also offers a self-hosted web-based edition which you can install on your local or remote server. Offers table structure viewer, configurable shortcuts, and dark themeĭbGate is available for Windows, Linux, and macOS.Rich database design tools and schema editor.Export data to SQL, CSV, JSON, or Excel files.Comes with SQL query auto-complete suggestion.

Query editor, query designer, and SQL generator.2- DbGateĭbGate is a free, modular, open-source multi-platform SQL manager, which supports traditional SQL databases and NoSQL databases like MongoDB.ĭbGate comes with dozens of features that make managing multiple databases is a piece of cake. Allows exporting data to many formats (SQL, JSON, JSONL, CSV).īeekeeper Studio is available for Windows as an installable package and portable edition, Linux, and macOS.SSL connection support or through SSH tunnels.

It comes packed with developer-friendly features to boost productivity and efficiency.īeekeeper Studio supports several SQL database engines as PostgreSQL, MySQL, SQLite, Redshift, SQL Server, CockroachDB, and MariaDB. 1- Beekepperīeekeeper Studio is one of the most popular SQL managers and database clients among developers. In this article, we offer you a list of open-source, free SQL clients for developers.

Debian mysql gui client