The table below shows the features included in the 
Enterprise and Professional Editions of DatabaseSpy 2026.
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 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, 5 | ||||
| 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, 12.1 | ||||
| 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, 11.8 | ||||
| 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, 9.0/9.1 | ||||
| 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, 17 | ||||
| Oracle® 9i, 10g, 11g, 12c, 18, 19 | ||||
| Progress OpenEdge 11.6 | ||||
| SQLite 3.x | ||||
| Sybase® ASE 15, 16 | ||||
| Teradata 16 |