generating-database-seed-data
Process this skill enables AI assistant to generate realistic test data and database seed scripts for development and testing environments. it uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. u... Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.
- License 许可
- MIT
- 最近更新
- 2026-11-15
- Stars
- ★ 2.0k
- Forks
- 233
01 前言 Front Matter
- name
- generating-database-seed-data
- author
- Jeremy Longshore <jeremy@intentsolutions.io>
- license
- MIT
- version
- 1.0.0
- description
- Process this skill enables AI assistant to generate realistic test data and database seed scripts for development and testing environments. it uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. u... Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.
- allowed-tools
- Read, Write, Edit, Grep, Glob, Bash(cmd:*)
02 资源文件 5
- 资产文件assets/README.md421 B
- 参考文档references/README.md447 B
- 脚本scripts/README.md431 B
- 脚本scripts/reset_database.py2.9 KB
- 脚本scripts/seed_database.py2.9 KB
03 SKILL.md 正文
Data Seeder Generator
This skill provides automated assistance for data seeder generator tasks.
Overview
This skill automates the creation of database seed scripts, populating your database with realistic and consistent test data. It leverages Faker libraries to generate diverse and believable data, ensuring relational integrity and configurable data volumes.
How It Works
- Analyze Schema: Claude analyzes the database schema to understand table structures and relationships.
- Generate Data: Using Faker libraries, Claude generates realistic data for each table, respecting data types and constraints.
- Maintain Relationships: Claude ensures foreign key relationships are maintained, creating consistent and valid data across tables.
- Create Seed Script: Claude generates a database seed script (e.g., SQL, JavaScript) containing the generated data.
When to Use This Skill
This skill activates when you need to:
- Populate a development database with realistic data.
- Create a seed script for automated database setup.
- Generate test data for application testing.
- Demonstrate an application with pre-populated data.
Examples
Example 1: Populating a User Database
User request: "Create a seed script to populate my users table with 50 realistic users."
The skill will:
- Analyze the 'users' table schema (name, email, password, etc.).
- Generate 50 sets of realistic user data using Faker libraries.
- Create a SQL seed script to insert the generated user data into the 'users' table.
Example 2: Seeding a Blog Database
User request: "Generate test data for my blog database, including posts, comments, and users."
The skill will:
- Analyze the 'posts', 'comments', and 'users' table schemas and their relationships.
- Generate realistic data for each table, ensuring foreign key relationships are maintained (e.g., comments linked to posts, posts linked to users).
- Create a seed script (e.g., JavaScript with TypeORM) to insert the generated data into the database.
Best Practices
- Data Volume: Start with a small data volume and gradually increase it to avoid performance issues.
- Data Consistency: Ensure the Faker libraries used are appropriate for the data types and formats required by your database.
- Idempotency: Design your seed scripts to be idempotent, so they can be run multiple times without causing errors or duplicate data.
Integration
This skill integrates well with database migration tools and frameworks, allowing you to automate the entire database setup process, including schema creation and data seeding. It can also be used in conjunction with testing frameworks to generate realistic test data for automated testing.
Prerequisites
- Appropriate file access permissions
- Required dependencies installed
Instructions
- Invoke this skill when the trigger conditions are met
- Provide necessary context and parameters
- Review the generated output
- Apply modifications as needed
Output
The skill produces structured output relevant to the task.
Error Handling
- Invalid input: Prompts for correction
- Missing dependencies: Lists required components
- Permission errors: Suggests remediation steps
Resources
- Project documentation
- Related skills and commands
04 同仓库更多 Skills
theme-factory
Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.
web-artifacts-builder
Suite of tools for creating elaborate, multi-component claude.ai HTML artifacts using modern frontend web technologies (React, Tailwind CSS, shadcn/ui). Use for complex artifacts requiring state management, routing, or shadcn/ui components - not for simple single-file HTML/JSX artifacts.
webapp-testing
Toolkit for interacting with and testing local web applications using Playwright. Supports verifying frontend functionality, debugging UI behavior, capturing browser screenshots, and viewing browser logs.
neuropixels-analysis
Neuropixels neural recording analysis. Load SpikeGLX/OpenEphys data, preprocess, motion correction, Kilosort4 spike sorting, quality metrics, Allen/IBL curation, AI-assisted visual analysis, for Neuropixels 1.0/2.0 extracellular electrophysiology. Use when working with neural recordings, spike sorting, extracellular electrophysiology, or when the user mentions Neuropixels, SpikeGLX, Open Ephys, Kilosort, quality metrics, or unit curation.
skill-creator
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.
notebooklm
Use this skill to query your Google NotebookLM notebooks directly from Claude Code for source-grounded, citation-backed answers from Gemini. Browser automation, library management, persistent auth. Drastically reduced hallucinations through document-only responses.