SQLEditor

New in SQLEditor 4

• Updated for Apple Silicon Macs

• Improved import and export

  SQLEditor includes improved import and export with better feedback and improved reliability

• Bug fixes and reliability improvements

New in SQLEditor 3

• Streamlined single window interface

  We’ve merged the inspector and all of the floating palettes into the main window. It means less screen clutter, it’s better in full screen mode and it’s more efficient on smaller screens.

• Dark Mode Interface Support

  SQLEditor now works in Dark Mode UI and you can edit documents in either light or dark mode

• Javascript Plugin System

  Create your own SQL dialects for export using Javascript. Our new report generator also uses javascript so it’s easy to customize.

• Performance improvements

  SQLEditor 3 supports bigger documents and loads them faster. It also has numerous other performance and stability improvements

• Better pre-flighting with more pre-flight actions

  The preflight system has been improved with new error display and single click highlighting of tables with errors. We’ve also added some new preflight actions to catch new types of errors in your database designs.

• Design Report Generator

  Instantly generate a comprehensive listing of tables and views, with columns, indexes, foreign keys and constraints listed. It also includes any comments or notes you’ve set in SQLEditor or that we have extracted from the database system. Use our report template, or create your own using handlebars compatible templates.

• New style options

  You can now customize the font and style for tables and fields.

Main Features

• Design your database using a graphical interface
• SQLEditor is written in native Cocoa/Appkit giving better performance and less resource usage
• Object inspector to edit objects, displaying only relevant options
• Live source view, which automatically updates as you edit the design
• Supports major database systems including MySQL, SQLite, Oracle and Postgres
• Reverse engineer existing databases into a diagram
• Export diagrams to create a new database or modify an existing one
• Create foreign keys with simple drag and drop, or create more complicated foreign keys with multiple columns
• Connection highlighting shows you instantly which columns reference each other with color coding
• Import SQL from other applications by pasting, export back by copying
• Data type lists are dialect specific, only showing types you can actually use
• Supports creating and editing Ruby on Rails migration and schema files
• SQL file import allows you to import SQL text files and schema dumps
• Export diagrams in multiple formats for web or print documents including SVG
• Color code and label your objects, change label colors and all labelled objects update
• Find system allows you to search database tables for a specific object
• Object preflight to detect errors in design
• Multiple print options to allow detail or summary printing