Import & Export

Sqemo is not a silo. Schemas come in from the databases you already have and go out to the formats your pipeline expects.

SQL DDL

Import CREATE TABLE DDL and export it back in seven dialects: MySQL, PostgreSQL, Oracle, SQL Server, SQLite, H2, and CUBRID.

On import, primary keys, foreign keys (including inline REFERENCES column constraints), and comments are recognized — foreign keys become relationship lines on the canvas. Import and export operate on the physical model.

DBML

DBML imports and exports round-trip, so you can move between Sqemo and text-first tools like dbdiagram without retyping a schema.

Project files (.erd.json)

The project file carries everything: logical and physical models, the glossary, naming rules, and the schema version. It is a plain JSON file — commit it to your repo, diff it in review, send it to a colleague. The MCP server and CLI operate on the same format.

Images

Export the canvas as a PNG for design docs and reviews.

From the command line

The CLI (part of the MCP package, no login required) exports a project file without opening the app:

npx sqemo-mcp export schema.erd.json --format sql --dialect postgres > schema.sql
npx sqemo-mcp export schema.erd.json --format dbml > schema.dbml