Text to SQL
Built this demo app to show how AI could make data analysis way more approachable. Instead of writing complex SQL queries, you can just ask questions in plain English about marketing metrics, and the app figures out the rest. It uses GPT-4 to turn your questions into SQL, runs them against a PostgreSQL database, and shows you the results in tables and charts.
The tech behind it is pretty cool - Next.js for the frontend, Vercel's AI SDK, and Supabase for the database, Recharts + Shadcn Charts for visualization. The UI is built with ShadowUI and Tailwind, with some nice animations thrown in. When you ask a question, the app not only gives you the data but also explains the SQL it generated, making it a neat learning tool too.
It was inspired by the Vercel PostgreSQL demo, which showcases unicorn data from CB Insights.
While this is definitely a simplified demo using mock marketing data (things like customer acquisition costs, ROI, engagement rates), I think it hints at where we're headed with data tools. Imagine being able to explore any database just by asking questions naturally - that's the future I see coming. Want to give it a try? Just click any of the screenshots below.