RazorSQL for Mac

RazorSQL for Mac is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, Mac OS X, macOS, Linux, and Solaris. RazorSQL has been tested on over 30 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases:

Athena, H2, MonetDB, Salesforce, Aurora, HSQLDB ,MS SQL Server, SimpleDB, Cassandra, Informix, MySQL, solidDB, DB2, Ingres, Netezza, SQLite, DBASE, Interbase, OpenBase, SQL Anywhere, Derby, Int.Sys. Cache, Oracle, SQL Azure, DynamoDB, JavaDB, Paradox, Sybase (ASE), Filemaker, MariaDB, Pervasive, Sybase IQ, Firebird, Microsoft Access, PostgreSQL, Teradata, Frontbase, Mimer SQL, Redshift, Vertica, Greenplum, MongoDB.

Features and Highlights

Database Browser
Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures, functions, and more.    

SQL Editor
Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Uses the powerful EditRocket code editor that supports over 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, Java, XML, and more.

Database Tools
Visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more.    

Database Query Tool
Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more.

Import Data
Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files.    

Export Data
Export data in various formats such as delimited files, XML, HTML, Excel spreadsheets, and SQL insert statements.

SQL Query Builder
Create select, insert, update, and delete SQL statements. Create multi-table joins.    

Built-in Database
Includes a robust relational database (HSQLDB) that is up and running with no manual configuration out of the box.

Edit Table Tool
Insert, update, and delete table data in a spreadsheet like format. Find and replace data, preview generated SQL, and more.

Data Compare
Compare table data across databases, or compare the results of queries.

Note: 30 days trial version.

Also Available: Download RazorSQL for Windows