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

dbgen-playground-import

Generate dbgen templates from schemas, SQL, and EXPLAIN evidence for TiDB test data.

Updated Jun 3, 2026
Search Tags:#tidb#workload modeling#test data generation#import validation#dbgen#playground testing
One-click install
npx skills add https://github.com/alex-quan-001/nutshell-skills --skill dbgen-playground-import
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbgen-playground-import
Source: https://github.com/alex-quan-001/nutshell-skills/tree/main/skills/utilities/dbgen-playground-import
Command: npx skills add https://github.com/alex-quan-001/nutshell-skills --skill dbgen-playground-import

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Manually creating realistic test data for TiDB/MySQL workloads and validating import pipelines is time-consuming, error-prone, and often fails to replicate real-world skew, join patterns, and query behavior. This Skill automates the entire end-to-end workflow from workload evidence to verified import.

Core Features & Use Cases

  • Intelligent dbgen Template Generation: Converts table schemas, representative SQL, and EXPLAIN/statistics evidence into realistic dbgen templates that preserve joinability, filter selectivity, and workload skew.
  • End-to-End Validation Pipeline: Automates local TiDB playground setup, schema application, IMPORT INTO execution, and post-import verification of row counts, joins, and representative queries.
  • Use Case: For database teams testing TiDB performance with join-heavy, skewed, multi-tenant, or time-bucketed workloads, this Skill eliminates manual data generation and import troubleshooting, delivering repeatable validated test datasets in minutes.

Quick Start

Use the dbgen-playground-import skill to turn your table schema, representative SQL, and EXPLAIN plans into a validated dbgen dataset imported into a local TiDB playground.

Frequently Asked Questions about dbgen-playground-import

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

FAQPage Schema
How do I generate realistic test data for TiDB that preserves join patterns and workload skew?▼

To generate realistic TiDB test data, you can use dbgen templates created from your table schemas, representative SQL, and EXPLAIN statistics. This approach preserves joinability, filter selectivity, and workload skew for accurate workload modeling.

What is the best way to validate an IMPORT INTO pipeline in a local TiDB playground?▼

The best way to validate an IMPORT INTO pipeline is to automate the local TiDB playground setup, schema application, data import, and post-import verification of row counts and joins using generated dbgen test datasets.

Can I regenerate and re-import only specific affected tables for a TiDB workload without rebuilding the entire dataset?▼

Yes, you can iteratively perform partial regeneration and re-import of affected tables without full dataset rebuilds, allowing efficient testing of multi-tenant or region-sharded data models in TiDB.

How do I create dbgen templates from EXPLAIN plans and statistics evidence for MySQL-compatible workloads?▼

You can create dbgen templates by supplying table schemas, representative SQL queries, and EXPLAIN or statistics evidence. This converts workload characteristics into business-like data distributions for MySQL-compatible databases.

Does dbgen test data generation work for multi-tenant and time-bucketed data models in TiDB?▼

Yes, dbgen test data generation supports multi-tenant, region-sharded, and time-bucketed data models in TiDB. It generates business-like data distributions that maintain realistic query behavior and join selectivity.

Related Skills

Explore More Data & Analytics Skills→
archibatearchibate
6

sql-optimization-patterns

Analyze EXPLAIN plans and recommend indexes for PostgreSQL and MySQL queries.

Community
Advanced
ivanshamaevivanshamaev
14

starrocks-join-optimization

Diagnose and optimize StarRocks equi-join strategies using EXPLAIN output.

Community
Advanced
netalertxnetalertx
6.9k

api-development

Create or modify NetAlertX REST API endpoints with Flask and JSON responses.

Official
Intermediate
michaelboedingmichaelboeding
24

xlsx

Create, edit, and analyze Excel spreadsheets while preserving formulas.

Community
Advanced