WWW SQL Designer allows users to create database models directly in their browser, without the need for local tools.
The original WWW SQL Designer was created by Ondrej Zara and is built atop the oz.js JavaScript module. It is distributed under the BSD 3-clause license and available here: https://github.com/ondras/wwwsqldesigner
This repository replaces the backend with a .NET 6 / EF Core version and expands the featureset.
- Clone the repository
- Open the solution in Visual Studio
- Run it. By default, it will create a LocalDB instance and deploy the DB schema via Entity Framework
Note that the auto-creation of a database and schema only works with LocalDB in a Development environment. When you're setting up a CI/CD pipeline for Test and Production environments, please include a dotnet ef migrations bundle step to hanlde DB migrations.
- Full-feature ER diagrams
- Comments per table and column
- Creation of SQL DDL scripts based on the data model (full script only, no migrations)
- Save and load models from a database
- The DB connection is based on Entity Framework Core, so supports LocalDB (for development), MSSQL, PostgreSQL, etc.
- Data model versioning
- Easier way to load data model versions
- Export to Entity Framework classes, not just SQL DDL
- Capture of data classifications per column
- Capture of records retention schedule per column
- Expanding the SQL import feature to support more than an import from a local MySQL DB
- User roles and permissions