Skip to content

PinakSalunke99/visual-sql-query-builder

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

17 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

# Visual SQL Query Builder

## Overview

Visual SQL Query Builder is a web application that allows users to construct SQL queries using a drag-and-drop interface without manually writing SQL syntax.

The system dynamically generates SQL queries and executes them on the backend, displaying results in a structured table format.

Application Preview

SQL Query Builder UI

## Technologies Used

Frontend:

- React.js

- DnD-Kit

- Axios

- HTML / CSS

Backend:

- Python

- Flask

- SQLite

## Features

- Drag-and-drop SQL query construction

- Automatic SQL query generation

- Schema discovery from database

- Real-time query execution

- Result visualization in table format

## Architecture

Frontend: React UI for building query blocks

Backend: Flask API that converts JSON commands into SQL queries

Database: SQLite database with sample academic schema

## How to Run

### Backend

cd sql\_builder\_backend

python app.py

About

Drag-and-drop visual SQL query builder built with React and Flask

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors