.DMD

DMD File

Oracle SQL Developer Data Modeler Design File
Ask a question
QUICK ANSWER

A DMD file is an Oracle SQL Developer Data Modeler design file - an XML document that anchors a database design project containing entity-relationship diagrams, logical and relational models, and physical schemas. Open it with Oracle SQL Developer Data Modeler (free from oracle.com). The DMD file is only the entry point: the actual model data lives in a subfolder with the same name, and both must stay together.

Developer: Oracle Corporation Category: Developer Files MIME: application/xml
OPENS ON Windows macOS Linux
Related: .DO · .MD · .HEX · .XSD

On this page

19k+ extensions indexed
Last reviewed Aug 21, 2026

Not sure what your file is?

Drop any file into our identifier - we read just the first bytes to name the format.

Identify a file

What is the DMD file format?

A .dmd file is the top-level anchor document created by Oracle SQL Developer Data Modeler, Oracle's free visual database design tool. It is a small XML file - rooted at <OSDM_Design> - that stores the metadata for a complete database design: the design name, creator information and structural pointers to the rest of the model.

A .dmd file is never self-contained. It sits at the root of a design folder hierarchy and references subdirectories - typically logical/, rel/, datatypes/ and subviews/ - each holding their own XML files with the actual model content: entity-relationship diagrams, physical relational models, data type definitions and subview layouts. Moving or sharing a design requires copying both the .dmd file and its entire accompanying folder tree.

The file begins with <?xml version='1.0' encoding='UTF-8'?> followed by the <OSDM_Design> root element. The format is tied to the Data Modeler release that wrote it; opening a newer design in an older version may fail.

Oracle SQL Developer Data Modeler supports forward engineering (generating DDL SQL from the model) and reverse engineering (importing an existing database schema). The tool is cross-platform, Java-based and available free from Oracle.

Security & safety

RISK: LOW

DMD files are XML text describing database schemas - they contain no executable code and pose no direct security risk. The XML may reference proprietary class names specific to Oracle's toolchain, but these are data declarations, not code. Standard XML-handling cautions apply (do not parse untrusted XML in schema-validating contexts without limits).

Format details

in a nutshell
FULL NAMEOracle SQL Developer Data Modeler Design Fileaka SQL Developer Data Modeler file, Oracle Data Modeler design
DEVELOPEROracle Corporationsince Oracle SQL Developer Data Modeler 1.0 (circa 2007-2008)
MIME TYPEapplication/xml
TYPEXML-based database design/data model descriptor
This extension is also used by…
  • Visual dBASE Data Module - Legacy Visual dBASE (Borland/Inprise, 1990s) used .dmd for data module files - a 16-bit/Windows-era database IDE component; completely discontinued, Windows 3.x/9x era.
  • D language module cache / Digital Mars D compiler artefact - The DMD compiler for the D programming language produces .dmd files as build artefacts in some toolchain versions; these are binary compiler caches, unrelated to database modelling.
MAGIC BYTES · FILE SIGNATURE
OFFSET
0001020304
HEX
3C3F786D6C
ASCII
<?xml
The .dmd file is an XML file and begins with the standard XML declaration: <?xml version='1.0' encoding='UTF-8'?> followed by the root element <OSDM_Design class="oracle.dbtools.crest.model.design.Design" ...>. Detection is by content and extension; the magic bytes are the generic XML prefix.

Programs that open DMD files

Windows1 app
Oracle SQL Developer Data Modeler Free File > Open (or Open Design) - browse to the .dmd file. Make sure the design subfolder is in the same directory.
macOS1 app
Oracle SQL Developer Data Modeler Free File > Open - select the .dmd. Requires Java; the tool is cross-platform.
Linux1 app
Oracle SQL Developer Data Modeler Free Run the Data Modeler on Linux (Java); File > Open the .dmd with its subfolder present.

Technical details

deep spec
File formatXML document; begins with <?xml version='1.0' encoding='UTF-8'?>
Root element<OSDM_Design class="oracle.dbtools.crest.model.design.Design">
MIME typeapplication/xml
File encodingUTF-8, declared in the XML prolog
StandaloneNo - the .dmd is an anchor file; full design data lives in an accompanying subdirectory tree
Design subdirectorieslogical/, rel/, datatypes/, subviews/, pm/ - each holding XML model content files
Typical file size1 KB - 100 KB (descriptor only; bulk model content is stored in subdirectories)
Version compatibilityFile format tied to the Data Modeler release that wrote it; newer files may not open in older tool versions
PlatformCross-platform; Java-based tool runs on Windows, macOS and Linux
Supported model layersLogical (ERD), relational, physical, data type, process model and business information layers
Engineering supportForward engineering to DDL SQL; reverse engineering from existing database schemas
Proprietary schemaOracle-proprietary internal format (oracle.dbtools.crest.*); no published open XML schema
Tool availabilityOracle SQL Developer Data Modeler is free to download from Oracle
ReleasedOracle SQL Developer Data Modeler 1.0 (circa 2007-2008)
Latest versionOracle SQL Developer Data Modeler 23.1+ (2023 onwards)
Specificationdocs.oracle.com

DMD conversions

Community Q&A

asked by users
Ask a quick question
Get help from people who work with DMD files. Be specific - include your system and software version.
No account needed · answers usually within a day

No questions yet - be the first to ask about DMD files.

Frequently asked questions

What is a .dmd file?
Most likely an Oracle SQL Developer Data Modeler design file - an XML anchor for a database design project. It must be kept alongside its accompanying design subfolder (same name) which holds the full model data.
How do I open a .dmd file?
Download Oracle SQL Developer Data Modeler (free from oracle.com), then File > Open the .dmd. Ensure the design subfolder is in the same directory.
Why does opening the .dmd give errors about missing models?
The design folder (named the same as your .dmd) is missing. The .dmd is only the index - the actual model data is in that subfolder. Keep both together. Use File > Export > To ZIP to bundle them portably.
How do I generate SQL from a .dmd design?
In SQL Developer Data Modeler, open the .dmd, then Engineer > Forward Engineer > DDL Script. Choose your target database platform and the tool generates the CREATE TABLE and related SQL statements.
Is my .dmd a Visual dBASE file or a Data Modeler file?
Open it in a text editor - if it starts with <?xml and contains <OSDM_Design ..., it is an Oracle SQL Developer Data Modeler file. Visual dBASE .dmd files are a very old format from the 1990s, not XML.

References

1Oracle SQL Developer Data Modeler - official pagewww.oracle.com
2Oracle Data Modeler Concepts and Usagedocs.oracle.com

Keep exploring

across the database

Top extensions this week

1.AQQAQQ Instant Messenger File
2.CRDOWNLOADChrome Partial Download File
3.PARTPartial Download File
4.DATProgram Data File (generic)
5.EXEWindows Executable (Portable Executable)
6.NOMEDIAAndroid No-Media Marker File
7.BINCD/DVD Disc Image (BIN/CUE)
8.RPMSGRestricted Permission Message
9.MDMarkdown Document
10.XDWDocuWorks Document

Related extensions

.DOStata Do-File
.MDMarkdown Document
.HEXIntel HEX File
.XSDXML Schema Definition
.MAPSource Map (JavaScript / CSS)
.CONFIGConfiguration File

Free file tools

An in-browser file identifier and image converter - everything runs on your device.

Open the toolbox

Browse file extensions A-Z