skills.rest
coco-de
coco-deOFFICIAL
Explore all skills by this author →
GitHub

sql-analysis

Generate ClickHouse SQL queries for product metrics and revenue reports.

Updated Aug 27, 2026
Search Tags:#dashboard#data analysis#sql#query#product metrics#clickhouse
One-click install
npx skills add https://github.com/coco-de/skills --skill sql-analysis-coco-de
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-analysis
Source: https://github.com/coco-de/skills/tree/main/plugins/cc-pm-analytics/skills/sql-analysis
Command: npx skills add https://github.com/coco-de/skills --skill sql-analysis-coco-de

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the need to analyze product data directly using SQL, enabling users to query databases for insights, generate reports, and extract specific metrics.

Core Features & Use Cases

  • SQL Query Generation: Writes ClickHouse-compatible SQL queries for data analysis.
  • Metric Calculation: Provides patterns for common product metrics like DAU/MAU, retention, and revenue.
  • Dashboard Design: Offers suggestions for dashboard layouts based on key metrics.
  • Use Case: You need to understand the daily active users (DAU) for your product over the last month. This Skill can generate the precise SQL query to retrieve this data from your ClickHouse database.

Quick Start

Generate a ClickHouse SQL query to calculate the 7-day retention rate for users acquired last week.

Frequently Asked Questions about sql-analysis

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

FAQPage Schema
How do I write a ClickHouse SQL query to calculate DAU and MAU?▼

To calculate DAU and MAU, you generate ClickHouse-compatible SQL queries that aggregate distinct active users per day and month, yielding direct metric outputs for product data analysis and dashboard visualization.

What is the best way to analyze conversion funnels using SQL queries?▼

Analyzing conversion funnels involves writing SQL queries to track sequential user actions and calculate drop-off rates, enabling data-driven product decisions based on direct database querying.

Can I generate a revenue report and dashboard layout with this data analysis approach?▼

Yes, you can generate revenue reports through direct database querying and receive dashboard design suggestions, providing layouts based on key metrics for visualizing product data.

Does this SQL data analysis method work for calculating user retention rates?▼

Yes, this method supports calculating user retention metrics by generating precise SQL queries, such as retrieving the 7-day retention rate for users acquired during a specific period.

Do I need a ClickHouse database to use these SQL query patterns?▼

Yes, the generated SQL queries are specifically designed to be ClickHouse-compatible, requiring a ClickHouse database environment to execute the data analysis and retrieve product metrics successfully.

Related Skills

Explore More Data & Analytics Skills→
ClawLink-HQClawLink-HQ
117

clickhouse-analytics

Execute SQL-like queries on ClickHouse databases via HTTP API without writing SQL.

Official
Basic
abhishekchoudhariabhishekchoudhari
1

sql-queries

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

Community
Advanced
atholaathola
326

service-registry

Manage external service connections, configurations, and health checks across multiple services.

Community
Intermediate
clinecline
19

data-analyst

Clarify ambiguous business questions and execute bounded SQL queries on ClickHouse.

Official
Advanced