Active Query Builder

Let any user turn data into information!
Build user-oriented software and let your customers be data driven with Active Query Builder!
Get Started
Why?
Business users require information to make decisions on the spot with no extra assistance.
How?
We know how to transform user questions into SQL queries in a friendly and safe graphical UI.
What?
With Active Query Builder you will integrate a database querying module into your software in a few hours.

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.

With Active Query Builder, users are confident in SQL queries and make data-based decision faster

Instant data browsing
Information is shown as the user builds a query.
Reverse engineering
Parsing and visual representation of plain text SQL queries.
Helpful tips and warnings
Users can no longer shoot themselves in the foot.
Try the online demo

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...
Microsoft SQL Server MySQL PostgreSQL Oracle Database Server SQLite Firebird
MS Access Teradata SAP Hana Netezza Informix DB Sybase Adaptive Servr
IBM DB2 Advantage DB Pervasive DB ANSI SQL Standards

Designed for:

Desktop solutions
Desktop
.NET WinForms .NET WPF Delphi C++Builder ActiveX Java
Web solutions
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

Gert Venter photo

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
Joel Tesdall photo

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.
customer photo

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

Trusted by 2000+ Customers all over the World

IBM
Oracle
Intel
Aveva
LineData
AccuQuery
Teledyne Brown Engineering
Oskosh corporation
Sapien Technologies
Alteryx
LogiCIM
QT9
Magnitude
XL Cubed

Free admins and programmers from serving end-user requests for data and let users help themselves in seconds!

Professional
Give users a sense of control over the data to build trust and loyalty.
Worthwhile
Add value to your software by letting users turn data into insights.
Safe
Have no stress letting users build SQL queries by themselves.

Need help?

We are here to help you to effortlessly integrate Active Query Builder into your IT infrastructure, quickly educate your end users to use the SQL-based reporting solution, and easily get answers to all of your questions.

Contact us

Blog and News