Beekeeper Studio is a free open source SQL editor for MySQL, Postgres databases. Here this database manager comes with support for remote connections with SSH tunneling. Here it has all aspects of a SQL editor and works with a variety of databases such as MariaDB, Amazon Redshift, Postgres, SQLite, and SQL Server. You can just connect to these databases quickly and then simply start doing SQL transactions. You can create, edit, and modify data tables using SQL and petty quickly. The SQL editor of the software supports syntax highlighting and suggestions.
There are many SQL editors we have covered such as MySQL, PostgreSQL, but here Beekeeper Studio is kind of different. It is open-source software and works with many databases that other tools may not offer. It can be used in professional work and the best part is that it runs on all platforms. The GUI is intuitive and all the controls are there that you usually need to manage a database. Other features of this SQL editor include a built-in dark mode, saving SQL queries, SQL history, tabbed interface, and support for keyboard shortcuts.
Free Open Source SQL Editor for MySQL, Postgres with SSH Tunnel
This is a simple and powerful database manager you can use it right now. Download it from here for your platform and then just start using it. The next thing you have to do is just open it up and create a new database connection. In the database connection, you can opt for the SSH tunneling option. Just specify your SSH credentials there if you want to and then get started.
Now, when it connects to the specified database system, you can see the list of tables on the left side. Just click on any table to view its data. The SQL editor is on the top and you can start writing your SQL queries there. The SQL keywords will be highlighted automatically and you can see auto suggestions in action too.
The next thing you can do in the SQL editor is to save SQL queries. And in the history tab, you can see the previous SQL commands you have executed so far. This is as simple as that.
In this way, you can use this simple and powerful SQL editor I have mentioned here. Just get the binary corresponding to your platform and then simply start using it. Given that the database server is running locally or the remote server that you own. For Linux, it even provides pre-built deb and snap packages.
Closing thoughts
BeeKeeper Studio is a very nice and intuitive database management software you can use. You can use it simply to work with any popular database server and run SQL commands or do whatever you want. The UI is simple, fast, and has only included the main features that you usually need while managing the database. This is in active development so I hope there will be more features in the coming updates. So, if you are a database administrator or developer then gibe this open-source database manager a try and let me know what you think.
