FlySpeed SQL Query

Feature list

Wide range of supported database servers and desktop databases

  • Full support of SQL syntax for Microsoft SQL Server, Oracle, MySQL, MS Access, MS Excel, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, Advantage DB, Pervasive PSQL, SQLite
  • Support of other ANSI SQL-compatible database servers such as Teradata, Netezza and desktop databases (Paradox, FoxPro, dBase DBF)
  • Native connection to Microsoft SQL Server, Oracle, MySQL, PostgreSQL, MS Access, InterBase/Firebird, Advantage DB
  • Connection to any other database via ADO or ODBC driver
  • SSH tunnel connection to MySQL, Oracle, and PostgreSQL databases
  • HTTP tunnel connection to MySQL databases

General features:

  • MDI user interface
  • Portable mode to work from a USB Flash drive or a remote/network folder
  • Read-only mode for individual connections
  • Multi-thread architecture: each query runs in a separate thread
  • Protected mode that denies modification of connection properties without Administrator privileges

Have some questions or suggestions? Need assistance? Welcome to the feedback forum to look up for the answer or submit a private support request.

Simple and convenient database object browser

  • Quick access to all queryable database objects
  • Saving user queries directly in the Database Explorer
  • Incremental search and filtration by database objects and queries
  • Customizable grouping of database objects in the Database Explorer

Easy SQL query building

  • Easy-to-use visual query builder to build even complex queries
  • Independent editing of sub-queries in visual and SQL text modes
  • Auto-updatable sub-query result data preview during the query building process
  • Powerful SQL Text Editor with code completion, syntax highlighting and code folding
  • Customizable SQL query text formatting
  • Displaying detailed information about query: used database objects and fields
  • SQL query execution history is saved between work sessions

Convenient data browsing

  • Browsing and editing data in Grid and Form view modes
  • Master-detail data browsing
  • Quick search, sorting, and filtration (Ctrl+F to search, Ctrl+Q to filter)
  • Browsing and editing the content of BLOB fields in various formats
  • Ability to lookup referenced tables on editing values for fields with foreign keys
  • Totals calculation: summarizing and other aggregate functions
  • Copying selected records to clipboard
  • Data browsing settings are saved between work sessions

Advanced features (available in paid versions only)

  • Exporting data to most popular office formats: MS Excel (.xls, .xslx), CSV, Text, HTML and XML
  • Printing and exporting data to PDF in a few mouse clicks
  • Import data from the clipboard, CSV and Excel files.

Compatibility with all modern database servers and desktop 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).

Ability to localize the tool to any language and culture

FlySpeed SQL Query is currently translated into several languages:

  • Russian translation (thanks to Sergey Kraikov)
  • Japanese translation (thanks to Hironori Nakagawara)
  • Polish translation (thanks to Witek Szczypka)
  • German translation (thanks to André Denis Helsper)
  • Italian translation (thanks to Fabio Santacaterina)
  • French translation (thanks to Fabrice Guerlais)