RazorSQL allows you to query, update, navigate, and manage all major databases from one database tool. With RazorSQL, a SQL query tool, SQL editor, and database navigator, you can run SQL scripts, visually edit, create, alter, and view tables, import and export data, build queries with a query builder tool, and navigate databases with the database navigator. It even comes with a built-in relational database engine that requires no configuration.
The SQL programming editor has syntax highlighting for SQL, PL/SQL, TransactSQL, SQL PL, and Java, automatic function/method lookup, automatic column lookup, key ahead, built-in and customizable templates, multi-tabular display of query results, query logging, and many other features including a tool to call stored procedures and a tool to compare table and/or query data.
RazorSQL has been tested with virtually all popular databases, and includes built in driver support for Cassandra, DB2, Derby, DynamoDB, Firebird, FrontBase, Hive, HSQLDB, Informix, MongoDB, MySQL, OpenBase, Oracle, PostgreSQL, Redshift, Salesforce, SimpleDB, SQLite, SQL Azure, SQL Anywhere, SQL Server, Sybase, Teradata, and others.
- Import Tool: Delimited Files: Added support for the following date formats for Date columns in addition to yyyy-MM-dd: MM/dd/yyyy (06/22/2020) M/d/yyyy (6/2/2020) MM/dd/yy (06/02/20) d-MMM-yy (2-Jun-20)
- Import Tool: Added support for generating insert statements that have multiple rows of values per one statement to reduce overhead for MySQL, PostgreSQL, SQL Server, Derby, DB2, and Athena
- Import Tool: Blank rows in spreadsheets and delimited files are now skipped
- Import Tool: XLSX Files: Importing cells with formulas is now supported
- Import Tool: Enhanced the process for guessing column types and sizes when creating a table during the import process
- Import Tool: If first row of file being imported looks to be column names, the start row of the file will be set to row 2 instead of row 1
- Athena Export Tool: Added support for generating SQL statements in multiple rows per one insert statement syntax
- Oracle: For new installs, default to showing all schemas instead of non-empty schemas. Empty schemas can be hidden by the Edit - Preferences - Database Browser - Oracle: Hide Empty Schemas in Database Browser checkbox
- Oracle Editor: Added more line number detail to Oracle query errors
OS X 10.7 or later, 64-bit processor