Sql Transform Helper

What it does

The sql-transform-helper skill assists in generating and transforming SQL queries. It can take a natural language description of a desired query or an existing, potentially flawed, SQL query as input and produce corrected or modified SQL code. This is useful for automating database interactions and improving the accuracy of data retrieval.

When to use it

• You need to translate a plain English request into a complex SQL query for extracting specific information from a database.
• You have an existing SQL query that isn't working as expected, and you want help debugging or optimizing it.
• You want to modify an existing SQL query to include new filters or aggregations without manually writing the changes.
• You are generating SQL queries programmatically and need assistance ensuring correctness and efficiency.

Key capabilities

• SQL Query Generation: Creates SQL from natural language descriptions.
• SQL Correction: Identifies and fixes errors in provided SQL code.
• SQL Transformation: Modifies existing SQL queries based on instructions.

Example prompts

• "Generate a SQL query to find all customers who placed an order over $100."
• "Correct the following SQL query: SELECT name, FROM users"
• "Modify this SQL query to include only orders from the last month: SELECT * FROM orders"

Tips & gotchas

The skill's effectiveness depends on the clarity and specificity of your instructions. Providing context about the database schema (table names, column types) can significantly improve the quality of generated or transformed queries.