SQL-Agent with large database

General
,
1

I have a database with over 40 tables, but the table and column names are not meaningful names and a large data size, here’s how to handle the SQL agent flow. My requirement is to perform NPL (Natural Language Processing) to SQL conversions. The end user asks simple questions in English, and the system should create an SQL query based on the table names and column names in the database, which is MSSQL.

My current approach involves using the SQL agent with Langraph. This tool extracts the table names and database metadata given the context, but the generated query isn’t always accurate.

2

Your question is not straightforward. What do you need help with?

3

have a database with over 40 tables, but the table and column names are not meaningful names and a large data size, here’s how to handle the SQL agent flow. My requirement is to perform NPL (Natural Language Processing) to SQL conversions. The end user asks simple questions in English, and the system should create an SQL query based on the table names and column names in the database, which is MSSQL.