Not a local model but have you seen any of the current AI videos?

Access AI Builder
> Imagine the ease of interacting with your database using simple, everyday English, and having an intelligent AI seamlessly translate your needs into complex SQL queries and/or VBA code.

OpenAI
AI Chef Helper

I’ve seen some of those tools, but most of them are basically just letting you ask a general question to an LLM (even if they support continuous chat now).

What I’m thinking about is a bit different: the AI would actually know my specific data structure—tables, relationships, field names, etc.—so it could generate SQL against my database.

For example, a user might ask:

“How many widgets did we ship from 8:00 to 8:30 yesterday?”

Because the AI understands our schema, it could then write the appropriate SQL statement, run it, and return the answer.

The reason I’m interested in this is that I’m finding more and more that users want to see data in very specific ways. Instead of asking me to build a new form or report, they’ll often pull data from several existing forms/reports and then manually piece it together in Excel or on paper. In many cases, the data they want is trivial to get with a single SQL query.

If it’s something they need often, I’ll eventually build a proper form or report. But a lot of the time, they just want to answer some one-off question for that day. That’s where I think a schema-aware, local LLM could really shine.

Isn't that what Access AI Builder does?
It has access to your Tables/Fields.

Looks like I might have missed that one. I will watch it now and see. Thank you

I did buy it but should have read the license first didn't realize it was a template not videos. So I will keep building my own but thank you for your help.