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.
- Connection Wizard: Added a tree view for existing connection profiles for faster selection
- Connection Wizard: Added the ability to categorize connections inside sub-folders
- Added a columnEncryptionSetting configurable property for the MS SQL Server JDBC driver
- DynamoDB: Added the ability to scan for values inside of Map columns. See https://razorsql.com/docs/dynamodb_sql_support.html for syntax details
- Connection Process: Added the ability to associate a file to a connection profile. Whenever the connection profile is connected, the file will load in the SQL editor.
- Salesforce: Updated API version to 45
- Execute procedure tool – if procedure returns a result set, results are now displayed in the query results tab of the main window
- Oracle: If DBMS Output is turned on, and query / statement does not return results but does return output, output is displayed in the query results section
- Added ability to call SQL Server / Sybase functions that return a table via the Call Procedure Tool
- Import Tool: Create Table from Import: If data values are decimal, will pre-populate decimal type with estimated precision and scale set on the create table window
- MySQL and MariaDB: Column aliases not always appearing as column names in query results for queries that use aliases for the column names
- Initial screen size may be larger than current screen for multiple monitor machines having monitors with different resolutions
Compatibility: OS X 10.7 or later, 64-bit processor