Visual Alchemist

Database diagramming and automation tool

Visual Alchemist is an open source, web-based database diagramming tool. It can be used to define data tables, drag and drop them in an HTML canvas and export the whole thing as code to a suitable SQL dialect such as mysql or sqlite, or an ORM. It is more suitable to use this app on a slightly larger mobile device (such as tablets or 5.5-6" phones).

Features include:

=> Create tables structures and relationships and represent them as elements on canvas.

=> Drag/Drop the elements on canvas.

=> Export the canvas as a json file (coming soon).

=> Import the canvas from existing json file (coming soon).

=> Export the database as python-sqlalchemy ORM code.

=> Export the database as raw sql code (mysql dialect).

=> Export the database as raw sql code (sqlite dialect).

=> Support for composite primary keys.