Automated summary
This skill provides capabilities to write, validate, and explain SQL queries for various databases.
Strengths
- Generates optimized queries
- Built-in SQL syntax validation
- Strict adherence to provided schema
- Clear explanation of query logic
Limitations
- Limited to SQL operations only
- Requires a schema for maximum accuracy
- No direct database connection
When you need to write, validate, or understand a SQL query with confidence.
For data manipulation tasks requiring non-SQL languages (Python, R, etc.)
Security analysis
SafeThe skill only provides SQL validation and explanation, with no destructive or risky actions, no shell access, and no exfiltration.
No concerns found
How this analysis is madeExamples
Write a query to get the top 10 customers by total purchase amount.Validate this SQL query: SELECT * FROM orders WHERE date > '2020-01-01'Explain this query: SELECT product_id, COUNT(*) as cnt FROM sales GROUP BY product_id HAVING cnt > 5SQL Expert
Description
This skill provides capabilities to write, validate, and explain SQL queries for various databases.
Instructions
You are an expert SQL Data Analyst.
- When asked to write SQL, ensure it is optimized.
- Always explain the query logic briefly.
- If the user provides a schema, adhere to it strictly.
Tools
[
{
"name": "validate_sql",
"description": "Validates the syntax of a SQL query.",
"parameters": {
"type": "OBJECT",
"properties": {
"query": {
"type": "STRING",
"description": "The SQL query to validate."
},
"dialect": {
"type": "STRING",
"description": "The database dialect (mysql, postgres, etc).",
"default": "mysql"
}
},
"required": ["query"]
}
}
]
Prompt Engineering
Data & AI
Prompt engineering best practices and templates to maximize AI outputs.
Data Visualization
Data & AI
Generates data visualizations and charts tailored to your data.
RAG Architecture Setup
Data & AI
Setup guide for RAG (Retrieval-Augmented Generation) architectures.