Easy Database Design Tool for Oracle Databases
and PostgreSQL, SQL Server, MySQL, MariaDB, SQLite
If you work with Oracle databases and need a better way to design and manage your schemas visually, Luna Modeler is the tool for you. Whether you’re new to data modeling or an experienced developer or DBA, Luna Modeler helps you create professional ER diagrams, generate SQL scripts for Oracle Databases, synchronize data models and document your database with ease.
Learn more about Luna Modeler
Luna Modeler is ideal for developers, database architects, DBAs, analysts, teachers and anyone who is passionate about database design and data modeling and wants to use a modern, intuitive and affordable tool.
Download Luna Modeler
Frequently Asked Questions on Database Design for Oracle Databases
There are various tools available on the market, ranging from very expensive to free tools. If you are looking for a modern tool that you can easily install on Windows, but also macOS or Linux, we recommend Luna Modeler, which offers a number of features specific to Oracle Database design, SQL script generation and synchronization.
Yes. Luna Modeler can connect to an existing Oracle database and generate ER diagrams based on your schema. You can then add notes to the diagram, change the structure, and synchronize the data model with the database.
Yes. SSH, Cloud Wallet and Custom connections are supported in Luna Modeler professional edition.
Yes. You can generate SQL scripts from data models created in Luna Modeler, including custom SQL blocks.
Absolutely. In Luna Modeler, you can work with basic database objects such as tables, relationships, as well as types, packages, sequences, triggers, synonyms, and other Oracle-specific database objects.
In Luna Modeler, you can compare the model with the database and then generate an HTML report, update the model or generate SQL scripts for the differences.
Everything you create stays with you. Luna Modeler does not store database connections or projects online. Your data is yours and everything is completely under your control.
Key Features of Luna Modeler
for Oracle Database Design
Draw advanced
ER diagrams
Luna Modeler allows you to design ER Diagrams easily. Compared to simple drawing tools, it supports designing specific Oracle database objects and displaying elements such as Synonyms, Types, Packages etc.
Another key feature is the generation of SQL scripts for Oracle Databases.
Model Oracle Databases comfortably and offline!
The easy-to-use interface lets you work quickly and comfortably. Changes are saved instantly.
You don’t even need to have the database installed to design a new database structure.
Luna Modeler does not store information in the cloud. Whatever you create stays with you.
Generate interactive documentation
Create interactive HTML documentation for your database designs or export diagrams to multi-page PDF files.
You can also export data model information to a custom format, for example, CSV files.
Generate SQL scripts for your database designs
Once you have the database design ready, you can easily generate the SQL script.
In the settings, you can control how the SQL script will be generated, sort the objects or select a sub-diagram and generate the output for only part of your project.
Visualize existing Oracle Database structures
Connect to an existing Oracle Database and visualize the structure using ER diagrams. In the Professional Edition, you can establish a connection using a custom connection string or Oracle Cloud Wallet.
Detect changes and update your projects or generate SQL scripts for the differences
Connect to your Oracle Database, compare the structure of your existing database with your project and generate a detailed HTML report, update the project easily or generate SQL scripts to synchronize the data model with the database.
Download
Luna Modeler
Luna Modeler is available for Windows, Linux and MacOS.
Trial version expires 14 days after installation.