Free, simple, and intuitive online database diagram editor and SQL generator.
JavaScript databasedatabase-designdatabase-diagramdatabase-schemadbmldiagram-editoreditorer-diagramerderdiagramindexeddbmariadbmcporacle-databaseoracle-dbpostgresqlschema-designsqlsql-serversqlite
import { DB } from "../../data/constants";
import { toMariaDB } from "./mariadb";
import { toMSSQL } from "./mssql";
import { toMySQL } from "./mysql";
import { toOracleSQL } from "./oraclesql";
import { toPostgres } from "./postgres";
import { toSqlite } from "./sqlite";
export function exportSQL(diagram) {
const sql = schemaSQL(diagram);
const header = diagram.sqlHeader?.trim();
return header ? `${header}\n\n${sql}` : sql;
}
function schemaSQL(diagram) {
switch (diagram.database) {
case DB.SQLITE:
return toSqlite(diagram);
case DB.MYSQL:
return toMySQL(diagram);
case DB.POSTGRES:
return toPostgres(diagram);
case DB.MARIADB:
return toMariaDB(diagram);
case DB.MSSQL:
return toMSSQL(diagram);
case DB.ORACLESQL:
return toOracleSQL(diagram);
default:
return "";
}
}