SQL Analysis

Guided workflow for SQL data analysis using db_tools

datus-ai 98aa0cd 730 B Updated

File contents

SQL Analysis Workflow

This skill guides you through a structured data analysis workflow using database tools.

Workflow Steps

Step 1: Schema Discovery

First, understand the database schema:

Use db_tools.list_tables() to see available tables
Use db_tools.describe_table(table_name) for each relevant table

Step 2: Data Exploration

Explore the data with sample queries:

Use db_tools.execute_sql("SELECT * FROM {table} LIMIT 10")

Step 3: Analysis Query

Based on the user's question, construct and execute the analysis query.

Step 4: Result Interpretation

Analyze the results and provide insights.

datus-ai/datus-agent/tree/main/tests/data/skills/sql-analysis commit 98aa0cd596

Frequently asked questions

npx skillmds@latest add datus-ai/sql-analysis