Freeware sql query builder tool

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. Rating: 5 out of 5. Thanks to Mark James for his Silk icon set available at www. Have a look at Active Query Builder , the leading solution for SQL query building, parsing, analysis and modification.

Available in Java,. Working with a mixture of database formats to power a website I have found FlySpeed SQL editor to be invaluable and a Fantastic productivity enhancement tool as. All in all I would rate this a 12 out of 10 and have no reservations in recommending this for everyone writing SQL. All rights reserved. Product summary Latest version: 4. 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.

Simplified querying with parametrized queries, customizable data views. Combined visual query building and SQL text editing. I have relied upon FlySpeed for over three years. Love the product and keep up the good work.

The deadlock tab shows you the processes involved in the deadlock so you can find the root cause. The price depends on which systems you want to monitor, the number of licenses, what your DevOps needs are, and the number of users or database servers you want to monitor.

You can download the two-week free trial. The software makes contextual recommendations based on code analysis rules and there is a code snippet library for the user to refer to.

There are also extensive formatting options so you can choose precisely what scripts you want formatted or block certain blocks from being formatted.

You can hover over a piece of code to view code issues and then click on the lightbulb icon for more information. There are over 90 rules available out-of-the-box that can be managed through the options menu.

You can save , preview , and restore tabs from your last session. You can download the day free trial. You can draw queries through the visual query diagram and add sub-queries to build on the foundations of the main query.

There is also a drag-and-drop feature so you can add tables easily. However, you can also use code completion to build high-quality code with this database designer. For larger queries, you can use the Document Outline window to navigate faster. There is also the option to use more general SQL editing features like bookmarking , text searching , and coloring. The window layout can be customized , with highlighting and toolbar customization. You can even choose what UI skin you want to use. The price is also very competitive.

There is also a day free trial. Build complex queries and edit subqueries in visual and SQL text modes. Formatting is customizable so you can decide how code is presented. To improve the coding experience the SQL Text Editor offers code completion to speed up code building.

There is also a syntax highlighting to aid navigation. Your query execution history is also regularly saved so you can find where you left off after at the end of a session. It is also multi-threaded with each query running in a different thread. The free version allows you to create SQL queries and browse result data but you need the full version to save and export the data. To help the user improve performance, SQL Query Tuner has color-coded index analysis for used, unused, and missing indexes.

There is also a wait time analysis feature to detect poorly performing SQL queries. For those who require a more visual experience, there are SQL query tuning diagrams. Query diagrams allow you to view Cartesian joins and many-to-many relationships as a visual display. Viewing queries in this format makes it much easier to understand the effect of SQL statements. The software has a range of diagnostic capabilities you can use to monitor database performance.

For instance, you can monitor real-time availability and performance of server instances. Alerts identify poorly performing queries. With the Invantive Query tool you will have all your company's operational data available on demand.

The Query Tool empowers you to execute queries, capture and analyze your data and create business reports in real-time. You will be able to extract information such as billable hours, project and process activities, employee leave and attendance with ease.

Those functionalities enable you to create and deliver financial, operational or other business reports to executives in real-time. The reports can be created and delivered on database and non-data formats. On database reporting enables you to use analytical applications, which may be created with Invantive Producer, to analyze the data stored in the repository. In addition, on database reporting allows you to execute queries to analyze your data.

The non-database reports can be delivered in your preferred format. Groupings created within the query results grid are retained within the export, including grouping in Microsoft Excel.