Skip to content

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

MySQL Query Builder

A lightweight, web-based tool designed to simplify database design and automatically generate MySQL code. Originally built as a practice project for MySQL, this tool provides a visual interface to define databases, set up tables, and insert rows without writing the boilerplate SQL syntax manually.

Features

  • Visual Setup: Define your database name and table name in a straightforward interface.
  • Dynamic Column Generation: Specify the number of columns you need, assign names, and the tool will automatically validate the input (ensuring names only contain letters, numbers, and underscores).
  • Data Entry: Add data rows directly through the interface based on the columns you defined. You can also view and remove added rows before generating the final code.
  • Instant SQL Generation: Compiles your inputs into clean, ready-to-use MySQL commands, including CREATE DATABASE, USE, CREATE TABLE, and INSERT INTO statements.
  • Quick Copy: One-click copy functionality to easily transfer the generated SQL to your database client or terminal.

Tech Stack

  • HTML5: Semantic structure and layout.
  • CSS3: Custom styling with CSS Grid and Flexbox for a responsive, dark-themed UI.
  • Vanilla JavaScript: Handles all DOM manipulation, validation logic, and state management without any external dependencies.

Usage

Just visit here.

About

A Simple tool to generate SQL code using graphical user interface

Topics

Resources

Stars

Watchers

Forks

Contributors

Languages