Welcome to Database Modeling Excel Project Home Page

• NOTE

The project has been migrated to Github
https://github.com/snyang/Database-Modeling-Excel
The tool will be downloaded from here



Current release: 7.0 Production Release
Author: Yang Ning (Steven)
Please send your email to Steven Yang when you have any question.
Denote the Project

The database modeling utility is a Microsoft Office Excel workbook which can help you on your work of design database.
It supports DB2, MariaDB, MySQL, Oracle, PostgreSQL SQLite and SQL Server.
In the workbook, you can define database, generate DDL scripts, and import database definition from existing databases.

• Why choose this as your database modeling utility?
  • The strengths of the utility are:
    • Ability to quick design database.
    • Ability to more readable

• News
  • Version 7.0 was released on 2014/10/10

Database Modeling Excel can help you to design database schema.

• Main Features
• Supported Databases
  • DB2
  • MariaDB
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • SQLite (Only support generating DDL feature)
• Design and maintenance database schema
• Generate script of database schema using workbook’s content.
  • Create Tables SQL
  • Drop Tables SQL
  • Drop and Create Tables SQL
  • Create Tables IF Not Exists SQL
• Support ignore some worksheets when generating SQL scripts
• Import database schema from database into the workbook
• Support automatic build process
• Fine print (A4 paper)