Simple Text to SQL (No RAG)

Caution

Code moved to JavaAIDev/hands-on-spring-ai

See JavaAIDev article for more details.

Test data: Netflix data

How to run:

1. Requires Java 21 to build and run.
2. Start Postgres database using Docker Compose.
3. Start the server and use Chat Agent UI to run query.

Sample query:

How many movies were produced in the United States?

Output:

The total number of movies produced in the United States is 2058.

See the screenshot below.

Full Text-to-SQL Implementation

For a complete Text-to-SQL implementation, check out my course.