Best Mssql Client For Mac -mysql

  1. Free Sql For Mac

#1 – MySQL Workbench

HeidiSQL is a powerful and easy client for MySQL, MariaDB, Microsoft SQL Server and PostgreSQL. Open source and entirely free to use.

  1. SQLPro for MSSQL is the Premier application for editing and viewing SQL Server databases on mac os x.
  2. DBHawk – SQL client for Mac OS X. The ideal solution, in this case, is to have a single Mac SQL client that can connect to different database platforms.
  3. And the best part is, you’ll have SQL Server running locally without needing any virtualization software. Prior to SQL Server 2017, if you wanted to run SQL Server on your Mac, you first had to create a virtual machine (using VirtualBox, Parallels Desktop, VMware Fusion, or Bootcamp), then install Windows onto that VM, then finally SQL Server.
  4. A great OSX client for MSSQL is SQL Client (which is also available on the Mac App Store). Edited by hanky6 Sunday, August 24, 2014 12:34 PM Monday, May 12, 2014 5:05 PM.

Pros:

  • Intuitive and very easy to use user interface.
  • Free to download, licensed under GPL.
  • Cross platform – versions available for Windows, Linux and Mac OS.
  • Visual schema and query builder.
  • This is the only SQL client which is supported and developed by MySQL, so you can be sure that it will contain all recent features to match the updates for MySQL’s server.
  • Allows optimizing SQL queries directly from the IDE, using a plugin developed by EverSQL.

Cons:

  • The software is sometimes buggy some users report software crashes.
  • Sometimes large queries can’t be stopped and have to be forcefully killed. In some cases, the entire application has to be killed.

Price: Free.

#2 – HeidiSQL

Pros:

Best Mssql Client For Mac -mysql
  • Easy to use and very intuitive user interface.
  • Free to use – Licensed under GNU GPL.
  • Portable version is available for download, so you can use it without administrative privileges, nor requiring installation.
  • Full database user management and privileges management options.
  • Automate connections via command line utility.
  • Ability to connect to MySQL database via an SSH tunnel, in case you don’t have the default port open for remote connections.
  • Great syntax checks and auto completion features.
  • Can work with Linux distributions, but will require the Wine platform

Cons:

  • Some users are reporting sudden crashes / bugs, but nothing that significantly interrupts the daily usage.
  • Requires Wine for Linux.
  • No official support for Mac OS.

Price: Free

Free Sql For Mac

#3 – dbForge Studio for MySQL

Pros:

  • Comfortable user interface for both beginner and advanced users.
  • Built in query profiler that allows to profile the query and compare it with other queries.
  • Debug your query, step by step, using the known watch, call stack and breakpoint concepts.
  • GUI query builder and database builder. Drag and drop to build your own custom queries and database schema.
  • Good syntax completion and checker.
  • Full database user management and privileges management options.
  • Backup wizard that allows to schedule database backups.
  • Allows storing code snippets.
  • Good support for running large SQL files (without opening them).

Cons:

  • The full version has a high price tag on it, so not everyone will be able to afford it.
  • Very basic JSON viewer (for example, no ways to collapse or expand blocks of data).
  • Users report that in some cases the auto complete feature stops working, whenever many connections are opened.

Price: up to $249.95.

#4 – Navicat for MySQL

Pros:

  • Intuitive, easy to use UI.
  • Ability to connect to MySQL database via an SSH tunnel, in case you don’t have the default port open for remote connections.
  • Schedule database jobs – backup, restore, run reports and more.
  • Import data from: ODBC, Excel, Access, DBF, TXT, CSV, XML, JSON.
  • Export data to: Excel, Access, DBF, TXT, CSV, XML, JSON.
  • Visual schema and query builders.
  • Cross platform – Windows, Linux and Mac OS versions are available.
  • Syntax completion and checker.
  • The premium version allows collaboration with team mates – share queries, connections and more.

Cons:

  • High price point for the professional version.
  • Uses Wine to be executed on Linux, which slows down the IDE.
  • Some of the use cases require opening a new tab / window, which users report as a cumbersome process.

Price: up to $259.

#5 – SQLyog

Pros:

  • Very innovative and elegant user interface, best one we’ve seen.
  • Visually design the schema tables, constraints and queries.
  • Schedule tasks like backup, restore, email notifications and more.
  • Personalize the look and feel with themes.
  • The user interface is very customize-able.
  • Fast and stable.
  • Good data and schema sync tools.
  • Ability to connect to MySQL database via an SSH tunnel, in case you don’t have the default port open for remote connections.
  • The Ultimate version comes with a good data comparison tool.

Cons:

  • High price point for the professional version.
  • Some users report occasional software crashes.
  • Lack of support for databases other than MySQL.
  • No native support for Linux or Mac.
  • No drag and drop support between multiple tabs.

Price: Up to $299.

Mysql client for mac os x
  • Data viewer:
    • Virtual primary/foreign keys editors were enhanced
    • Problem with filters on data refresh was fixed
    • Added confirmation dialog before opened result tabs closing
    • Problem with missing updated row count (in script mode) was fixed
    • References panel now remembers last FK/reference selection
    • Value view panel now supports Find/Replace
    • Float values rendering was fixed (numbers rounding is disabled by default)
  • Data transfer:
    • Save of previous target container selections was added
    • Export of tables/queries with complex data types (structs, objects) was improved
  • Connection management:
    • Connection permissions config was added (restrictions of data/metadata changes for a particular connection or connection type)
    • Problem with bootstrap queries and auto-commit state save/load was fixed
    • Multi-project support was improved (use selected project for new connections)
    • Support of empty database passwords was added
    • Copy/paste and drag-n-drop connections between different projects was fixed
  • Database navigator:
    • Default double-click behavior configuration was added (view properties/data/erd)
    • Object edit dialogs are properly sized now (problem with too small dialog window was fixed)
    • Connection type coloring in the main toolbar is back
    • DBeaver toolbars visibility was fixed (for Eclipse plugin version)
  • New DBeaver version automatic downloading (optional) was added
  • MySQL:
    • Datetime columns edit was fixed. Problems with timezone were fixed.
    • Legacy MySQL <4 driver was added (again)
  • PostgreSQL:
    • Automatic transaction error recovery was added (famous 'current transaction is aborted' error)
    • Partition management was added (partition create/drop)
    • Support of VACUUM tool for older PG version was fixed
    • Enum items order was fixed (in metadata editor)
    • Legacy PostgreSQL <= 8 driver was added
  • SQL Server: index DDL was improved (now it contains all index properties)
  • Redshift: table DDL generation was fixed ('diststyle AUTO' and other improvements)
  • Hive: struct/array data types support was added
  • Presto: array data types support was fixed
  • DB2 i: routine list reading was fixed
  • We have migrated to the Eclipse 2019-06 platform (fixes many minor UI bugs on Linux)
  • Many other minor bugs were fixed