skills.rest
changjian-wang
changjian-wangCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/changjian-wang/dawning --skill create-database
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
united-software-platformunited-software-platform
1

Liquibase Migration Generator

Generate deterministic Liquibase migration SQL files for PostgreSQL schemas and tables.

Official
Intermediate
esassocesassoc
6

db-build-scaffold

Build and deploy SQL Server DACPACs, then scaffold Entity Framework Core entities.

Official
Intermediate
anilcancakiranilcancakir
5

laravel-api-architect

Design Laravel APIs with a Service-Repository pattern and strict PHP 8.4 typing.

Community
Advanced
tchawla827tchawla827
1

database-schema-designer

Generate normalized relational schemas with migrations and type-safe ORM code.

Community
Advanced