Visual SQL Query Builder to get data in seconds!

Active Query Builder is great for…

Ad-hoc reporting and data analysis

Data export

Data import

Convenient data browsing

Ad-hoc reporting and data analysis

Allow lay users to query an SQL database on their own.
Arm business decision-makers with the information they need right now.
Make the visual query builder an integral part of your report system.

Data export

Let users choose the data they need to export.
Automate export tasks with bind variables.
Discreetly add extra conditions to SQL queries
Analyze user queries to prevent information leakage.

Data import

Сonnect to external databases of various DB servers.
Collect data even from legacy IT systems.
Map query columns to fields of internal entities.
Automate data flow using bind variables.

Convenient data browsing

Apply filters to query columns with friendly UI.
Sort and paginate data in the query result set.
Calculate totals for columns by means of SQL.

Active Query Builder Offers

Visual and text SQL editing

Visual SQL query builder
Visual filter builder
SQL text editor
Nested queries (use one in another)

Feature-rich API to operate with SQL queries

SQL query parser
SQL analyzer
API to create and modify user queries
SQL formatter/beautifier

Build friendly environment to work with SQL queries and data

Organize Database schema tree
Define friendly names for objects
Build feature-rich data browsing UI
Create repository of user queries

Supports Dozens of Database Servers and various SQL Standards

Teradata, SAP HANA, Informix, Netezza, Firebird, Pervasive and many others...

Designed for:

Desktop

.NET WinForms .NET WPF Delphi C++Builder ActiveX Java

Web

ASP.NET WebForms ASP.NET MVC ASP.NET Core

* Works perfectly with any web app, incl. Angular, React.Js, Vue.Js by packing the server-side in a Docker container.

Download free trial now

What Our Happy Users Say About Us

Our team has worked with the Active Query Builder components since the middle of 2014. By using Active Query Builder we have managed to upgrade our applications to the point where we can enable users with very little to no knowledge of SQL to access their databases and retrieve accurate summaries of their data. The component itself is flexible, easy to use, user-friendly and consistently improved upon. Any issues that might occur are dealt with by a support team that sets the benchmark for customer service and professionalism.

In short, a superb product developed and supported by a superb team.

Gert Venter IDSC

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

... In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Joel Tesdall MAPCON Technologies, Inc.

With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved.

Duncan Deacon