**No need to write SQL anymore. Just ask questions in plain English and get your answers (with the SQL behind them).** Link in Comments

Reddit r/AI_Agents Tools

Summary

A developer built 'Ask Your Data,' an AI-powered text-to-SQL app that lets users query a 1M-row synthetic loan portfolio in plain English, generating validated PostgreSQL queries with charts and transparent SQL output for verification.

I work in BI/data, and many questions from business teams sound simple: * Which branches have the highest NPA? * How did disbursements trend this year? * What's the average loan size by product type? But answering them usually requires someone to write SQL, validate the logic, and explain the results. So I built **Ask Your Data**, an AI-powered Text-to-SQL app that lets you ask questions about a synthetic retail loan portfolio of 1 Million Rows. ## How it works You ask a question in plain English, and the app: Generates a PostgreSQL query. Validates and executes the query. Returns the answer in simple language. Displays a chart, result table, and the exact SQL generated, so you can verify the answer instead of blindly trusting the AI. 🛠️ **Tech stack:** Next.js, FastAPI, PostgreSQL (Neon), and GPT-4.1-mini. *All data used in the app is synthetic.* --- ## What I learned The biggest challenge wasn't getting the model to write SQL. It was helping it understand business terminology and return the right answer. A query can be syntactically correct and still be completely wrong from a business perspective. **Try to break it.** That's the kind of feedback that will help me improve the app. *Live demo and source code links are in the first comment.*
Original Article

Similar Articles

@bkdgiffug: No more late nights writing SQL for sudden sales report requests. WrenAI is an open-source generative BI engine that lets you ask questions in natural language after connecting to a database, generating SQL, charts, and analysis results. It also includes a semantic layer that pre-defines business metrics and data relationships to reduce AI agent errors in guessing fields and definitions.

X AI KOLs Timeline

WrenAI is an open-source generative BI engine that allows users to ask questions in natural language to generate SQL, charts, and analysis results, and it features a semantic layer to enhance accuracy.