Provide SQL syntax and optimization guidance for major data warehouse platforms.
npx skills add https://github.com/14790897/MiQi --skill kwp-data-sql-queries
Please help me install this Agent Skill. Skill: kwp-data-sql-queries Source: https://github.com/14790897/MiQi/tree/main/miqi/skills/kwp/data/sql-queries Command: npx skills add https://github.com/14790897/MiQi --skill kwp-data-sql-queries
This skill resolves the friction of switching between different SQL dialects by providing a unified, expert-level reference for syntax, performance optimization, and complex query patterns across major data platforms.
Ask the agent to write a SQL query using the Snowflake dialect that calculates a 7-day moving average of revenue using window functions.
High-intent search queries and answers about installing and using this skill.
To write a cohort retention SQL query in Snowflake, you use pre-built analytical query templates that leverage window functions to group users by initial activity date and track subsequent engagement over time.
The best way to optimize BigQuery performance is by applying clustering, indexing best practices, and query profiling to reduce costs. This skill provides specific strategies to keep analytical workloads performant across data warehouses.
Yes, this SQL syntax guide supports PostgreSQL and Redshift dialects alongside Snowflake, BigQuery, and Databricks. It provides dialect-specific functions for date arithmetic, string manipulation, and semi-structured data parsing across these environments.
To parse semi-structured data using Databricks SQL, you apply dialect-specific functions designed for navigating and extracting nested JSON fields. This skill offers comprehensive syntax guidance for these data engineering tasks.
Yes, you can get templates for window-based calculations like a 7-day moving average. The skill provides pre-built advanced query patterns for window functions, funnel analysis, and deduplication across major data platforms.
PostHogConnect external data warehouse sources to PostHog with per-table sync methods.
gman-roboticsAnalyze Excel and CSV files with DuckDB SQL queries and export results.
hung-phanExplain OLAP warehouse design principles for large-scale analytical queries.
Eng0AITranslate natural-language questions into executable SQL queries for PostgreSQL databases.
