Running your chatbot
Time to see your chatbot in action!
Application startup
Steps to launch and test the chatbot application
# Initialize the database (if not done already)
make setup-data
# Start the Chainlit application
uv run chainlit run app.py -w
# The -w flag enables auto-reload on file changes
# Open http://localhost:8000 in your browserCommands to initialize and run your Text-to-SQL chatbot.
When you open localhost:8000, you should see a Chainlit chat interface with a welcome message. Type a question and you will see the agent steps appear in real time: guardrails checking the query, SQL being generated, results being analyzed, and finally the response with any visualizations.
The -w flag enables watch mode, which automatically restarts the server when you edit any Python file. This is very useful during development because you can tweak agent prompts and see results immediately without manually restarting.
Try these sample questions to test your chatbot: - How many orders were delivered? - What are the top 5 product categories by sales? - Show me the monthly order trend - What is the average review score?
Validation checklist: Chatbot test checklist
Loading practice…
Your chatbot is live and working. Next, we will explore how to switch between different LLM providers with a single configuration change.