dev-dict

Generate SQL insert statements for Ruoyi dictionary types and data.

1|Updated Dec 22, 2025
One-click install
npx skills add https://github.com/Harries/hydpromptkit --skill dev-dict
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dev-dict
Source: https://github.com/Harries/hydpromptkit/tree/main/skills/dev-dict
Command: npx skills add https://github.com/Harries/hydpromptkit --skill dev-dict

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps generate SQL insert statements for Ruoyi framework data dictionaries (sys_dict_type and sys_dict_data) from requirements or design documents, reducing manual SQL creation work and ensuring consistency.

Core Features & Use Cases

  • Generate SQL insert statements for dict_type entries with fields like dict_name, dict_type, and status.
  • Generate corresponding dict_data rows with dict_sort, dict_label, dict_value, dict_type, list_class, is_default, and status.
  • Use Case: Given a design doc for a new module, produce ready-to-run SQL to initialize its dictionary data in a Ruoyi project.

Quick Start

Describe your dictionary specifications (names, types, and sample entries) and ask this skill to output the SQL inserts.

Frequently Asked Questions about dev-dict

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

FAQPage Schema
How do I generate SQL insert statements for Ruoyi data dictionaries?

To generate SQL insert statements for Ruoyi data dictionaries, provide your dictionary specifications including names, types, and sample entries. The tool outputs ready-to-run SQL inserts for sys_dict_type and sys_dict_data tables with properly formatted fields like dict_name, dict_type, and status.

What fields are required for Ruoyi sys_dict_data SQL generation?

Ruoyi sys_dict_data SQL generation requires the exact fields dict_sort, dict_label, dict_value, dict_type, list_class, is_default, and status. Providing these dictionary specifications ensures the output SQL inserts initialize dictionary data correctly within the Ruoyi framework.

Can I automatically create Ruoyi dictionary types from a design document?

Yes, you can automatically create Ruoyi dictionary types from a design document by describing the required dictionary specifications. The skill processes these design inputs to generate corresponding SQL insert statements for both sys_dict_type and sys_dict_data tables.

What is the best way to initialize dictionary data in a Ruoyi project?

The best way to initialize dictionary data in a Ruoyi project is to define your module's dictionary requirements and generate SQL insert statements. This ensures consistency across sys_dict_type and sys_dict_data tables while reducing manual SQL creation work.

Does generating Ruoyi data dictionary SQL require any specific database dependencies?

No, generating Ruoyi data dictionary SQL does not require specific database dependencies. The skill outputs standard SQL insert statements that can be executed directly within your Ruoyi project's database environment to populate dictionary types and data.