Chat to SQL
Talk To Your Data
Unlock insights from your data warehouse using only your words. Chat to SQL translates natural questions into precise, executable SQL, runs the query and returns answers or data to export.
The Problem
People -- golf league members and most co-workers -- can't use SQL and don't have Tableau so they're limited in how they can query data. I built Chat-to-SQL to give everyone the power to analyze and query structured data by converting natural language to SQL.
Core Capabilities
- Natural Language Processing: Converts user questions into SQL queries using LLM technology
- BigQuery Integration: Executes generated SQL against Google BigQuery databases
- Result Summarization: Transforms query results back into natural language summaries
- Conversation Memory: Maintains context across multiple interactions
- Web Interface: Provides an intuitive Gradio-based UI for interactions
Architecture Overview
Use‑Case Snapshot: Cleveland Cup player with question about league stats
- Player enters question about league stats in prompt window
- OpenAI API connects to GPT-4o which converts natural language to SQL
- SQL is executed via API to Google BigQuery
- Answer is returned to user
- Use may export underlying data