SQL & Plain English Queries Expert Skill

What problem does it solve?

This Skill helps you turn a business question or rough requirements into correct, runnable SQL that matches your database dialect, while also diagnosing and optimizing SQL you already have.

Core Features & Use Cases

• Plain English to SQL: Converts a user’s business question (e.g., top customers, sales by month) into a valid query for the right SQL dialect.
• SQL building and fixes: Builds SQL from scratch, translates requirements into joins/filters/aggregations, and fixes syntax errors.
• Schema-aware guidance: Reads connection vendor from DataPallas connection XML and uses available schema artifacts or direct db_query discovery to avoid guessing tables/columns.

Quick Start

Ask: “Build the SQL for a report that shows customer name, invoice date, and total amount for the Invoices report, using our database dialect.”