English 
Français 
العربية 
FlySpeed SQL Query is a versatile and powerful SQL query tool designed for data professionals and enthusiasts alike. Whether you’re working with vast databases or simple desktop files, this Windows-based application provides an intuitive environment for managing and querying data across a broad range of database servers. With features like an ad-hoc SQL Query Designer and support for popular database dialects, FlySpeed SQL Query is an essential tool for anyone involved in data analysis or SQL development.
Key Features of FlySpeed SQL Query:
- Wide Compatibility with Database Servers: FlySpeed SQL Query supports a vast array of modern database servers, including MS SQL Server, MySQL, Oracle, PostgreSQL, SQLite, and more. It also works seamlessly with popular desktop databases and file formats such as CSV and Excel, making it a flexible solution for various data management needs.
- Ad-hoc SQL Query Designer: The standout feature of FlySpeed SQL Query is its visual SQL Query Builder, which simplifies the creation and modification of SQL queries. Users can design queries by dragging and dropping database objects, making it easier to generate complex queries without needing to write code manually. The tool also allows the creation of parameterized queries and offers a visual representation of linked tables through foreign keys.
- Data Browsing and Editing: FlySpeed SQL Query provides a user-friendly interface for browsing and editing data. Users can view data in a grid format or customize their view using the form view option. The tool also supports quick data filtering, searching, and setting up master-detail views, ensuring that data management is both efficient and straightforward.
- Automatic Session Restoration: One of the most convenient features of FlySpeed SQL Query is its ability to save your queries and database connections automatically. This means that when you reopen the program, you can resume your work exactly where you left off. The tool also maintains a history of executed queries, allowing users to revisit previous queries easily.
- Free SQL Query Tool: The Free version of FlySpeed SQL Query offers a comprehensive set of features, including full SQL query functionality and data browsing capabilities. While it lacks the ability to print, export, and import data, it remains a robust tool for non-commercial use and personal projects.
- Data Export and Import: For users requiring more advanced functionality, the Express and Professional versions of FlySpeed SQL Query offer additional features. The Express version supports fast data export to popular office formats and allows users to print and save reports in PDF. The Professional version extends these capabilities by enabling data import from clipboard, CSV, and Excel files directly into the database.
- Portable Version: FlySpeed SQL Query’s Portable version is particularly useful for professionals who work across multiple workstations. By installing the tool on a cloud folder, network, or portable drive, users can access their database connections and queries from any location, ensuring consistent productivity on the go.
FlySpeed SQL Query is an indispensable tool for both SQL experts and beginners. Its broad compatibility with database servers, intuitive visual query builder, and robust data management features make it a powerful ally in any data-related task. Whether you're looking for a free solution for everyday SQL querying or need advanced import/export capabilities, FlySpeed SQL Query has a version tailored to your needs. With its user-friendly interface and time-saving features, it’s the ideal choice for enhancing productivity and efficiency in data management.
FlySpeed SQL Query - Changelog:
- The list of bugfixes and improvements:
- Oracle, PostgreSQL, MySQL and Snowflake: Support for natural and lateral joins is added.
- Oracle: Support for cross and outer apply is added.
- PostgreSQL: Support for Only, Materialized and not Materialized CTE hints is added.
- The regression with switching between cells in Edit mode using the Tab key is addressed.