OverviewHistoryStatsSecurity
npx skills add ...
Documentation
SKILL.md
npx skills add langchain-ai/deepagents --skill schema-exploration
Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.
npx skills add langchain-ai/deepagents --skill schema-exploration
Use sql_db_list_tables tool to see all available tables in the database.
This returns the complete list of tables you can query.
Use sql_db_schema tool with table names to examine:
Identify how tables connect:
Provide clear information about:
Step 1: Use sql_db_list_tables
Response:
Step 1: Use sql_db_schema with table name "Customer"
Response:
Step 1: Identify tables needed
Step 2: Map relationships
Response:
For "list tables" questions:
For "describe table" questions:
For "how do I query X" questions:
The Customer table has these columns:
- CustomerId (INTEGER) - Primary key, unique customer ID
- FirstName (NVARCHAR) - Customer's first name
- LastName (NVARCHAR) - Customer's last name
- Company (NVARCHAR) - Company name (optional)
- Address, City, State, Country, PostalCode - Location fields
- Phone (NVARCHAR) - Phone number
- Fax (NVARCHAR) - Fax number
- Email (NVARCHAR) - Email address
- SupportRepId (INTEGER) - Foreign key to Employee table
Sample data shows customers like:
- Luís Gonçalves from Brazil
- Leonie Köhler from Germany
- François Tremblay from CanadaArtist (ArtistId)
↓ 1:many
Album (ArtistId, AlbumId)
↓ 1:many
Track (AlbumId, TrackId)
↓ 1:many
InvoiceLine (TrackId, UnitPrice, Quantity)To find revenue by artist, you'll need to:
1. Start with the Artist table
2. JOIN to Album on ArtistId
3. JOIN to Track on AlbumId
4. JOIN to InvoiceLine on TrackId
5. SUM the revenue (UnitPrice * Quantity)
6. GROUP BY artist name
This requires the query-writing skill to execute.