8 open-source alternatives ranked by real activity

Open-source erwin Data Modeler alternatives

A curated, ranked list of the 8 best open-source alternatives to erwin Data Modeler.

The best open-source alternative to erwin Data Modeler is DBeaver. If that doesn't suit you, other good options are drawDB, ChartDB, MySQL and HeidiSQL.

Commercial alternatives to erwin Data Modeler include ER/Studio, DbSchema, SqlDBM and Hackolade. See all 16.

erwin Data Modeler alternatives are mainly database tools, but some are also databases and documentation & wiki tools. 8 of them shipped code in the last 30 days, 8 can be self-hosted, and 2 use a permissive licence.

Last updated November 13, 2026 · ranked by GitHub stars, growth and recent commits

DBeaver

A free multi-platform desktop database tool and SQL client for developers, DBAs and analysts, supporting over 100 databases through JDBC and ODBC drivers.

GitHub stars
52k
Last commit
today
Latest release
26.2.4
Licence
Apache-2.0
Self-hosted
Yes
dbeaver.ioDBeaver homepage screenshot

DBeaver is a free, multi-platform database tool aimed at developers, SQL programmers, database administrators and analysts. A single desktop application lets you browse schemas, write and run SQL, edit data and administer many different database systems, instead of switching between vendor-specific clients.

Its feature set covers a schema editor, an SQL editor, a data editor, ER diagrams, data export, import and migration, SQL execution plans, administration tools, database dashboards, a spatial data viewer, proxy and SSH tunneling, and an editor for custom database drivers. An AI chat integrates AI tools for working with data, SQL and database structure. More than 100 drivers are supported out of the box, and anything with a JDBC or ODBC driver can be connected.

DBeaver is a Java application, with OpenJDK included in all distributions so no separate Java install is needed. It is Apache-2.0 licensed and can be downloaded as prebuilt binaries from the website or GitHub releases, with an Early Access build published daily. The vendor also sells paid editions with additional capabilities.

Key features

  • SQL editor with execution plans
  • Schema editor and ER diagrams
  • Data editor with export, import and migration
  • 100+ database drivers plus any JDBC or ODBC source
  • SSH tunneling and proxy support
  • Built-in AI chat for SQL and data
  • Database dashboards and spatial data viewer

Pricing: The Community Edition is free and open source under Apache-2.0; the vendor also sells paid editions.

Read more about DBeaverWebsiteGitHub#1 erwin Data Modeler alternative

drawDB

A free browser-based editor for drawing database entity-relationship diagrams and generating SQL, with import and export of scripts and no account required.

GitHub stars
40k
Last commit
yesterday
Latest release
v1.9.0
Licence
AGPL-3.0
Self-hosted
Yes
Hosted version
Available
drawdb.appdrawDB homepage screenshot

drawDB is a free, browser-based database schema editor and SQL generator. You build entity-relationship diagrams with a few clicks, and it works without creating an account, which makes it quick to sketch a data model before writing any code.

Diagrams can be exported to and imported from SQL scripts, and the tool can generate migrations. Topics show support for dialects including MySQL-family databases such as MariaDB, PostgreSQL, SQL Server, SQLite and Oracle, and diagrams are kept in the browser using IndexedDB. The editor is customizable, and the app is written in JavaScript.

drawDB is AGPL-3.0 licensed. The public version runs at drawdb.app, and you can also build it locally or with Docker to host it yourself. Sharing diagrams is optional and requires setting up a small server using the provided environment sample; with the Docker image you pass the server URL at startup, with no rebuild needed. It suits developers and students designing relational schemas.

Key features

  • Visual ER diagram editor in the browser
  • SQL script export and import
  • SQL migration generation
  • Multiple SQL dialects supported
  • No account required
  • Docker build for self-hosting

Pricing: The drawDB editor is free and open source with no account needed. Solo Pro and Team Pro add cloud sync, collaboration and AI, but their prices are not shown on the page.

Read more about drawDBWebsiteGitHub#2 erwin Data Modeler alternative

ChartDB

A web-based database diagram editor that imports your schema with one query, lets you edit entity-relationship diagrams and exports SQL, with no account required.

GitHub stars
23k
Last commit
12 days ago
Latest release
v1.21.0
Licence
AGPL-3.0
Self-hosted
Yes
Hosted version
Available
chartdb.ioChartDB homepage screenshot

ChartDB is an open-source database diagramming editor that runs in the browser. Its signature feature is a Smart Query: you run one query against your database, paste the resulting JSON schema into ChartDB, and your tables and relationships are visualized instantly, with no installation and no database password shared with the tool.

From there you can edit the diagram interactively and export it, and an AI-powered export generates DDL scripts in the SQL dialect of your choice, which helps when moving between engines, such as MySQL to PostgreSQL or SQLite to MariaDB. The diagrams are useful for documentation, team discussions and understanding an unfamiliar database. Topics show support for MySQL, PostgreSQL, SQLite, SQL Server and MariaDB, and the app is built with React and TypeScript.

ChartDB is AGPL-3.0 licensed. You can use the hosted editor at chartdb.io, which works without an account, or self-host the open-source code. It suits developers, data engineers and students who need quick schema visualizations and migration scripts without setting up heavy modeling software.

Key features

  • One-query schema import as JSON
  • Interactive ER diagram editing
  • AI-assisted DDL export across SQL dialects
  • No installation or database password required
  • Supports MySQL, PostgreSQL, SQLite and SQL Server
  • No account needed

Pricing: A free plan covers one user. Pro is $25 per month for one person and Teams starts at $59 on its Basic tier; yearly billing is up to 40% cheaper and the Custom plan is quoted by sales.

Read more about ChartDBWebsiteGitHub#3 erwin Data Modeler alternative

MySQL

Source repository of the MySQL relational database server, covering the open-source Community edition and the clustered MySQL Cluster variant.

GitHub stars
13k
Last commit
16 days ago
Self-hosted
Yes
Hosted version
Available
mysql.comMySQL homepage screenshot

MySQL is a widely used open-source relational database. This repository contains the MySQL Server source code along with MySQL Cluster, which the description presents as a real-time, open-source transactional database. Applications talk to it using SQL, and it is a common choice for web applications and embedded products.

The MySQL website describes several offerings built around the server: the Community Edition, with a published governance model and early access builds; MySQL Enterprise Edition for advanced features, management tools and technical support; MySQL HeatWave, a cloud service that combines transactions with analytics and machine learning; and MySQL Cluster CGE. A program for OEM and ISV vendors covers embedding the database in other products.

The server is written in C++ and distributed under licenses detailed in the repository. Organizations can run the Community Edition on their own infrastructure, buy a commercial edition from Oracle, which owns the project, or use a managed cloud offering. Documentation, downloads and a developer zone are available on mysql.com.

Key features

  • Open-source relational database server
  • SQL query interface
  • MySQL Cluster for transactional workloads
  • Community and Enterprise editions
  • HeatWave managed cloud option
  • Documentation and developer resources

Pricing: Community Edition is open source; Enterprise Edition and the HeatWave cloud service are commercial offerings.

Read more about MySQLWebsiteGitHub#4 erwin Data Modeler alternative

HeidiSQL

HeidiSQL is a free client for connecting to and editing data and structures in MariaDB, MySQL, Microsoft SQL Server, PostgreSQL, SQLite, Interbase and Firebird databases.

GitHub stars
6.3k
Last commit
2 days ago
Latest release
v12.22
Licence
GPL-2.0
Self-hosted
Yes
heidisql.comHeidiSQL homepage screenshot

HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. It lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once connected, you can edit data and structures in these databases.

Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and MySQL, and actively maintained. The Windows version is built with Delphi 12.3, while Lazarus v4.4 is used for compiling the Linux and macOS releases.

Key features

  • Connect to MariaDB, MySQL, Microsoft SQL Server, PostgreSQL, SQLite, Interbase and Firebird
  • Edit data and structures in connected databases
  • Create tables, views, stored procedures, triggers, and scheduled events
  • Run SQL queries and export/import data
  • Portable version available
Read more about HeidiSQLWebsiteGitHub#5 erwin Data Modeler alternative

Liam ERD

Liam ERD generates interactive entity relationship diagrams from your database schema, with zoom, pan and filtering for exploring complex structures.

GitHub stars
5.2k
Last commit
yesterday
Latest release
@liam-hq/cli@0.7.24
Licence
Apache-2.0
Self-hosted
Yes
Hosted version
Available
liambx.comLiam ERD homepage screenshot

Liam ERD turns an existing database schema into a clear, interactive entity relationship diagram. It is meant for developers and teams who need to understand or document a database without drawing the diagram manually, and it works with both public and private repositories.

The interface supports panning, zooming and filtering so even complex schemas stay readable, and it reverse-engineers diagrams directly from your schema with little setup. Repository topics list PostgreSQL, Prisma, Ruby on Rails, tbls and SQL as input sources, with React Flow used for rendering. A command-line package is published for generating diagrams locally, and the project provides documentation and a roadmap.

Liam is written in TypeScript and licensed under Apache-2.0. You can run the CLI yourself, and the project's website also offers a hosted way to view diagrams. It suits engineering teams who want schema documentation that stays in sync with the code.

Key features

  • Interactive ER diagrams from existing schemas
  • Panning, zooming and filtering
  • Reverse engineering with minimal setup
  • Works with PostgreSQL, Prisma and Rails schemas
  • Command-line package for local use
  • Open-source TypeScript codebase

Pricing: Free and open source under the Apache-2.0 license.

Read more about Liam ERDWebsiteGitHub#6 erwin Data Modeler alternative

pgModeler

pgModeler is a locally installed PostgreSQL schema design tool with reverse engineering, diffing and a command-line interface.

GitHub stars
3.6k
Last commit
8 days ago
Latest release
v2.0.0
Licence
GPL-3.0
pgmodeler.iopgModeler homepage screenshot

pgModeler is a multi-platform PostgreSQL schema engineering tool that is installed locally and designed to work with Git. You design schemas visually, reverse-engineer production databases, diff and sync across environments, and automate deployments through a CLI.

The site states there is no cloud dependency, no telemetry and no lock-in, with schemas kept in open files on your machine. It is offered as community and commercial editions that share the same core features. The paid pgModeler Plus adds pre-built binaries and workflow features such as versioning and an SSH tunnel plugin.

The stable release shown is 1.2.3 from February 2026, and a 2.0.0 beta line is available. The project is maintained by Nullptr Labs under the GPL-3.0 licence, and academic students are offered 50% off Plus.

Key features

  • Visual schema design for PostgreSQL
  • Reverse engineering of existing databases
  • Local use with no cloud dependency or telemetry
  • Plus edition adds Git versioning and SSH tunnel plugins
  • Beta adds support for PostgreSQL 18 temporal keys
Read more about pgModelerWebsiteGitHub#7 erwin Data Modeler alternative

Schemacrawler

SchemaCrawler is a free tool for discovering and comprehending database schemas, supporting output in multiple formats and schema diagram generation.

GitHub stars
1.8k
Last commit
3 days ago
Latest release
v18.0.2
Self-hosted
Yes
schemacrawler.comSchemacrawler homepage screenshot

SchemaCrawler is a free database schema discovery and comprehension tool. It allows users to search for database schema objects using regular expressions and output the schema and data in a readable text format. The output is designed to be diff-ed against other database schemas and serves for database documentation.

SchemaCrawler also generates schema diagrams and supports executing scripts in any standard scripting language against a database. It can find potential schema design issues with lint and rank tables and views by graph metrics and importance. The tool supports almost any database with a JDBC driver and works on any operating system that supports Java SE 17 or better.

Key features

  • Search for database schema objects using regular expressions
  • Output schema and data in readable text format, HTML5, JSON, or YAML
  • Generate schema diagrams
  • Execute scripts in any standard scripting language against the database
  • Find potential schema design issues with lint
  • Rank tables and views by graph metrics and importance
Read more about SchemacrawlerWebsiteGitHub#8 erwin Data Modeler alternative

Commercial erwin Data Modeler alternatives

Hosted, closed-source products that compete with erwin Data Modeler. Showing 12 of 16.

See every erwin Data Modeler alternative on its tool page

erwin Data Modeler alternatives: questions

What is the best open-source alternative to erwin Data Modeler?
DBeaver is the top-ranked open-source alternative to erwin Data Modeler on Enlisted: A free multi-platform desktop database tool and SQL client for developers, DBAs and analysts, supporting over 100 databases through JDBC and ODBC drivers. Other strong options are drawDB, ChartDB, MySQL and HeidiSQL.
What are the best commercial alternatives to erwin Data Modeler?
ER/Studio, DbSchema, SqlDBM, Hackolade and DrawSQL are among the hosted, closed-source alternatives to erwin Data Modeler listed on Enlisted, which lists 16 in total. Compare their pricing and features on each tool page.
Are these erwin Data Modeler alternatives free?
All 8 are open source, so the code is free to use under its licence, and all of them can be self-hosted on your own server or computer. 4 also offer a paid or managed cloud version if you'd rather not host it yourself.
How is this list of erwin Data Modeler alternatives ranked?
By a score built from GitHub stars, star growth over the last 30 days and how recently the code changed. 8 of these projects shipped code in the last 30 days. Data is refreshed daily, and nobody can pay to move up.

People also look for alternatives to…

View all