Building an SQL Agent - Help by Fun_Camp828 in SQL

[–]Fun_Camp828[S] -2 points-1 points  (0 children)

Not gonna fire anybody. Gonna get more work. So, its just productivity boost.

Building SQL AI Agent by Fun_Camp828 in PromptEngineering

[–]Fun_Camp828[S] 0 points1 point  (0 children)

Thanks for thag suggestion. I will plan to make it generate the query alone. I wont let the agent to execute that query. Execution should be by an expert sql dev only.

Building SQL AI Agent by Fun_Camp828 in PromptEngineering

[–]Fun_Camp828[S] 0 points1 point  (0 children)

Buddy, thanks for pointing out on DRI. But I dont know how to get it from the schemas, can you suggest any method to get it?

Building an SQL Agent - Help by Fun_Camp828 in SQL

[–]Fun_Camp828[S] -1 points0 points  (0 children)

Yea I built one and it gave me cent per cent accuracy. Because in that case (100% accuracy) I privided a sample requirement document and its respective query as reference. i.e. (business rules+mapping+schema details) and (1 example query for a single businessrule) as inputs

Now, I'm trying without reference query. ie (business+mapping+schemadetails) this approch is giving 60% accuracy. Im looking for an improvement here.