What problem does it solve?
This Skill removes the friction of turning ambiguous natural language data requests into correct, performant, and dialect-specific SQL queries ready for analytics and reporting.
Core Features & Use Cases
- Natural language to SQL: Translate user descriptions into SELECTs, JOINs, aggregations, and multi-CTE pipelines.
- Dialect-aware optimization: Produce syntax and function usage tailored for Snowflake, BigQuery, PostgreSQL, Redshift, Databricks, MySQL, DuckDB, and others.
- Schema discovery & performance guidance: When connected to a data warehouse, locate tables and fields, respect partitions/cluster keys, and recommend filters, JOIN strategies, and EXISTS vs IN optimizations.
- Use Case: Build a retention cohort analysis, generate top-N user queries over large partitioned event tables, or craft multi-CTE financial rollups optimized for the target database.
Quick Start
Ask the assistant: /write-query Find the top 100 users by event count in the past 7 days using BigQuery and include each user's most recent event type.