💾 db-erd-gen

✏️ Free DrawSQL like website but free forever

URL: https://db-erd-gen.vercel.app/

💡 Features

1. Free forever and open sources.
2. Save SQL in various DB format.
3. Easy to use / store GUI website.
4. Low learning curve UI.
5. No server involved, all in local.

🔊 Current supported output

• Postgres raw
• MySQL / MariaDB raw
• SQLite raw
• knex.js
• kysely ts types
• kysely Postgres
• kysely sqlite
• Typescript types
• Zod scheme types
• Yup scheme types
• Valibot scheme types
• Prisma Postgres
• Prisma MySQL
• Drizzle ORM (Postgres)
• Drizzle ORM (MySQL)
• Drizzle ORM (sqlite)
• Sequelize (Postgres, MySQL, sqlite) (Thanks roshangautam07)
• Mongoose Scheme (TBC)

🗺️ Roadmap

• ✅ With Zod type checking
• ✅ Update Maininte to v7
• ✅ Drizzle ORM Support
• ⬜️ i18n adapts
• ⬜️ Allow to dup table

📝 Todo

• ✅ Support kysely db migrate types output
• ✅ Support kysely ts types output
• ✅ Support SQLite types output
• ✅ Support MySQL / MariaDB types output
• ✅ Support typescript normal types
• ✅ Support zod types generate
• ✅ Support Tables CRUD code for several frameworks
• ✅ Support Drizzle ORM types output
• ⬜️ Add enums options and input for enums
• ⬜️ Support defaultTo string in general
• ⬜️ Support defaultTo string in kysely
• ✅ Support Prisma types output
• ✅ Add UNIQUE types
• ✅ Support sqlite types output
• ⬜️ More features
• ✅ Update UI
• ⬜️ Testing vitest

🏠 Self hosting (Nodejs base)

1. Clone the project to your environment.

git clone https://github.com/r48n34/db-erd-gen.git

2. Install packages with npm / yarn.

# Install with yarn for samples
yarn

3. Start the project with dev mode.

# Start with dev
yarn dev

4. Build the project.

# Build to production
yarn build

5. Preview the build project.

yarn preview

🐳 Self hosting (Docker)

1. Build the docker container with the following command.

docker build . -t db-erd-gen

2. After builded, run the container.

docker run -d -p 5174:5174 db-erd-gen:latest

🚗 License

Distributed under the MIT License.