Query Writing Skill

When to Use This Skill

Use this skill when you need to answer a question by writing and executing a SQL query.

Workflow for Simple Queries

For straightforward questions about a single table:

1. Identify the table - Which table has the data?
2. Get the schema - Use sql_db_schema to see columns
3. Write the query - SELECT relevant columns with WHERE/LIMIT/ORDER BY
4. Execute - Run with sql_db_query
5. Format answer - Present results clearly

Workflow for Complex Queries

For questions requiring multiple tables: