Altova DatabaseSpy Enterprise Edition is a unique multi database query, design, and transformation tool developed by the creator of XML Spy.

DatabaseSpy connects to all major databases, providing a simple and easy-to-use solution for SQL editing and other database tasks, at a cost that is only a small fraction of a single database solution.

DatabaseSpy provides an intuitive database connection wizard and organizes connections and related project files, making it easy to access your database and its components. You can open multiple database connections simultaneously, even if these databases are of different types.

It clearly displays tables, views, stored procedures, and data in a convenient window, and can directly edit database content. DatabaseSpy's SQL editor simplifies query writing through code automation, syntax coloring, drag and drop editing, and other features. You can retrieve data from multiple tables and display the results in each named window to maximize clarity.

DatabaseSpy can generate custom business intelligence charts from query results based on the line, column, pie, area, dashboard, or candle styles you choose.

DatabaseSpy's powerful design editor enables graphical design and visualization of database structures or patterns.

XML support includes advanced functionality to check XML data in tables and manage the XML schema used to validate that data.

It can export data into five formats and import data from CSV and XML files. DatabaseSpy can connect to databases such as Microsoft SQL Server, PostgreSQL, Oracle, MySQL, IBM DB2, Informix, Sybase, Firebird, MySQL, SQLite, MariaDB, Teradata, Microsoft Access, etc. With all these and more features, DatabaseSpy can definitely save you time, simplify your work, and ensure the accuracy of all data. DatabaseSpy is available in both 32-bit and 64-bit versions.

SQL Editor and Query Tools

The versatile DatabaseSpy SQL editor is divided into an SQL statement window and one or more tabbed or stacked result windows. There is also a convenient "execute" button on the SQL editor toolbar, allowing you to immediately execute SQL statements and view the output results.

The SQL statement window applies color coding to each SQL statement and uniquely identifies the SQL statement, parameters, operators, and comments to help you quickly and easily review and analyze a single SQL query or a series of complex SQL commands.

In addition, the SQL editor supports automatic completion of SQL statements and context sensitive SQL formatting, making it easy for even novice users to write complex SQL queries.

The results window displays the output of your SQL query in multiple formats, including tables, charts, and text. You can easily copy and paste the results directly into other applications, or save them as CSV or HTML files.

DatabaseSpy also includes a powerful query builder tool that allows you to visually create complex SQL queries without the need to understand the underlying syntax. Simply drag and drop tables and fields, set filtering criteria, and specify sorting and grouping options to build the query. The query builder will even generate SQL code for you, and if necessary, you can make fine-tuning in the SQL statement window.

Whether you are a beginner or an experienced SQL user, the DatabaseSpy SQL editor and query tools can easily create and execute SQL queries, analyze data, and share your results with others.

The DatabaseSpy SQL editor has customizable SQL automatic completion function, which can accelerate SQL query development. Execute a query and view immediate results in one or more tabbed or stacked result windows.

Supported databases:

- Firebird 2.5、3、4

- IBM DB2 for iSeries v6.1、7.1、7.2、7.3、7.4 ®

- IBM DB2 8、9.1、9.5、9.7、10.1、10.5、11.5、11.5.7 ®

- Informix 11.70、12.10、14.10 ®

- MariaDB 10、10.3、10.4、10.5、10.6.5、10.9.2

- Microsoft Access ™ 2003、2007、2010、2013、2019

- Microsoft Azure SQL ®

- Microsoft SQL Server 2005-2022 ®

- MySQL 5、5.1、5.5、5.6、5.7、8、8.0.25、8.0.28 ®

- Oracle 9i、10g、11g、12c、18、19 ®

- PostgreSQL 8、9、10、11、12、13、14、15

- Progress OpenEdge 11.6

- SQLite 3.x

- Sybase ASE 15、16 ®

- Teradata 16

Each supported database provides SQL formatting configuration, which will automatically apply the corresponding formatting when you switch databases.

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