skills.rest
abhishekchoudhari
abhishekchoudhariCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-queries

Generate production-ready SQL queries for product analytics metrics across BigQuery, Snowflake, Redshift, and PostgreSQL.

1|Updated Mar 9, 2026
Search Tags:#data extraction#sql#performance metrics#database queries#product analytics
One-click install
npx skills add https://github.com/abhishekchoudhari/pm-superic-skills --skill sql-queries-abhishekchoudhari
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-queries
Source: https://github.com/abhishekchoudhari/pm-superic-skills/tree/main/pm-data-analytics/skills/sql-queries
Command: npx skills add https://github.com/abhishekchoudhari/pm-superic-skills --skill sql-queries-abhishekchoudhari

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the process of writing and optimizing SQL queries for product analytics, enabling users to quickly generate production-ready queries for various metrics and scenarios.

Core Features & Use Cases

  • Generate SQL Queries: Automatically create SQL queries for DAU/MAU, retention cohorts, funnels, feature adoption, growth accounting, NPS, revenue cohorts, power users, A/B test results, and ARPU by segment.
  • Supports Multiple Databases: Compatible with BigQuery, Snowflake, Redshift, and PostgreSQL.
  • Use Case: If you need a SQL query to calculate the DAU/MAU ratio for the past 90 days, this Skill can generate it for you with annotations and optimization guidance.

Quick Start

Use the sql-queries skill to generate a DAU/MAU ratio query for the past 90 days.

Frequently Asked Questions about sql-queries

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate SQL queries for tracking product analytics metrics like retention and DAU/MAU?▼

To write SQL queries for DAU/MAU, retention cohorts, and funnels, you need SQL knowledge and access to relevant databases. This Skill generates production-ready queries with annotations and optimization guidance for these product analytics tasks.

Does this SQL query generator support BigQuery, Snowflake, and Redshift?▼

Yes, the generated SQL queries support BigQuery, Snowflake, Redshift, and PostgreSQL. You can deploy the product analytics queries directly into any of these database environments without syntax modifications.

Can I calculate ARPU and A/B test results using SQL queries for my product data?▼

Yes, you can calculate ARPU by segment and A/B test results using generated SQL queries. The queries also handle growth accounting, NPS, revenue cohorts, and feature adoption metrics for comprehensive product analytics.

What SQL query do I need to calculate the DAU/MAU ratio for the past 90 days?▼

To calculate the DAU/MAU ratio for the past 90 days, you need a SQL query aggregating daily and monthly active users. This Skill generates that specific query complete with annotations and optimization guidance.

Do I need advanced SQL knowledge to use these database queries for product analytics?▼

Yes, SQL knowledge is required to execute and interpret the database queries for product analytics. The Skill generates the query syntax and provides optimization guidance, but you must understand SQL to run it against your databases.

Related Skills

Explore More Data & Analytics Skills→
juandaniel190juandaniel190
1

sql-queries

Generate SQL queries across PostgreSQL, Snowflake, BigQuery, Redshift, and Databricks SQL.

Community
Advanced
tbartel74tbartel74
14

clickhouse-grafana-monitoring

Query ClickHouse logs and build Grafana dashboards for 3-branch detection metrics.

Community
Advanced
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
gustavscirulisgustavscirulis
114

analytics-interpretation

Interpret app analytics metrics like DAU/MAU, retention, LTV, and ARPU.

Community
Advanced