Week 11 — Lesson 2: Text-to-SQL over SQLite

2 min

get_machine_stats answers one question about NorthPeak. Every new question would need a new function, and writing a tool for every question is not possible. Text-to-SQL turns this around: you give the model the schema and a question, it writes the SQL, and your code runs it on diagnostics.sqlite and shows the rows. This lesson shows the schema in the system message, a correct join written by the model, and a query that runs without answering the question.

Preview — the rest of the lesson is for enrolled readers.

Already enrolled with a code?

Your access is tied to your account, not to this link. Sign in with the same email you used in class: your course is waiting, no need to enter the code again.

Sign inNo account yet? Create one
This lesson is part of the “Week 11 — LLM tools and database querying” module

The first modules of the course are open to everyone. For the rest you have three options: buy this course once and for all, subscribe, or enter the code handed out in class.

Are you a student on this course?

The code is tied to your account: sign in or create an account and it will be applied automatically when you come back.

No account yet? Create one