MySQL, the industry-leading open-source SQL database, is an accessible, easy-to-use relational database management system (RDBMS).As an alternative to Oracle and SQL server, MySQL offers features and capabilities that were once only available to users of expensive proprietary systems. Cross-platform SQL Client Manage, save and share your queries. Completely FREE. Download for Free. Cloud Storage & Saved SQL Queries When you save your TeamSQL queries, they are then available to you no matter where you are. Powerful search functionality means that searching in the cloud is as easy as searching on your computer. SQLPro for Oracle 1.0.6 is a lightweight Oracle database client, allowing quick and simple access to Oracle Servers. Features include: Syntax highlighting (including customizable themes). Tabbed based interface. Support for executing multiple queries at once.

Join the DZone community and get the full member experience.

Join For Free

This is an update to Two very useful open source SQL editors. A year later and I have added one more SQL editor to my first list. I keep this post updated to give context to lists of Open Source SQL front ends such as this one Open Source SQL Clients in Java and SQuirreL SQL Alternatives. I constantly try Open Source SQL front-ends and this post includes the ones I think you should seriously consider.

Working in Business Intelligence (BI), I write and execute SQL statements every day. Actually it is more like every other minute. The SQL tool I use is very important to me. Over the years I have mainly stuck to SQuirreL SQL Client and wandered off every once in a while to try out different tools. One thing is for sure, no one tool will have everything you need. At some point you have to make a choice based on the features most important to you.

Different database vendors will most likely have their own front-end specifically developed for their database. Oracle has SQL Developer and Sybase has Interactive SQL and so on. I would recommend any budding BI practitioner to probably start with the tool supplied by the database vendor. You are not likely to have compatibility and connectivity issues allowing you to get productive much quicker.

If you use more than one database at a time and want to use the same an Open Source SQL front-end I would recommend one of the following:

Don’t be fooled by the dated screen shots on the web pages, these tools look better than that. They are incredibly feature filled tools that with some learning will meet you SQL development needs. Each tool needs a series of blog posts to do justice to the available features. Here are some features technical and not technical that they have in common that have led me to recommend these tools.

Non-Technical Reasons

• Open Source Software, all three are free for commercial use. The source code is available for those with the necessary skills to debug or contribute features.
• All under active development with regular builds being released. Probably about a build (new version) a month. I use the latest testing builds and don’t stick to the stable versions. For the faint at heart stick to the stable release versions.
• Active forums, community members and primary developers, to some degree answer some questions posed on the forums or mailing list.
• Cross platform, all applications run on different platforms ,Windows, Linux and Mac, due to the fact that are written in Java.

Technical Reasons

• JDBC used for database connectivity, which means that 99.9999% of the time you will be able to connect to any database. Most databases provide a JDBC driver.
• Data explorer component from all products are quite customisable. It is possible to customise the schema’s that display, customise the SQL statements generated such as the INSERT, UPDATE or DDL statements created.
• Data import and export wizards for data in various formats including CSV, Microsoft Excel formats XLS and XLSX.
• All the tools keep SQL history. You can customise how many statements are kept in history.

I would urge you to take a serious look at these two tools because you will not get much better generic Open Source SQL tools. I have not included HeidiSQL because it is MySQL specific and runs on Windows only. It is a fantastic tool when you are only using MySQL. TOra is another great tool that I found only works well with Oracle.

Am I missing a great Open Source SQL front end out there? I would like to hear from you.

Published at DZone with permission of Mpumelelo Msimanga , DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Screenshots

Description

SQLPro for MSSQL is a lightweight Microsoft SQL Server database client, allowing quick and simple access to MSSQL Servers, including those hosted via cloud services such as SQL Azure or Amazon RDS.
Features include:
+ Syntax highlighting (including customizable themes).
+ Intellisense.
+ Tabbed based interface.
+ Support for executing multiple queries at once.
+ Quick access to tables, columns and more.
+ Stored procedure execution.
+ NTLMv2 supported (but not required).
SQLPro for MSSQL can be used to connect with the following databases:
+ Microsoft SQL Azure
+ Microsoft SQL Server 2005
+ Microsoft SQL Server 2008
+ Microsoft SQL Server 2008 R2
+ Microsoft SQL Server 2012
+ Microsoft SQL Server 2014
+ Microsoft SQL Server 2016
Thanks to the FreeTDS project (http://www.freetds.org/) for their great library.
This SQL Client does NOT work with MySQL or Postgres. Please ensure that your server is a Microsoft SQL Server (2005 or above).
Note 1: SQL Server Express is supported, however using it makes me sad. Please confirm that the SQL Server Express installation has been configured properly for remote connections over TCP/IP, and that you can connect remotely from another windows pc before requesting support.
Note 2: SQLPro for MSSQL can connect to Microsoft SQL Server 2000 however it is not supported.
Privacy Policy:
https://hankinsoft.com/privacypolicy.html
Terms of Use:
https://hankinsoft.com/termsofuse.html
Price:
SQLPro offers Premium subscriptions in order to interact with database result sets. Premium subscriptions are available as either a Monthly, or a Yearly duration. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. Payment will be charged to your iTunes Account at confirmation of purchase.

What’s New

+ Fixed a case where connections to a MSSQL server could fail.

Love This App

I'm a veteran programmer coming from a unix/linux background. I took a windows-based job, which forced me to work almost entirely with SQL server.
I can do nearly all of my dba work that I need to on a daily basis in this app. There are a few things I can't do in the same way such as creating SQL server agent jobs, but those are outside of my daily work.
This app saves me a ton of time on a daily basis, because a) I don't have to log-into a virtual machine to do my work and b) it performs far faster than MMSQL on Windows in my experience. Especially in dark mode, it is simply far easier on my eyes as well.

Best MS SQL client for MacOS

Love this sql client. Easy to use, authenticates with Windows Authentication, and allows you to be just as productive as your windows machine using co-workers.
Additional updates like dark mode support for the current version of MacOS was a nice touch as well. Worth every penny.

Awesome Love it

It's great. And I believe that the folks who made this app are doing a great job. Keep improving it.

Information

Compatibility

OS X 10.11 or later, 64-bit processor

Microsoft Sql Client For Mac

Supports

Sql Client For Mac

• Family Sharing

  With Family Sharing set up, up to six family members can use this app.