DatabaseSpy

Multi-Database Tool and SQL Editor

Altova DatabaseSpy is the unique multi-database query and design tool that even generates elegant charts directly from query results.

DatabaseSpy connects to all major databases, easing SQL editing, database structure design, content editing, and database conversion for a fraction of the cost of single-database solutions.

SQL Editor and Query Tool

The versatile DatabaseSpy SQL Editor is divided into a SQL statement window and one or more tabbed or stacked Result windows, with a convenient Execute button in the SQL Editor toolbar to let you immediately execute your SQL statements and view the output.

The SQL statement window applies color coding to each SQL statement with unique identification for SQL statements, parameters, operators, and comments to help you quickly and easily review and analyze an individual SQL query or a complex series of SQL commands.

The DatabaseSpy SQL editor features customizable SQL auto-completion to accelerate SQL query development. Execute queries and see immediate results in one or more windows that may be tabbed or stacked.

Supported Databases:

Firebird 2.5, 3
IBM DB2 for iSeries® v6.1, 7.1, 7.2, 7.3
IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
Informix® 11.70, 12.10, 14.10
MariaDB 10, 10.3
Microsoft Access™ 2003, 2007, 2010, 2013, 2019
Microsoft® Azure SQL
Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016, 2017, 2019
MySQL® 5, 5.1, 5.5, 5.6, 5.7, 8
Oracle® 9i, 10g, 11g, 12c, 18, 19
PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.6, 10, 11, 12
Progress OpenEdge 11.6
SQLite 3.x
Sybase® ASE 15, 16
Teradata 16

SQL formatting configurations are provided for each supported database and appropriate formatting is automatically applied when you switch databases.

DatabaseSpy supports asynchronous query execution, allowing multiple SQL queries to be processed in different windows at the same time, either queries to different servers or even multiple queries against the same server.