In preparation
QryAI
Read it as “query AI.”
It will let people who need answers out of a database ask in plain words, read the query it writes, approve it and get the answer, without writing SQL.
Tell us you want itWhat it will do
Planned, in four steps.
Ask.
It will take your question the way you would say it to a colleague, and ask back when it could mean two things.
Read.
It will write a read-only query, show it to you and explain it line by line in plain words.
Approve.
Nothing will run until you say yes. You will be able to change the question or the query.
Answer.
It will give the answer in a sentence and a small table, with the query kept beside it so you can check it.
Planned underneath: it will profile your schema, so it knows your tables and columns before it writes a line.
A copy first, a backup first, and nothing will run without your yes.Its queries are planned to only read. Changing data will not be its job.
Who it is for
People who run the business
You know what you want to know, and you wait on someone else each time it takes a query.
People who keep the records
Office managers and bookkeepers who live in exports and would rather ask the source.
Developers on an unfamiliar schema
You will get a readable first draft of a query, and still check it before it runs.