The table below shows the features included in the
Enterprise and Professional Editions of DatabaseSpy 2025.
DatabaseSpy is also available in the Altova MissionKit, a software development suite of industrial-strength XML, SQL, and UML tools featuring XMLSpy and other award-winning products - all at a special discounted price.
Enterprise | Professional | |||
---|---|---|---|---|
32-bit version | ||||
64-bit version | ||||
AI Assistant | ||||
AI-powered extensions | ||||
SQL Editor | ||||
Generate a variety SQL statements in the Online Browser based on existing tables and columns, including SELECT, CREATE, INSERT, DROP, and more | ||||
Generate complete DDL scripts for a database schema | ||||
Open and save SQL statements in files for reuse | ||||
Color-coded auto-formatting with collapsible regions and named result windows | ||||
Customized appearance of SQL code for each supported database | ||||
Refactoring menu to add or remove semicolons and quotation marks, or automatically remove comments from SQL statements | ||||
Dynamic autocompletion window for SQL editing with options to display and insert names of tables, views, columns, functions, datatypes, procedures, and keywords | ||||
Support for SQL queries that contain parameters (SQL Templates) | ||||
Edit views and stored procedures | ||||
Display query results in multiple named or stacked results tables | ||||
Charts of SQL Query Results | ||||
Line charts | ||||
2D and 3D bar charts | ||||
Stacked bar charts | ||||
2D and 3D pie charts | ||||
Area charts | ||||
Stacked area charts | ||||
Round gauge charts | ||||
Bar gauge charts | ||||
Candlestick charts | ||||
Chart overlays | ||||
Chart background images and color gradients | ||||
Customize chart titles, axis ranges, colors, fonts, and sizes | ||||
Save charts as .png, .bmp, .gif, and .jpg image files | ||||
Graphical Database Design | ||||
Display tables and relationships in graphical view | ||||
Add or modify database tables | ||||
Add or modify columns with datatypes, lengths, nullable characteristics | ||||
Add or modify indexes, keys, and check constraints | ||||
Build database change script to execute immediately, send SQL editor, or save in a file | ||||
Save graphical database diagrams as .png or .emf image files | ||||
Data Import and Export | ||||
Import data from XML or CSV formats | ||||
Import data directly or generate a SQL import script | ||||
Export data in XML, CSV, HTML, or Excel formats | ||||
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, 9.5, 9.7, 10.1, 10.5, 11.5, 11.5.7 | ||||
Informix® 11.7, 12.10, 14.10 | ||||
MariaDB 10, 10.3, 10.4, 10.5, 10.6.5, 10.9.2, 10.11, 11.2, 11.4 | ||||
Microsoft Access™ 2003, 2007, 2010, 2013, 2019 | ||||
Microsoft® Azure SQL | ||||
Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016, 2017, 2019, 2022 | ||||
MySQL® 5, 5.1, 5.5, 5.6, 5.7, 8, 8.0.25, 8.0.28, 8.2, 8.3, 8.4 | ||||
PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4, 9.6, 10, 11, 12, 13, 14.1, 14.5, 15,16 | ||||
Oracle® 9i, 10g, 11g, 12c, 18, 19 | ||||
Progress OpenEdge 11.6 | ||||
SQLite 3.x | ||||
Sybase® ASE 15, 16 | ||||
Teradata 16 |