skills.rest
alex-quan-001
alex-quan-001COMMUNITY
Explore all skills by this author →
GitHub

analyzing-tidb-x-growth

Extract TiDB X cluster growth metrics from BigQuery BI tables.

Updated Jun 3, 2026
Search Tags:#bigquery#tidb#cluster growth#tenant analytics#service plan analysis#region distribution
One-click install
npx skills add https://github.com/alex-quan-001/nutshell-skills --skill analyzing-tidb-x-growth
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: analyzing-tidb-x-growth
Source: https://github.com/alex-quan-001/nutshell-skills/tree/main/skills/growth/analyzing-tidb-x-growth
Command: npx skills add https://github.com/alex-quan-001/nutshell-skills --skill analyzing-tidb-x-growth

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually querying BigQuery to track TiDB X cluster growth metrics is time-consuming and error-prone for teams needing to monitor tenant adoption, service plan distribution, and regional deployment patterns.

Core Features & Use Cases

  • Tenant Growth Tracking: Pull daily new and cumulative cluster counts for specific tenants over custom date ranges to monitor adoption trends.
  • Aggregated Distribution Analysis: Break down active TiDB X cluster counts by service plan (Starter, Essential, Premium) and cloud region to identify deployment concentrations.
  • High-Volume Tenant Identification: List tenants exceeding custom cluster count thresholds to spot top users and separate internal from external usage. Use case: A product operations team can use this skill to generate a 30-day growth trend report for a specific tenant and identify which regions have the highest concentration of Starter clusters.

Quick Start

Use the analyzing-tidb-x-growth skill to pull the last 7 days of daily new and cumulative Starter cluster counts for tenant 12345.

Frequently Asked Questions about analyzing-tidb-x-growth

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

FAQPage Schema
How do I track TiDB X cluster growth metrics for a specific tenant in BigQuery?▼

Track TiDB X cluster growth metrics by extracting daily new and cumulative cluster counts from the GCP BigQuery BI table without manual SQL composition. Supports custom date ranges and fuzzy tenant identifier matching to monitor adoption trends.

Can I analyze TiDB X service plan distribution across cloud regions without writing SQL?▼

Analyze TiDB X service plan distribution across cloud regions without manual SQL by breaking down active cluster counts for Starter, Essential, and Premium tiers. This identifies regional deployment concentrations directly from BigQuery.

Does this BigQuery tenant analytics approach filter out inactive TiDB X clusters?▼

Yes, this BigQuery tenant analytics approach enforces active-cluster-only filtering by default. It standardizes BigQuery query execution with explicit project specification and service account authentication handling to ensure accurate cluster growth tracking.

What is the best way to identify high-volume TiDB X tenants from BigQuery data?▼

Identify high-volume TiDB X tenants by listing those exceeding custom cluster count thresholds. The analysis separates internal from external usage and spots top users based on active-cluster-only filtering.

Related Skills

Explore More Data & Analytics Skills→
alex-quan-001alex-quan-001

o11y-data

Access TiDB Cloud observability data across metrics, logs, and profiles.

Community
Advanced
alex-quan-001alex-quan-001

o11y-data-export

Automate TiDB Cloud observability data exports to S3 storage.

Community
Intermediate
truongnattruongnat

mongodb-pro

Model MongoDB documents, optimize queries, and administer Atlas clusters.

Community
Advanced
alex-quan-001alex-quan-001

tidb-onebox

Deploy and manage TiDB-X clusters on AWS EKS with Terraform and Kubernetes.

Community
Advanced