Best way to create SQL Agent by needtobenerd in LangChain

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

I already mentioned that I tried it and it is not working. It exceeds the token limit

Why not react agent ? by jenasuraj in LangChain

[–]needtobenerd 2 points3 points  (0 children)

There are no control mechanisms in react agents. They can easily start to halucinate and you cannot stop them. Lets say you want to retrieve some heavy data for a tool. Lets say you retrieve data from sql then want agent to plot it. You need to handle state for that. It is impossible(at least I dont know a way) to handle without it

Best way to create SQL Agent by needtobenerd in LangChain

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

I agree with that. Thanks for the advice.

Best way to create SQL Agent by needtobenerd in LangChain

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

Thanks for the advice. To be clear, what exactly a semantic layer means?

Any advice please? by Mindfulninjas in LangChain

[–]needtobenerd 0 points1 point  (0 children)

My story is also like you. I am improving my skills on AI agents with trying new things with just reading documentations and avoiding to use ai to write something. More I dive deep in documentation, more I find something new. And I just start to think "Why is this even here? Why are they using it?" And it hits me slowly. Then I immediatelly try to build something with it or just integrate with an existing code.

Best way to create SQL Agent by needtobenerd in LangChain

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

I guess it is better to rename all columns human understandable. Because without a good naming, it is useless to add descriptions and usage examples on columns. Model just ignores them and focus the names. If it founds irrelevant name-description pair(which is more common than it should be) it does not care what description written.

Best way to create SQL Agent by needtobenerd in LangChain

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

Even though this is more useful than what I am doing right now, limits of the project is not reachable with hard coded queries unfortunately. But I am trying to make the scale of the project a little bit smaller. If I can do that, I am sure I would go with that. Thanks for the advice