The Database Schema Constructor is a web application for visually creating and manipulating database schemas. It allows users to add tables, define attributes, and set constraints like NOT NULL, UNIQUE, PRIMARY KEY, AUTO_INCREMENT and FOREIGN KEY. Features include SQL query generation and download, draggable tables for layout flexibility, and responsive design. Schemas can be persisted in local storage for future sessions.
- Visual Database Design: Add, edit, and remove tables and attributes.
- Attribute Constraints: Direct UI definition of attribute constraints.
- SQL Generation: Generate SQL queries for the schema.
- Download SQL: Download the schema as an SQL file.
- Draggable Tables: Reorganize tables on the screen on larger screens.
- Responsive Design: Ensures usability across devices.
- Local Storage: Schema persistence across sessions.
- Cloud Storage: Save Schemas to the cloud.
Before you begin, ensure you have the latest version of Node.js and npm installed on your system.
- Clone the repository:
git clone https://github.com/ahmad-masud/Database-Schema-Constructor
- Navigate to the project directory:
cd ahmad-masud.github.io - Install dependencies:
npm install
- Start the development server:
This command runs the app in development mode. Open http://localhost:3000 to view it in your browser.
npm start
- Creating a Table: Use the "Add Table" button.
- Editing: Use edit icons for tables or attributes.
- Downloading SQL: Use the "Download SQL" button.
- Clearing Schema: Use the "Delete Database" button.
- Login in with Google Use the "Login" button.
- Saving to the cloud with Google: Use the "Save Database" button.
- Loading from the cloud with Google: Use the "Modify Databases" button.
Contributions are welcome. Please fork the project, create your feature branch, commit your changes, push to the branch, and open a pull request.
Distributed under the MIT License. See MIT License for more information.