Text2SQL

• 

  Loader when waiting for API response

• 

  First screen

• 

  Result is printed on right side

• 

  Text2SQL from existsing DB in Tidb

Inspiration

My interest in Database and willingness to learn GENAI

What it does

It has two parts. User can provide a SQL schema or csv data and ask questions about that. Or user can use text to SQL feature to run queries in existing tidb database to get result.

How I built it

The application is built on Python Flask framework. AWS is used for hosting. Gemini AI is used instead of OPENAI

Challenges I ran into

Learning llama-index and GEN AI

Accomplishments that I'm proud of

Implementing what I had initially planned

What I learned

How to use GEN AI technologies to make production level application

What's next for Text2SQL

Adding similarity search for auto completion

Built With

• amazon-web-services
• gemini
• llama-index
• python