Writing SQL without fighting the syntax
You know what data you want, but one typo in a long, fully qualified query sends you back to hunt for the mistake. FlySpeed SQL Query is a Windows tool that lets you build queries visually, so you spend less time on syntax and more on the data.
Quick facts
- Current version: 4.10.7.0
- Platform: Windows, with desktop and portable editions in 32-bit and 64-bit
- Price: described by the vendor as a free SQL query tool
- Connects to: modern database servers, plus desktop databases and office file formats such as CSV and Excel
Key features
Build queries visually with an ad-hoc query builder
You assemble a query on screen instead of typing every join by hand. This helps most on complex queries, where a small typo is easy to make.
Browse and edit data in a grid or a form view
You can view results as a grid or in a customizable form view. You can also find and filter data quickly and set up master-detail views.
Export, print and save data to PDF
The tool can export, print and save data to PDF. Recent versions can also run several data exports in a batch, so you define the tasks once and rerun them whenever you need.
Work with many database types
It connects to all modern database servers. Recent releases added Snowflake support and better handling of joins, including CROSS APPLY, OUTER APPLY, NATURAL and LATERAL joins. You can also collapse subqueries in the text editor.
Who it's for
It suits people who write SQL often and want a visual builder next to the text editor. That covers beginners still learning joins and experienced users who want to build queries faster. If you work on a platform other than Windows, this is not the tool for you.
Pros and cons
- Pro: visual query builder that keeps you away from typos in long queries
- Pro: works with server databases and file formats like CSV and Excel
- Pro: a portable installer is available that needs no rights elevation
- Con: Windows only
- Con: the Universal installer requires elevation of rights
What users say
"All in all I would rate this a 12 out of 10 and have no reservations in recommending this for everyone writing SQL." (testimonial on activedbsoft.com)
FAQs
Which database servers can I connect to?
The tool connects to all modern database servers and to popular desktop databases and office file formats such as CSV and Excel.
Is there a portable version?
Yes. A portable installer is offered that needs no rights elevation, in addition to the Desktop/Portable builds.
Is it 64-bit?
Yes. There are both 32-bit and 64-bit builds.
Can I export my results?
Yes. You can export, print and save data to PDF.
System requirements
It runs on Windows. You need a connection to a local or remote database server, or a file such as CSV or Excel to work with.