< We're launched Liam ERD!

Learn More

Supported Formats

Legend

  • ✅: Supported
  • ⚡: Supported via workaround
  • ⛔: Not in progress
  • ⌛️: In progress

Below is a list of currently supported (or planned) formats and integrations.

  • Web Support: Support status for the web version.
  • CLI Support: Support status for the CLI version. ⚡ indicates support through workarounds (e.g., using pg_dump or tbls).
  • Identifier: Used for specifying the format in the CLI (via --format=postgresql) or as a web query parameter (e.g., ?format=schemarb).
TechnologyWeb SupportCLI SupportIdentifier
PostgreSQLpostgresql
Ruby on Railsschemarb
Prismaprisma
tblstbls
Drizzle-
MySQL-
SQLite-
BigQuery-

For CLI support marked with ⚡, you can use the following workarounds:

  • Generate a PostgreSQL file using pg_dump (see instructions), then process it with the postgresql format
  • Generate a schema.json using tbls (see instructions), then process it with the tbls format

Format Auto-Detection

Liam ERD automatically attempts to determine the schema format for both Web and CLI versions. The detection process works as follows:

  • File Name Check: Filenames such as schema.rb or Schemafile are assumed to be in schemarb format.
  • File Extension Check: Files ending in .rb are treated as schemarb, while files ending in .sql are treated as postgresql.
  • For more details, refer to the detectFormat.ts file in our GitHub repository.

If the automatic detection does not match your desired format, you can specify it manually:

  • Web: Use the format query parameter (e.g., ?format=schemarb)
  • CLI: Use the --format option (e.g., --format=schemarb)

If there's another database schema or ORM you'd love to see supported, please let us know in the GitHub Discussions.

On this page