Schema Export and Import

Export model entities to a range of schema formats including SQL DDL dialects, GraphQL SDL, TypeScript, Prisma, Protocol Buffers, and more. Import from SQL DDL scripts across multiple database dialects, plus draw.io, GraphML, PlantUML, and other diagram tools.

February 16, 2026

NeoArc Studio exports model entities to a range of schema formats across several categories: SQL DDL dialects, schema definition languages, graph and document formats, diagram notations, and graph exchange. The unified export dialog generates production-ready output with live preview, copy to clipboard, and file download. Multi-select group filtering allows exporting specific subdomains. For bringing existing schemas into the model, SQL DDL import covers multiple database dialects, with additional parsers for diagram tools and graph formats.

Schema Export (24 Formats)

Export model entities to SQL DDL, schema definition languages, diagram notations, and graph exchange formats. The unified export dialog provides a live preview, copy to clipboard, and file download. With 24 formats across 5 categories, the export system covers the full range of database platforms, schema languages, and interchange formats used in modern software development.

12 SQL DDL Dialects

Generate CREATE TABLE statements for PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake, MariaDB, CockroachDB, BigQuery, Redshift, DB2, and Generic SQL. Each dialect uses correct data types, naming conventions, and constraint syntax.

7 Schema Definition Languages

Export to GraphQL SDL, TypeScript Interfaces, DBML, Prisma Schema, Apache Avro, Protocol Buffers, and Mongoose Schema. Each format maps entity properties, relationships, and constraints to the target language conventions.

5 Additional Formats

Neo4j Cypher DDL, JSON Schema (draft-07), Mermaid ERD, PlantUML ERD, XML Schema (XSD), GraphML, and NeoArc JSON. Covers graph databases, document validation, diagram notation, and graph exchange.

Export Format Categories

Category	Formats
SQL DDL (12 dialects)	PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake, MariaDB, CockroachDB, BigQuery, Redshift, DB2, Generic SQL
Schema Definition (7)	GraphQL SDL, TypeScript Interfaces, DBML, Prisma Schema, Apache Avro, Protocol Buffers, Mongoose Schema
Graph and Document (3)	Neo4j Cypher DDL, JSON Schema (draft-07), NeoArc JSON
Diagram Notation (3)	Mermaid ERD, PlantUML ERD, XML Schema (XSD)
Graph Exchange (1)	GraphML XML

SQL DDL Export Details

SQL DDL export generates production-ready database scripts with full constraint support.

Dialect	Type Source	Naming Convention
PostgreSQL	Database profile mappings	snake_case
MySQL	Database profile mappings	snake_case
SQL Server	Database profile mappings	PascalCase
Oracle	Database profile mappings	SCREAMING_SNAKE_CASE
SQLite	Built-in mappings	snake_case
Snowflake	Built-in mappings	SCREAMING_SNAKE_CASE
MariaDB	Built-in mappings	snake_case
CockroachDB	Built-in mappings	snake_case
BigQuery	Database profile mappings	snake_case
Redshift	Database profile mappings	snake_case
DB2	Database profile mappings	SCREAMING_SNAKE_CASE
Generic SQL	Fallback mappings	snake_case

Group Filtering for Export

Target specific subdomains of the model using group filters.

Export Workflow

Schema Import

Bring existing schemas into the data model from SQL DDL scripts across 6 database dialects, with additional parsers for diagram tools and graph formats.

SQL DDL Import (6 dialects)

Paste or upload SQL DDL from PostgreSQL, MySQL, SQL Server, Snowflake, Oracle, or DBML. Parses CREATE TABLE, ALTER TABLE (foreign keys), and CREATE INDEX statements. Maps tables to entities, columns to properties, and foreign keys to relationships with automatic type resolution.

Additional File Parsers

Additional parsers for draw.io, Microsoft Visio, GraphML, PlantUML, and other diagram and graph tools. Each parser extracts entities and relationships into a common format for model integration.

Preview and Group Assignment

Before importing, preview extracted entities with property counts and conflict warnings for duplicate labels. Assign imported entities to a new group, an existing group, or no group. Resolve naming conflicts before they enter the model.

Import Format Details

Format	File Extensions	Text Paste	Description
SQL DDL (6 dialects)	.sql	Yes	PostgreSQL, MySQL, SQL Server, Snowflake, Oracle, and DBML
draw.io / diagrams.net	.drawio, .xml	No	Entity shapes and connections from draw.io XML files
Microsoft Visio	.vsdx	No	Import entity shapes from Microsoft Visio diagram files
GraphML	.graphml	No	Graph exchange format files with node and edge data
GEXF (Gephi)	.gexf	No	Gephi graph exchange format files
Graphviz DOT	.dot, .gv	Yes	Graph description language files
JSON Graph Format	.json	Yes	JGF graph files with typed nodes and edges
PlantUML	.puml, .plantuml	Yes	Class and entity diagrams from PlantUML notation
Mermaid ERD	.mmd, .mermaid	Yes	Entity-relationship diagram syntax from Mermaid
Neo4j Cypher	.cypher, .cql	Yes	CREATE statements from Cypher scripts
ERDPlus	.json	No	ERDPlus JSON export files
StarUML	.mdj	No	StarUML project files with class diagrams
RDF/OWL (Turtle)	.ttl	Yes	RDF Turtle ontology files with classes and properties
RDF/OWL (XML)	.rdf, .owl	No	RDF/XML and OWL ontology files
OpenAPI	.json, .yaml	Yes	OpenAPI specifications for REST API documentation

Import Workflow

Detailed Guides

For format-specific documentation and examples, see the guides below.

Importing Schemas

Import entities into the data model from a wide range of file formats including SQL DDL dialects, draw.io, GraphML, GEXF, Graphviz DOT, PlantUML, Mermaid ERD, Neo4j Cypher, ERDPlus, StarUML, RDF/OWL, JSON Graph Format, Microsoft Visio, and OpenAPI.

Exporting Schemas

Export data model entities to a wide range of schema formats spanning SQL DDL dialects, schema definition languages (GraphQL SDL, TypeScript, Prisma, Avro, Protobuf, DBML, Mongoose), graph and document formats, diagram notations, and GraphML.

Cypher Export for Neo4j

Export graph diagrams to Neo4j Cypher DDL. Generate node constraints, relationship definitions, and property indexes for deployment to Neo4j databases.