Hack your Database like a Pro

Productivity tools for your relational database system

Visual Xtractor
FREE!
Transform your SQL query results into regular and inline charts
With manually entered SQL queries and limited number of SQL builders.
Horizontal Inline Bars
Dozens of Chart Types
Quick Chart Creation
No Intermediate Repositories
No Need for Coding
Multiple Chart Themes
Builtin and Custom Images
Inline Spark Charts
Fast Chart Recipes
Learn more
Query Xtractor
FREE!
Design your SQL queries with our friendly universal query builder
With no chart builders and independent model diagrams
Visual Query Builder
Universal Query Generator
Pivot/Unpivot Queries
Emulated Grouping Sets
Drill-Down on Relationships
Sort with Nulls
Window Functions
Parameterized Queries
Nested Aggregates
Learn more
Model Xtractor
FREE!
Extract rich and flexible ER models from any relational database
With no query builders, query generator and chart support.
Instant Model Extraction
Enhanced Data Models
Expandable Relationship Items
Custom Joins and Chains
Custom Aliases
Generic Model Views
Universal Database Support
Collapsible Shapes
Multiple Themes
Learn more

Data Xtractor

Data Xtractor = Visual Xtractor + Query Xtractor + Model Xtractor

Data Xtractor Subscriptions

FREE for SQLite, Firebird, Microsoft SQL Server CE and Microsoft Access databases

Open-Source Databases
monthly (paid annually)
$24
Build SQL Queries without restriction for open-source databases
MySQL Databases
MariaDB Databases
Amazon Aurora
PostgreSQL Databases
Amazon Redshift
Subscribe
Commercial Databases
monthly (paid annually)
$29
Build SQL Queries without restrictions for commercial databases
Microsoft SQL Server/Azure
Oracle Databases
IBM Db2 Databases
Sybase/SAP ASE
Sybase/SAP SQL Anywhere
Subscribe
All Supported Databases
monthly (paid annually)
$39
Build SQL Queries without restriction for all our supported databases
MySQL/MariaDB/Aurora
PostgreSQL/Redshift
SQL Server/Azure
Oracle/IBM Db2
SAP ASE/SQL Anywhere
Subscribe

What People Say

Scott Clark

Scott Clark

VOI Consulting

"Model Xtractor was a breeze to learn, and Query Xtractor has some built-in safety features, which came in very handy."

Lenny Zhurbilo

Lenny Zhurbilo

Staples

"We were searching for query tool to replace Brio and Query Xtractor looked very promising for us."

Alexandru Sasu

Alexandru Sasu

Softpedia

"Sophisticated enough to handle a broad range of databases, and intuitive enough to be a learning tool for beginners."

Our Latest Posts

SQL Left Pad (LPAD) Function: Emulated and Built-In

Use one single generic SQL Left Pad string function (LeftPad) for any built-in LPAD function or its emulation with a SQL expression. This article walks through in detail over the generated SQL when LPAD was supported or not. Select LeftPad from our visual SQL query builder, and it will be translated into the appropriate call.

Shared Inline Aggregates with Window Functions for MySQL

Design SQL queries with window functions and reusable OVER clause declarations, regardless of whether or not your database supports the standard SQL WINDOW definition. Design visual SQL queries using MySQL window functions through Data Xtractor. Generate reusable WINDOW definitions, or simply isolate a reusable OVER clause in the visual designer.

Database Products with Window Functions Support

This permanently updated list shows all database products with built-in native support for Window Functions. This includes the OVER clause, named windows or window chaining with the WINDOW clause, together with ranking functions, offset navigational functions and other related functions.