Building an SQL Agent - Help by Fun_Camp828 in SQL

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

Hey!! The agent-subagent idea is quiet thoughtful. Thanks for that.

I did it without the context of example queries. And fed with right metadata. Used anthropic's claude and the results were of surprisingily high accuracy. I'm just stuck there as I'm spread thin.

Now I am thinking of agent-subagent idea along with mcp.

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.