tomjschuster/sequelize-ui

TypeScript code generator for Sequelize ORM

Sequelize UI

https://sequelizeui.app/

Sequelize UI is a Sequelize ORM code generator, which generates a full Node.js TypeScript project, entirely in the browser. Use the schema editor to design your database tables, fields and associations, then preview the Sequelize models and migrations in the code viewer before downloading the project as a zip file or copying code from individual files.

You can customize the generated Sequelize code with the following database configurations:

• PostgreSQL, MySQL, MariaDB, SQLite or Microsoft SQL Server dialects.
• Singular or plural table names
• camelCase or snake_case table and column names.
• Table name prefixed primary keys or plain id primary keys.
• Created/updated timestamps or no timestamps.

Usage

To use Sequelize UI, either go to https://sequelizeui.app or run the project locally with:

npm ci
npm run build
npm npx serve@latest out

Then go to http://localhost:3000

Plain JavaScript

Sequelize UI currenly only generates TypeScript Sequelize code, however, an older version is still available at https://js.sequelizeui.app/ which generates plain JavaScript Sequelize code. Future support for JavaScript is planned and can be tracked in tasks.md.

sequelize-ui's Issues

Not able to view ui once server is started on localhost:3001

sudo npm start

[email protected] start /sequelize-ui
node server
Server listening on 3001...

Add paranoid property in model

Although this is not a critical function, I think it would be important to add the paranoid property to the model

Support for uploading SQL to generate models

We need this feature to allow uploading .sql file from already created database to generate models, and migration.

While Sequelize Auto has this features but dosen't provides migration files also

the project always is reloading

Hi, i recently clone this repository, well i decide to play a little bit with the UI but every time i select something the website reload, view code or add a new column the website reload so i check the terminal, it always said that "change detected" and reload.

Add default value to field

while designing schema some time we need to have default values for a field. which is missing in schema design tool

Difference migration feature request

App is migrating everything as combined currently. My feature request is separated migrations. For example I created new scheme and it created migrations it's ok. After that if i add new field in model it needs to create new migration.

Maybe one more button needs like "Save Migration". If you click save button migrations appear combined. If you click migrate button it create new migration according to the difference with the last changes. Because as you know after start the project we can not changes migrations only we can add new ones for changes.

Default value feature

Operations may be easier if the ability to assign default values ​​to fields in models is added.

Adding question mark to optional TS Declares

When a field is not necessarily selected, typescript can be supported by adding a question mark to its type.

Old
declare targetUrl: string | null

New
declare targetUrl?: string | null

Like this

Fullstack Academy link on YouTube is wrong... 404 error...

The Fullstack Academy video of this project has a bad URL in the video description.

Fullstack Academy video:
http://youtu.be/gpu_tnBb0q0

Incorrect link in description:
http://github.com/tomjschuste

Note that it is missing the final 'r'.

Hopefully, you are able to contact them and get this resolved so that you don't lose too many visitors.

Upload db.zip that I've downloaded before?

Thanks for the amazing tool!

Is there any way we can upload back the db.zip file that we have created before? I saw an upload button, but not working