RazorSQL is an SQL editor, database browser, SQL query tool, and database administration tool with support for over 40 databases and built in connection capabilities for Access, Cassandra, DB2, Derby, DynamoDB, Firebird, HSQLDB, H2, Informix, Microsoft SQL Server, MongoDB, MySQL, Oracle, PostgreSQL, Redshift, Salesforce, SQL Anywhere, SQL Azure, SQLite, Sybase, and Teradata. Any other JDBC or ODBC (Windows only) compliant database is also supported. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects; tools for importing and exporting data; a database browser for the viewing of database objects and structures; and a robust programming editor with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and many other programming languages. Also included are a query builder, tools for creating, editing, and executing stored procedures, triggers, and functions, a tool to compare table data and/or query results, and database backup and conversion tools.
Comments (2)
DBMS specific tools are better if you never leave a specific DBMS. SSMS is a better option for SQL Server, Toad does a better job for Oracle. But if you need flexibility to handle multiple OS and DBMS environments, Razor is easily the front-runner.
My only complaint is it only stores queries that have been executed in its history so on a hard reboot, I lose anything I had been writing that hadn't yet been executed. But honestly that's as much a user error as it is a Razor issue.