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
).
Technology | Web Support | CLI Support | Identifier |
---|---|---|---|
PostgreSQL | ✅ | ✅ | postgresql |
Ruby on Rails | ✅ | ✅ | schemarb |
Prisma | ✅ | ✅ | prisma |
tbls | ✅ | ✅ | tbls |
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
orSchemafile
are assumed to be inschemarb
format. - File Extension Check: Files ending in
.rb
are treated asschemarb
, while files ending in.sql
are treated aspostgresql
. - 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.