Text-to-SQL Generator
Overview: This app uses a fine-tuned FLAN-T5 model to generate SQL queries based on your inputs.
How to Use:
- Context: Enter your database schema (table definitions, DDL statements, sample data).
- Query: Enter a natural language query describing the desired SQL operation.
- Click Generate SQL to see the model-generated SQL query.
Example:
Context: CREATE TABLE students (id INT PRIMARY KEY, name VARCHAR(100), age INT, grade CHAR(1)); INSERT INTO students (id, name, age, grade) VALUES (1, 'Alice', 14, 'A'), (2, 'Bob', 15, 'B');
Query: Retrieve the names of students who are 15 years old.
The generated SQL might look like: SELECT name FROM students WHERE age = 15;