Remember the dialect for future queries in the same session.

3. Discover Schema (If Warehouse Connected)

If a data warehouse MCP server is connected:

1. Search for relevant tables based on the user's description
2. Inspect column names, types, and relationships
3. Check for partitioning or clustering keys that affect performance
4. Look for pre-built views or materialized views that might simplify the query

4. Write the Query

Follow these best practices:

Structure:

• Use CTEs (WITH clauses) for readability when queries have multiple logical steps
• One CTE per logical transformation or data source
• Name CTEs descriptively (e.g., daily_signups, active_users, revenue_by_product)

Performance:

• Never use SELECT * in production queries -- specify only needed columns
• Filter early (push WHERE clauses as close to the base tables as possible)
• Use partition filters when available (especially date partitions)
• Prefer EXISTS over IN for subqueries with large result sets
• Use appropriate JOIN types (don't use LEFT JOIN when INNER JOIN is correct)
• Avoid correlated subqueries when a JOIN or window function works
• Be mindful of exploding joins (many-to-many)

Readability:

• Add comments explaining the "why" for non-obvious logic
• Use consistent indentation and formatting
• Alias tables with meaningful short names (not just a, b, c)
• Put each major clause on its own line

Dialect-specific optimizations:

• Apply dialect-specific syntax and functions (see sql-queries skill for details)
• Use dialect-appropriate date functions, string functions, and window syntax
• Note any dialect-specific performance features (e.g., Snowflake clustering, BigQuery partitioning)

5. Present the Query

Provide:

1. The complete query in a SQL code block with syntax highlighting
2. Brief explanation of what each CTE or section does
3. Performance notes if relevant (expected cost, partition usage, potential bottlenecks)
4. Modification suggestions -- how to adjust for common variations (different time range, different granularity, additional filters)

6. Offer to Execute

If a data warehouse is connected, offer to run the query and analyze the results. If the user wants to run it themselves, the query is ready to copy-paste.

Examples

Simple aggregation:

/write-query Count of orders by status for the last 30 days

Complex analysis:

/write-query Cohort retention analysis -- group users by their signup month, then show what percentage are still active (had at least one event) at 1, 3, 6, and 12 months after signup

Performance-critical:

…

customer-research

围绕客户问题进行多来源调研与溯源，快速整理背景并支持准确回复。

stackql

用 SQL 统一查询、编排并运维云与 SaaS 资源及其 API。