Developers can leverage ChatGPT or GitHub Copilot to generate sophisticated SQL queries to retrieve relevant results from a database from a text prompt. Why not create a chatbot with the ability to generate and also execute SQL queries against a database? Providing the option to access structured data opens up the possibility for a chatbot to answer complex questions relating to business data using a natural language interface.

In this demo intensive session Alan will explain concepts of integrating language models with structured data sources such as SQL Server. He will demonstrate how SQL chains and agents in LangChian can be leveraged to connect to a database, analyze the table structure, and then compose and execute the queries used to generate the results. The internals of SQL chains and agents will be covered along with tips about prompt optimization. Alan will also cover the safety and security aspects of allowing an AI to access external data.