SQLore reads your PostgreSQL or MySQL schema, writes the SQL and shows you every query it ran — on a local model that keeps your data on your machine.
Chat
retail_db · read-only
Orders by month for our best seller
select date_trunc('month', placed_on) m, count(*) from orders group by m;
Laptop Stand · orders
Jan–Aug · 1,284
Laptop Stand leads at 1,284 — up 18%, most of it after June.
Reports
Sales analysis
Total rows
15,600
Questions
1,204
Revenue by month
Questions per day
Schema
12 tables indexed
Runs on
SQLore © 2026
