Repository files navigation

This project is an AI-powered SQL Query Generator that translates natural language queries into SQL statements usingGPT-4. It helps users generate, validate, and execute SQL queries against a specified database schema.

• Natural Language to SQL: Uses OpenAI's GPT-4 to generate SQL queries.
• Query Validation: Ensures generated queries are syntactically correct.
• Database Execution: Runs SQL queries against an SQLite database.
• Custom Schema Support: GPT generates SQL based on your database schema.
• User-Friendly UI: Built withStreamlit for ease of use.
• Secure API Key Management: Users can input theirOpenAI API Key manually or load it from a.env file.

• Backend: Python, OpenAI API, SQLite
• Frontend: Streamlit
• Libraries: SQL Parsing, python-dotenv

git clone https://github.com/ghaihitasha/llm-sql-query-generator.gitcd llm-sql-query-generator

pip install -r requirements.txt

Create a.env file in the root directory and add yourOpenAI API Key:

OPENAI_API_KEY=your_openai_api_key_here

streamlit run src/app.py

1. Enter yourOpenAI API Key in theProject Settings section or let it load from.env.
2. Provide thedatabase path to your SQLite file.
3. Enter a natural language query (e.g., "Show all employees who joined after 2020").
4. ClickGenerate SQL to get the SQL query.
5. Validate & Execute the query to see the results.

Pull requests are welcome! If you’d like to contribute, please open an issue first to discuss your changes.