Online SQL query analyzer

Free web-based service for SQL query structure analysis.

Get insights about your SQL query statement in a single click!

Active Query Builder can parse an arbitrary SELECT statement and build its structure in a tree-like form.

Shows list of output columns;
Lists used database objects and fields;
Shows sub-queries of any types and highlights correlations between sub-queries;
Shows the content of every SQL expression, details their structure to tokens.

Based on Active Query Builder SQL parser.

Having purchased Active Query Builder, you can load a snapshot of your database schema and get:

Binding of objects and fields used in the query to database schema objects and fields;
Listing of orphan objects and fields.

Select a database server to analyze your query according to its SQL dialect.

Syntax:

Column Name	Expression

In the case of using unqualified field names (only field name without a table or alias specification) and asterisks in the SELECT list, lack of the information about your database schema may not allow the service to determine the belonging of some fields to objects.
Using this service as a Web API you can specify schema and analyze queries regarding it. Please contact us for details.

Column	Object

Object

View raw JSON

Works with SQL queries for various database servers and standards

Oracle

Microsoft SQL server

Azure SQL server

MS Access

MySQL

PostgreSQL

SQLite

Firebird

Sybase

IBM DB2

Informix

Teradata

Netezza

Advantage DB

SAP Hana

ANSI SQL standards

Active Query Builder: bridge the gap between your end-users and data

Learn how to embed the component into your system:

Get Started