[{"_1":2,"_42":-5,"_43":-5},"loaderData",{"_3":4,"_10":11,"_40":-5,"_41":-5},"root",{"_5":-5,"_6":-5,"_7":-5,"_8":9},"user","shoppingCartId","toast","locale","en","routes/_store+/_readers+/email_author.$slug/route",{"_12":13,"_39":-5},"book",{"_14":15,"_16":17,"_18":19,"_20":21,"_22":23,"_24":25},"id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvNjMyMDI","title","Text-to-SQL, Spring AI Implementation with RAG","state","published","contactAuthorMethod","email","aboutText","

Building AI applications is very popular these days. For Java developers, the best choice for building AI applications is using Spring AI. To learn how to use Spring AI to build AI applications, we need to have a concrete example. Text-to-SQL is a typical usage of using AI to improve productivity. By using Text-to-SQL, non-technical people use natural language to describe database query requirements. These queries are sent to LLM. LLM can generate SQL statements to answer user queries. LLM can also use tools to execute SQL statements, and return the query results to the user. Text-to-SQL is a good example of AI applications.

In this book, we will use Spring AI to create a Text-to-SQL application. After learning this course, you will know:

How to use ChatClient to send requests to LLM and receive responses.
How to extract database metadata and include them in the prompt sent to LLM.
How to use Spring AI advisors to intercept ChatClient requests to process requests and responses.
How to use embedding model and vector store to implement semantic search of database metadata.
How to use LLM to generate summary of database tables and SQL statements.
How to use LLM to re-select tables automatically.
How to allow user to manually re-select tables using message history.
How to execute and validate SQL statements using tools.
How to use Spring Cloud Function to deploy Text-to-SQL application and metadata indexer as serverless functions and run them on AWS Lambda.
How to generate SQL statements with results matching provided schema.
How to create a Text-to-SQL MCP server.

This book covers all major aspects of Spring AI, including ChatClient, advisors, embedding models, vector stores, chat memory and tool calling.

What you have learned in this book, can help you build other AI applications using Spring AI.

","authors",[26],{"_14":27,"_28":29,"_5":30},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci82Njk2MA","name","Fu Cheng",{"_31":32},"avatar",{"_33":34,"_35":36,"_37":38},"url","https://d308did4coypzi.cloudfront.net/avatars/301829/medium/profile-new.JPG?1653309511","styleName","medium","exists",true,"currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the author