This project is created by Ajnas N B
SQL Magic is a powerful query generator designed to create SQL queries based on the questions you ask. With the ability to understand context and intention, it can effortlessly generate complex SQL queries with just a few prompts.
Simply ask SQL Magic a question in natural language, and it will analyze the question to determine the appropriate SQL query. For example, you can ask:
"Write a query to fetch only the place name (string before brackets) from the Address column of EmployeeInfo table."
And SQL Magic will generate:
SELECT SUBSTRING_INDEX(Address, '(', 1) AS PlaceName FROM EmployeeInfo;
For more information and to try it out, visit https://sqlmagic.ajnasnb.me
To get SQL Magic up and running on your machine, follow these steps:
Ensure you have Node.js (v14+) and npm (v6+) installed.
-
Clone the SQL Magic repository:
git clone https://github.com/AjnasNB/sql-magic.git
-
Navigate to the SQL Magic directory and install dependencies:
cd sql-magic npm install
-
Start the application to interact with SQL Magic locally:
npm start
Using SQL Magic is as straightforward as its setup:
- Launch SQL Magic in your browser.
- Input a natural language query into the provided text field.
- Press the "Generate Query" button to receive an SQL query based on your input.
Contributions to SQL Magic are warmly welcomed. Whether its feature requests, bug fixes, or code contributions, please feel free to make your mark on this project.
To contribute:
- Fork the repository.
- Create a new branch (
git checkout -b feature/AmazingFeature
). - Commit your changes (
git commit -m 'Add some AmazingFeature'
). - Push to the branch (
git push origin feature/AmazingFeature
). - Open a pull request.
SQL Magic is made available under the MIT License. For more details, see the LICENSE file.
Ajnas N B - @Linkdin - creator and maintainer
Project Link: https://github.com/AjnasNB/sql-magic
- Node.js and npm for the runtime and package management.
- All open-source projects and contributors that assist in developing SQL Magic.