RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris.
Design your SQL queries with our friendly universal query builder. With no chart builders and independent model diagrams. Visual Query Builder. Universal Query Generator. Pivot/Unpivot Queries. Emulated Grouping Sets. Drill-Down on Relationships. Sort with Nulls. See full list on activedbsoft.com. Started using it 10 years ago, because I am using Linux at home and this is a cross-platform tool, based on Java. We are using it with Oracle, MS SQL Server and probably soon PostgreSQL. Currently we are five people in our department using it regularly.
RazorSQL has been tested on over 40 databases, can connect to databases via eitherJDBC or ODBC,and includes supportfor the following databases:
| Athena | Greenplum | Microsoft Access | SimpleDB |
| Aurora | H2 | MongoDB | Snowflake |
| BigQuery | HBase | MonetDB | solidDB |
| Cassandra | Hive | MS SQL Server | SQLite |
| Couchbase | HSQLDB | MySQL | SQL Anywhere |
| DB2 | Informix | Netezza | SQL Azure |
| DBASE | Ingres | OpenBase | Sybase (ASE) |
| Derby | Interbase | Oracle | Sybase IQ |
| Druid | Int.Sys. Cache | Paradox | Teradata |
| DynamoDB | IRIS | Pervasive | Vertica |
| Filemaker | kdb+ | PostgreSQL | VoltDB |
| Firebird | Keyspaces | Redshift | YellowBrick |
| Frontbase | MariaDB | Salesforce |
| Database Browser | SQL Editor |
| Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures,functions, and more. | Edit SQL scripts. Run SQL queries. Auto column and auto table lookup. Uses the powerfulEditRocket code editor that supportsover 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, Java, XML, and more. |
| Database Tools | Database Query Tool |
| Visual tools to create, alter, describe, execute, and drop database objects such as tables, views,indexes, stored procedures,functions, triggers, and more. | Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more. |
| Import Data | Export Data |
| Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files. | Export data in various formats such as delimited files, XML, HTML, Excel spreadsheets, JSON, and SQL insert statements. |
| SQL Query Builder | Built-in Database |
| Create select, insert, update, and delete SQL statements. Create multi-table joins. | Includes a robust relational database (HSQLDB) that is up and running with no manual configurationout of the box. |
| Edit Table Tool | Data Compare |
| Insert, update, and delete table data in a spreadsheet like format. Find and replace data, previewgenerated SQL, and more. | 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 allowusers 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
- Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers
- A robust programming editor that embeds the powerfulEditRocket 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 runningout 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 Query builder tool
- SQL Query Scheduler tool
- PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers
- An ASP bridge for connectingto 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
Sql Query Tool Microsoft
Free SQL Query Tool for any database
Universal Database Query Tool
If you are looking for a proper tool to work with data and SQL queries with an ad-hoc visual query builder, you've got to a look at FlySpeed SQL Query. This Windows app connects to all modern database servers and works with all popular desktop databases and office file formats (CSV, Excel).
With FlySpeed SQL Query you can browse and edit data in grid form or via the customizable form view, quickly find and filter data, and set up master-detail views, so dealing with data will be a pleasure.
Ad-hoc SQL Query Designer
Product summary
- Latest version:
- 3.8.5.0
History of changes - Price from:
- Free / $39
All purchase options
The visual query designer lets you create new SQL queries by drag'n'drop, and represent off-the-shelf queries visually. It makes SQL query analysis, creation, and modification much simpler. Using FlySpeed SQL Query, you can build parameterized queries, and browse data from linked tables via foreign keys.
Your queries will be saved along with the database connection right beside the database object tree, so you'll be able to continue your work from the point where you stopped last time. The history of SQL query execution is saved automatically; all the settings used during your last session will be restored the next time you start FlySpeed SQL Query.
Free SQL Query Tool for everyday use
The Free version provides a full-featured workplace for working with SQL queries and browsing the result data.
The Full version lets you save time and finish the job in seconds by exporting data to many popular office formats, print, and save reports in PDF.
The Free version of FlySpeed SQL Query is fully functional, except the ability to print and export data.
It can be used for non-commercial purposes for an unlimited time or evaluated for commercial purposes for 30 days.
The special Portable version will allow you to keep your database connection settings and queries at your fingertips. Install FlySpeed SQL Query to your cloud folder, network or portable drive and get access to your data and settings from all of your workstations.
Handy for professionals and a must-have to newbies, FlySpeed Database Query Tools are the best choice to make your work with data and SQL queries more productive than ever before!
Availability
| FlySpeed SQL Query is available in the following versions: | ||
| FlySpeed SQL Query - Standard/Portable/Free version | Download now | Buy now |
Special offer: We are glad to ship the Full version for Free to:
- non-commercial non-political charity organizations,
- educational institutions specifically for teaching students SQL.
For other purposes all non-commercial and educational organizations can get the 50% discount. Please contact us for more details.
Have some questions or suggestions? Need assistance?
Welcome to the feedback forum. Here you can search for answers or submit a private support request.
Screenshots
Get your database job done fast with FlySpeed SQL Query:
- Get connected to most popular database servers natively or using ODBC and OLE DB.
- Browse and edit data from tables and queries in a grid or using the customizable form view.
- Instantly find, sort and filter data, and get totals in a few clicks.
- Design SQL queries visually without knowledge of SQL language.
- Analyze complex SQL queries by representing them visually.
- Instantly see the data returned by any subquery.
- Edit SQL queries via a professional editor with code completion and syntax highlighting.
- Have your queries at your fingertips by saving them along with the database connection.
- Have your SQL query execution history and data browsing settings auto-saved between work sessions.
- Export data to Excel, Text, CSV, HTML and XML files. *
- Print data and save it to PDF format. *
- Work in any Windows OS from 98 to Windows 10. (incl. Server and 64-bit versions)
FlySpeed Database Query Tool was successfully tested with the following databases
- Microsoft SQL Server
- Oracle
- MySQL
- Microsoft Jet 4 Engine: MS Access, MS Excel *
- PostgreSQL
- InterBase,
- Firebird
- IBM DB2 (Universal, AS/400)
- Informix
- Sybase ASA, ASE
- Advantage DB
- Pervasive PSQL
- SQLite
- Teradata
- Netezza
- DBF files (Paradox, FoxPro, dBase).
I have relied upon FlySpeed for over three years.
It makes managing hundreds of DBs super easy. The development of queries is never an issue with GUI, I get it right the first time every time.
I have promoted FlySpeed to all non-technical Project Managers that I know who have a casual need for SQL queries as the only tool they need in their toolbox.
Love the product and keep up the good work.'
Rating: 5 out of 5
Thanks to Mark James for his Silk icon set available at www.famfamfam.com.
Sql Query Toolbox
Need an SQL query builder component to build your own application?Sql Query Tool Open Source
Have a look at Active Query Builder, the leading solution for SQL query building, parsing, analysis and modification. Available in Java, .NET, ActiveX and Delphi (VCL) development environments.
