Database Editor

DatabaseSpy Supports all DBs in One, Affordable Version

  • Database editor for all major relational DBs
  • Multi-database SQL editor
  • Graphical database design
  • Automatically adjusts syntax for different DB types
  • Convert existing tables to new DB type
  • Save graphical table representation as image file
  • Compare database schema & table data
  • Generate complete DDL scripts for database schemas

Edit Database Content

Database editor

DatabaseSpy supports all major relational databases:

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

DatabaseSpy offers convenient editing tools for database table content, allowing you to edit the content of database tables in an interactive preview window.

When all your changes are complete, you can review your edits and commit them all at once via the Commit button on the toolbar.

Intuitive DB editing features:

  • Interactive editing in query results table
  • Copy ranges of results to paste into other apps
  • Search feature for results tables to locate data
  • Cells with changed data remain highlighted until Commit
  • Calculate sum, average, and other values for ranges of results
  • Delete or append entire rows in one step
  • Send XML directly to XMLSpy for editing
  • Export binary data to a file
  • Replace binary data from a file

Graphical Database Design

To make database editing and design easier, DatabaseSpy lets you view and edit the structures of all your databases through one graphical user interface. You can examine tables and relationships in an existing database to understand them more easily, you can edit existing database tables, or you can add tables and specify all their column attributes and relationships to other tables from scratch.

visual database editor

The graphical editing approach allows you to concentrate on the underlying structure of your data and any required modifications rather than the SQL commands required to implement them. As you work, the DatabaseSpy graphical database designer automatically constructs the SQL statements you will need, but you choose when to execute the database structure change script once all your edits are complete.

Because it supports multiple databases, DatabaseSpy automatically adjusts the contents of pull-down lists of data types and other specialized features.

Visually Edit DB Tables

You can view the structure of any existing table in your database by dragging it from the database browser into the database design pane or by selecting it and choosing Show in Design Editor from the context menu. The table and column details are immediately displayed in the database designer graphical view.

The graphical image of each table includes compartments you can expand to view in greater detail or collapse so you can concentrate on table relationships, which are clearly indicated with connecting lines.

You can edit table column names and attributes directly in the graphical table display, or add a new column, index, key, or constraint by clicking icons, or via a right-click context menu. You can also edit existing entries directly in the design window or in the properties helper window.

More Database Editing Tools