Explore the Database Schema
The Chinook music database is connected via MCP. The database file is chinook.db in the music-analytics-api-with-db/ folder — the same Music Analytics API you've been building, now with the database included.
The MCP server has already been configured for you. For future reference on how to connect Claude Code to a SQLite database, see the MCP setup guide.
Before querying data, let's explore what's available. Ask Claude to list the tables and describe their structure.
To ćwiczenie jest częścią kursu
Software Development with Claude Code
Instrukcje do ćwiczenia
- Start Claude Code with
claude. - Ask Claude to list all tables in the database.
- Ask Claude to describe the schema of one table (e.g., the Album table).
- When done, type
/exitto exit Claude Code.
Interaktywne ćwiczenie praktyczne
Przekształć teorię w praktykę dzięki jednemu z naszych interaktywnych ćwiczeń
Rozpocznij ćwiczenie