WWW SQL Designer allows users to create database designs, which can be saved/loaded and exported to SQL scripts. Various databases and languages are supported. Ability to import existing database design.
Many database features are supported, such as keys, foreign key constraints, comments and indexes. You can either save your design (for further loading & modifications), print it or export as SQL script. It is possible to retrieve (import) schema from existing database.
If you wish to support this project, at PayPal!
npm install http-server -g
http-serverin the root of this repo to start a simple http server
- Visit http://127.0.0.1:8080
docker build -t wwwsqldesigner .
docker run -d -p 8080:8080 wwwsqldesigner
- Visit http://127.0.0.1:8080
Please use the following auto formatters to maintain the code style
||VSCode built-in formatter|
||4 spaces for tabs||https://marketplace.visualstudio.com/items?itemName=esbenp.prettier-vscode|
Moved to GitHub
Google Code is closing down, we are now completely migrated to GitHub.
Experimental real-time collaboration version
Thanks to Bharat Patil: http://bharat.whiteboard.jit.su/
Version 2.7 was released on 3.8.2012. This is mainly a bugfix release, although several new features (most notable localStorage support) are present.
Version 2.6 was released on 22.9.2011. Several new translations (pt_BR, sv, ar) added; VML removed; new visualization options available (show length and datatype); new DBs and backends; support for touch devices...
Experimental clone with deletion of saved designs
New optional patch
A new patch, which enable optional display of field details, was submitted by Wilson Oliveira. While this code is not ready yet to be commited into repository, everyone can download it from http://ondras.zarovi.cz/sql/wwwsqldesigner-inline_field_details_patch.zip.
Support for CUBRID
WWW SQL Designer now supports the CUBRID database: both as a backend (using PHP) as well as datatype definition set.
Version 2.5 was released on 18.6.2010. Many new features were added (hiding of sidebar, colored relation, multi-selection and multi-drag, ...), tons of bugs were fixed.
Version 2.4 was released on 5.11.2009. Several outstanding issues were fixed and new locales added.
Version 2.3.3 was released on 28.7.2009. This long-awaited release includes numerous fixes, compatibility improvements, new locales, backends and DB datatypes.
Version 2.3.2 was released on 8.1.2009. Apart from some traditional bugfixes and locales, a new functionality is introduced - the ability to mark foregin keys between existing table fields!
The project was recently moved to Google Code hosting, which (amongst many other things) introduces Subversion hosting. Enjoy! (The old website, http://ondras.zarovi.cz/sql/, will still exist for some time.)
2.0 is here
Good news: A new version of WWW SQL Designer, rewritten from scratch, is now available. It has many new features, including bezier connectors, support for various customizations, localization, options and more.
Bad news: This new version is not backwards compatible with 1.x, so all old localizations and XSLT templates won't work with 2.x. Sorry for inconvenience :/