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;