1 points | by rahuldey 15 hours ago ago
1 comments
a simple text-to-sql app https://rahuldey700-texttosql.streamlit.app/ using AI agents for those tired of writing sql queries (or don't know how to yet)
1. upload an excel/csv
2. ask questions in english
3. returns sql query and the final response
Example:
1. Upload excel file containing sales data (region, product, sales, month)
2. Ask : "calculate total sales"
3. Response:
SELECT SUM(sales) as total_sales FROM demo_data;
Agent Final Answer: The total sales amount to 2430.
don't have a dataset handy to try this tool? you can find one here https://www.datablist.com/learn/csv/download-sample-csv-file...
time to build this - 5ish hours (thanks to gpt o1)
https://github.com/rahuldey700/TextToSQL
a simple text-to-sql app https://rahuldey700-texttosql.streamlit.app/ using AI agents for those tired of writing sql queries (or don't know how to yet)
1. upload an excel/csv
2. ask questions in english
3. returns sql query and the final response
Example:
1. Upload excel file containing sales data (region, product, sales, month)
2. Ask : "calculate total sales"
3. Response:
SELECT SUM(sales) as total_sales FROM demo_data;
Agent Final Answer: The total sales amount to 2430.
don't have a dataset handy to try this tool? you can find one here https://www.datablist.com/learn/csv/download-sample-csv-file...
time to build this - 5ish hours (thanks to gpt o1)
https://github.com/rahuldey700/TextToSQL