SQL Vision is a tool that leverages image analysis and data processing to generate SQL queries from images. It extracts key details from images, creates SQL table creation queries, and offers a user-friendly interface for data input.
- Convert images into SQL table creation queries.
- Extracts relevant data from images for table columns.
- User-friendly interface for data type and constraint input.
- Interactive table display to facilitate data manipulation.
- Generates SQL queries for table creation and data insertion.
- Download The zip file from the link provided in the About Section of this repo
- Unzip the file and run the 'SQL Vision.exe' file
- Follow the prompts to provide the path to the image and input table details.
- Review and modify the extracted data as needed.
- The tool will generate CREATE TABLE and INSERT INTO queries based on your input.
Perfect Data Extraction
Welcome to SQL Vision
Enter the Path of the Image : Test Images\Image_Test_2.png
Enter the table name : EMPLOYEE
EMPNO:-
Data Type : varchar(5)
Constraint : primary key
EMP_NAME:-
Data Type : varchar(20)
Constraint : not null
DEPT:-
Data Type : varchar(20)
Constraint :
SALARY:-
Data Type : float
Constraint :
DOJ:-
Data Type : Date
Constraint :
BRANCH:-
Data Type : varchar(20)
Constraint :
┌───────┬──────────┬────────────┬────────┬─────────────┬───────────┐
│ EMPNO │ EMP_NAME │ DEPT │ SALARY │ DOJ │ BRANCH │
╞═══════╪══════════╪════════════╪════════╪═════════════╪═══════════╡
│ E101 │ Amit │ Production │ 45000 │ 12-Mar-2000 │ Bangalore │
├───────┼──────────┼────────────┼────────┼─────────────┼───────────┤
│ E102 │ Amit │ HR │ 70000 │ 03-Jul-2002 │ Bangalore │
├───────┼──────────┼────────────┼────────┼─────────────┼───────────┤
│ E103 │ Sunita │ Management │ 120000 │ 11-Jan-2001 │ Mysore │
├───────┼──────────┼────────────┼────────┼─────────────┼───────────┤
│ E104 │ Sunita │ IT │ 670000 │ 01-Aug-2001 │ Mysore │
├───────┼──────────┼────────────┼────────┼─────────────┼───────────┤
│ E105 │ Mahesh │ Civil │ 145000 │ 13-Sep-2003 │ Pune │
├───────┼──────────┼────────────┼────────┼─────────────┼───────────┤
│ E106 │ Kavya │ Management │ 110000 │ 15-Jan-2001 │ Null │
└───────┴──────────┴────────────┴────────┴─────────────┴───────────┘
If you are satisfied with the table click 'Enter'
If not enter the cell coord you wish to alter
Coordinates (seperated by a comma) :
CREATE TABLE QUERY:-
CREATE TABLE EMPLOYEE (EMPNO varchar(5) primary key, EMP_NAME varchar(20) not null, DEPT varchar(20) , SALARY float , DOJ Date , BRANCH varchar(20) );
FILL TABLE QUERY:-
INSERT INTO EMPLOYEE (EMPNO, EMP_NAME, DEPT, SALARY, DOJ, BRANCH) VALUES ('E101', 'Amit', 'Production', 45000, '12-Mar-2000', 'Bangalore'), ('E102', 'Amit', 'HR', 70000, '03-Jul-2002', 'Bangalore'), ('E103', 'Sunita', 'Management', 120000, '11-Jan-2001', 'Mysore'), ('E104', 'Sunita', 'IT', 670000, '01-Aug-2001', 'Mysore'), ('E105', 'Mahesh', 'Civil', 145000, '13-Sep-2003', 'Pune'), ('E106', 'Kavya', 'Management', 110000, '15-Jan-2001', Null);
Contributions are welcome! If you find any issues or have suggestions, feel free to open an issue or submit a pull request.
This project is licensed under the MIT License.