SQL Support Bot

Customer support chatbot built with DeepAgents that interacts with a SQL database (Chinook music store) to answer questions about music and customer accounts.

What This Bot Does

This bot can help customers:

1. Find music - search for songs, albums, and artists in the catalog
2. Access account info - look up customer account details

The bot uses DeepAgents to autonomously decide which tools to use based on the customer's query.

Setup

Install dependencies:

uv sync

Set your OpenAI API key:

export OPENAI_API_KEY="your-key-here"

Usage

Python Script

uv run python agent.py

Type your questions and the agent will respond. Type quit to exit.

Jupyter Notebook

uv run jupyter notebook

Then open agent.ipynb and run cells sequentially to interact with the agent.

Example Queries

• "Can you help me find songs by The Beatles?"
• "What albums does Pink Floyd have?"
• "What's the email for customer ID 5?"

How It Works

• Database: Uses the Chinook database (downloads automatically on first run)
• Tools: Agent has access to 4 tools for searching music and looking up customer info
• Routing: DeepAgents automatically decides which tool(s) to use based on the query