Query SQL Tables using Natural Language, without writing a query

• Description
• Dependencies
• Installation
  • Prerequisites
  • Instructions
• Usage
• License

easySQL automates the process of using Natural Language to conduct queries on Relational databases. It supports Speech-to-text and around 30 Languages.

Named Entity Recognition using node-nlp for tagging query intent, tables and metadata. Supports multiple query statements.

Speech-to-text option available for querying tables directly through voice.

Supports detection of input language and translation to English. Supports around 30 languages including Hindi.

Option to download SQL tables in csv format.

FAQ chatbot to help user get acquainted with the app.

Visualization of SQL tables using Plotly. Compare column v/s column and plot it using various charts. Option to edit and download plots in png format.

Stores successful user entered queties, both text and SQL query.

• npm
• Express.js
• MySQL
• XAMPP
• React.js
• Plotly

Install Node.js and npm using the link above. Follow instructions on their respecive websites. Npm is included with Node.js. Setup XAMPP server and load the database into MySQL tables. Copy the MySQL credentials and paste them appropriately in the .env file.

Clone the repository

git clone https://github.com/amurto/easySQL.git

Install all the dependencies on backend server

cd backend 
npm install

Install all the dependencies on frontend

cd frontend
npm install

Run the admin server on port 5000

cd backend
npm start

Run the farmer client

cd frontend
npm start

Open a web browser and go to

http://localhost:3000

MIT License Link