create-database

Generate SQL CREATE TABLE statements, C# entity classes, and repository interfaces.

Updated Nov 13, 2025

Search Tags:#database #code generation #schema #repository #sql #entity

Ready to run

npx skills add https://github.com/changjian-wang/dawning --skill create-database

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: create-database
Source: https://github.com/changjian-wang/dawning/tree/main/.github/skills/create-database
Command: npx skills add https://github.com/changjian-wang/dawning --skill create-database

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation of database tables, entity classes, and repository patterns, reducing boilerplate code and ensuring consistency in database schema design.

Core Features & Use Cases

Database Schema Generation: Creates SQL CREATE TABLE statements with GUID primary keys, timestamp fields, and audit columns.
Entity Class Creation: Generates C# entity classes that inherit from a BaseEntity class.
Repository Pattern Implementation: Creates interfaces and basic implementations for data repositories.
Use Case: When starting a new feature that requires a new data model, use this Skill to quickly set up the foundational database structure and corresponding C# code.

Quick Start

Use the create-database skill to generate a table named 'products' with columns 'name' (string) and 'price' (decimal).

Frequently Asked Questions about create-database

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

FAQPage Schema

How do I generate SQL CREATE TABLE statements with GUID primary keys and audit columns?▼

You generate SQL CREATE TABLE statements by defining table and column naming conventions. The schema output enforces GUID primary keys, timestamp fields, audit columns, and soft delete capabilities for database persistence.

How do I create C# entity classes that inherit from a BaseEntity class?▼

You create C# entity classes by defining your data model requirements. The generated entities inherit from a BaseEntity class and automatically include schema patterns like GUID primary keys, timestamp fields, and audit columns for consistent database mapping.

What is the best way to set up repository interfaces for database persistence in C#?▼

The best way to set up repository interfaces is to define the target data model. This generates repository interfaces and basic implementations alongside SQL schema and C# entity classes, ensuring consistent database persistence patterns across new features.

Can I customize table and column naming conventions when generating a database schema?▼

Yes, you can customize table and column naming conventions when generating a database schema. Defining these conventions ensures the SQL CREATE TABLE statements and C# entity classes match your project's specific architectural standards.

Does the generated database schema support soft delete capabilities?▼

Yes, the generated database schema supports soft delete capabilities. The enforced schema pattern automatically includes soft delete alongside GUID primary keys, timestamp fields, and audit columns within the SQL CREATE TABLE statements and C# entity classes.