SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
SQL Parsing Tools for MariaDB
SQL Analyzer by Dataedo
Analyze your SQL queries in no time with our free and powerful SQL parser. Get tables and columns used in the query, generate data lineage diagram and ERD. Our parser is working perfectly with nested selects, CTE and unions.
| Export: | - |
|---|---|
| Free edition: |
|
| Query analysis: |
|
| Query optimalization: |
|
| Syntax validation: |
|
JSQLParser
JSQLParser is an RDBMS agnostic SQL statement parser. Built from JavaCC, it translates SQL statements into a traversable hierarchy of Java classes. It provides support for many dialects, such as Oracle, MS SQL Server, MySQL, MariaDB, PostgreSQL, H2, etc.
| Export: | - |
|---|---|
| Free edition: |
|
| Query analysis: |
|
| Query optimalization: |
|
| Syntax validation: |
|
Active Query Builder
Active Query Builder is a full-featured component suite for software developers. It includes an SQL Query Parser to build an SQL query object model of any given SQL query and a Visual Query Builder component to design SQL queries via an intuitive visual interface. Moreover, it includes an SQL Text Editor with code completion and syntax highlighting, along with a highly-customizable SQL Query Text Formatter. In short, it gives end users a clear view of their queries and database schema.
| Export: | Plain text,XML |
|---|---|
| Free edition: |
|
| Query analysis: |
|
| Query optimalization: |
|
| Syntax validation: |
|
