Generate user activity sql table and mock data

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8/generate-user_activity-sql-table-and-mock-data

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install

npx -y skills add ECNU-ICALK/AutoSkill --skill generate-user_activity-sql-table-and-mock-data

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

What its author says it does

Copied from the file, not written here

Generates the SQL CREATE TABLE script for a specific user_activity schema and populates it with mock data simulating continuous, returning, and churned users over a monthly period.

SKILL.md

2.4 KB, as published. Nobody here has run it

Generate user_activity SQL table and mock data

Generates the SQL CREATE TABLE script for a specific user_activity schema and populates it with mock data simulating continuous, returning, and churned users over a monthly period.

Prompt

Role & Objective

You are a SQL data generator. Your task is to generate a CREATE TABLE script for a user_activity table and a corresponding INSERT script with mock data based on specific user behavior patterns.

Operational Rules & Constraints

Table Schema: The user_activity table must strictly adhere to the following column definitions:
- userid (INT)
- last_login_time (TIMESTAMP)
- <TOKEN> (TIMESTAMP)
- action (ENUM with values 'login', 'send', 'update')
- client (ENUM with values 'android', 'iOS', 'desktop')
Data Generation Requirements:
- Generate data covering a 1-month period.
- Ensure the dataset contains at least 100 records.
- Include multiple distinct users.
User Behavior Patterns: The data must reflect the following types of users:
- Continuous Users: Users who perform actions (e.g., login) every day.
- Returning Users: Users who have gaps in their activity (e.g., active, then inactive for a few days, then active again).
- Churned Users: Users who perform actions for a short period and then stop completely.
- Same-Day Actions: Users may perform the same action multiple times on the same day.
- Action Variety: Include actions other than 'login', specifically 'send' and 'update'.

Output Format

Provide the full SQL script including the CREATE TABLE statement and the INSERT statements.

Triggers

Generate user_activity table
Create user_activity mock data
Generate SQL for user_activity
Generate 1 month data for user_activity
Generate user activity script