If you are a student, and can prove it, you can get all of JetBrains tools on a student license.
How to connect to PostgreSQL using SQLEctron. We will use WHERE sql command to link different tables. Find length of a string/column and position of a character in a column. If you use PHPStorm, that has DB tools built in, no need to leave the program, it gets the job done and do what you need to in another system. We will look into sales table and link it to the customer table by the customer id field and in same way we will link product table by product ID field. Do you just want to see your tables and data as you work? Run some simple queries? Mission Critical? They will help us steer you in the right direction. However you need to tell us what you are looking for. I have tried MySQL Workbench, wasn't to my liking, just felt lost. +1 for TablePlus, it just works, connects to a shit load of DB's, gets constant updates, and isnt as bloaty as DataGrip. If this is for work/business/production/mission critical work.
In this article, we offer you a list of open-source, free SQL clients for developers.Im going to get this one out of the way. 1- Beekepperīeekeeper Studio is one of the most popular SQL managers and database clients among developers. 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.
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.Query editor, query designer, and SQL generator.Ģ- 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.Comes with SQL query auto-complete suggestion.Export data to SQL, CSV, JSON, or Excel files.
It also offers a self-hosted web-based edition which you can install on your local or remote server. Sqlectron is an Electron-based, free, open-source SQL editor for various desktops. It comes in two editions: the GUI mode and the terminal app which you can run from your terminal. Sqlectron supports several SQL database engines out-of-the box-like PostgreSQL, Redshift, MySQL, MariaDB, Microsoft SQL Server, and SQLite. It also offers seamless support for Cassandra DB which is a NoSQL database. Sqlectron supports SSL connection and comes with table views, SQL query manager, full-text search option, and SQL auto-complete feature. You can obtain Sqlectron for Windows, Linux, and macOS. If you prefer the terminal app, you need to install it through NPM. HeidiSQL is a free SQL manager for SQL databases as MySQL, MariaDB, SQLite, PostgreSQL, and Microsoft SQL database.
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:
In addition to SQL, CSV, JSON exports, it also exports data to LaTeX, Wiki Mark, and PHP Array.Supports batching insertion for ASCII or binary data.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. Unlike other projects here, OmniDB focuses on providing a collaborative database management platform for teams.Ĭonsider it a web-based database client and admin station tool on steroids for collaborative administration.Ĭurrently, OmniDB supports PostgreSQL, MySQL, Oracle, and MariaDB. OmniDB features a customizable, user-friendly interface, a PSQL console, SQL Query manager, a monitoring dashboard to oversee all operations, connections, activities, and logs, and a global SQL snippets panel for the team.