A diagram is most useful when it can become real tables. Schemity exports your ERD as DDL - the CREATE statements that build the schema in your database.

Export formats

From the export menu you can save the current diagram as:

  • PNG - a raster image with transparency.
  • JPEG - a smaller raster image.
  • SVG - vector output with selectable text that scales infinitely.
  • SQL - a plain-text file of all the CREATE statements for the whole diagram.

Generating DDL

Choose the SQL export to generate engine-aware DDL for the connection’s database type, emitting:

  • CREATE TABLE statements with columns, types, and nullability
  • Primary keys, including composite keys
  • Foreign keys that match your relationships
  • Unique and check constraints, and indexes

Engine-aware output

The output respects your target engine. Data types, default-value syntax, and constraint formatting follow PostgreSQL, MySQL, SQL Server, or SQLite conventions, so the SQL is ready to run on the database you actually use.

Works offline

DDL generation does not need a live connection. Even a diagram you designed with Conn method: None exports a complete SQL script you can run elsewhere - a fresh environment, a test database, or a new service.

Keep the SQL in Git too

Commit the generated SQL alongside the JSON diagram. Reviewers then see both the visual change and the exact SQL in the same pull request.

Next

Evolve an existing database safely with Migration SQL Diff.