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, 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 and PostgreSQL databases
  • HTTP tunnel connection to MySQL databases

Common features

  • MDI user interface
  • Portable mode to work from a USB Flash drive
  • 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 priviledges

Have some questions or suggestions? Need assistance? Click the feedback tab on the left!

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 and syntax highlighting
  • 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

  • Data browsing and editing in Grid and Form view modes
  • Quick data 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 look-up 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 the Standard version only)

  • Exporting data to most popular office formats with ease. (MS Excel (.xls), OpenXML (.xslx), CSV, Text, HTML and XML)
  • Printing and exporting data to PDF in a few mouse clicks

Compatibility with all popular 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)
  • Japaneese translation (thanks to Hironori Nakagawara)
  • Polish translation (thanks to Witek Szczypka)