Category:	Developer Tools
Price:	High
Popularity:	Low
Version String:	10.6.3
Release Date:	2024-10-01
Architecture:	Intel
Minimum OS:	macOS 10.13.0
Vendor Name:	Richardson Software, LLC
Homepage:	razorsql.com

Description:

Query, Edit, Browse, and Manage Databases

RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris.

RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases:

Athena
Aurora
BigQuery
Cassandra
Couchbase
DB2
DBASE
Derby
Druid
DynamoDB
Filemaker
Firebird
Frontbase
Greenplum
H2
HBase
Hive
HSQLDB
Informix
Ingres
Interbase
Int.Sys. Cache
JavaDB
kdb+
Keyspaces
MariaDB
Microsoft Access
MongoDB
MonetDB
MS SQL Server
MySQL
Netezza
OpenBase
Oracle
Paradox
Pervasive
PostgreSQL
Redshift
Salesforce
SimpleDB
Snowflake
solidDB
SQLite
SQL Anywhere
SQL Azure
Sybase (ASE)
Sybase IQ
Teradata
Vertica
VoltDB
YellowBrick


RazorSQL 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, JSON, 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.


Additional Information

RazorSQL is a software application that provides both easy to use visual tools and advanced features to allow users to do database browsing, editing, management, administration, and programming. Browse the database specific features or the complete feature reference.


Features

• A Database Navigator for browsing database objects.

• An SQL Editor for creating SQL queries.

• Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences

• Database Management Tools

• Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers

• A robust programming editor that embeds the powerful EditRocket code editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more.

• Export Tool - Export data in various formats

• Import Tool - Import data from delimited files, Excel files, or fixed width files into tables

• Ships with a built-in relational database engine (HSQLDB) that is up and running out of the box and requires no end-user administration

• A Generate DDL Tool for generating table, view, and index DDL.

• Table / SQL Query Compare tool for comparing tables or queries across multiple connections

• Database Data Search tool for searching single or multiple database table and view data.

• Database Object Search tool for searching for database objects.

• Backup tools such as the Database Backup Tool and Table Backup Tool

• Database conversion tools for many popular databases such as MySQL, Oracle, DB2, PostgreSQL, SQLite, MS SQL Server, and MS Access.

• Auto column and auto table lookup

• SQL Formatter

• SQL Query builder tool

• SQL Query Scheduler tool

• Command Line Interface

• PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers

• An ASP bridge for connecting to MS SQL Server databases remotely via ASP enabled web servers

• SQL GUI Tools for generating SQL for various operations

• Edit, delete, and insert database data with the Database Editor

• Works with all major operating systems including Windows, macOS, Mac OS X, Linux, Solaris, and any other Java enabled OS

• Tested with Apache Cassandra, Apache Derby / JavaDB, Apache Hive, Daffodil DB, DB2, DBASE, Druid, DynamoDB, Firebird, FrontBase, H2, HSQLDB / HyperSQL, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MongoDB, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Redshift, Salesforce, SimpleDB, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, Teradata, and VoltDB