skills.rest
AIDotNet
AIDotNetOFFICIAL
Explore all skills by this author →
WebsiteGitHub

database-designer

Design and optimize database schemas for PostgreSQL, MySQL, SQLite, and MongoDB.

84|15|Updated Dec 31, 2025
Search Tags:#design#database#optimization#schema#migration#sql
One-click install
npx skills add https://github.com/AIDotNet/MoYuCode --skill database-designer-aidotnet
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-designer
Source: https://github.com/AIDotNet/MoYuCode/tree/main/skills/community/database-designer
Command: npx skills add https://github.com/AIDotNet/MoYuCode --skill database-designer-aidotnet

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill assists in designing and optimizing database schemas for various database systems, including generating migration scripts.

Core Features & Use Cases

  • Schema Design: Create Entity-Relationship (ER) models for databases.
  • Normalization: Apply normalization techniques to improve data integrity.
  • Index Optimization: Suggest and implement efficient indexing strategies.
  • Migration Scripts: Generate SQL or framework-specific migration scripts.
  • Use Case: A developer needs to design a new schema for a user authentication system and requires SQL CREATE TABLE statements and an Entity Framework Core migration file.

Quick Start

Use the database-designer skill to create a PostgreSQL schema for a blog with users and posts tables.

Frequently Asked Questions about database-designer

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

FAQPage Schema
How do I design and optimize a database schema for PostgreSQL?▼

You can design and optimize a database schema for PostgreSQL by generating Entity-Relationship models, applying normalization for data integrity, and implementing index optimization strategies to improve query performance.

Can I generate migration scripts for an Entity Framework Core database?▼

Yes, you can generate framework-specific migration scripts for database evolution. This includes creating SQL statements and Entity Framework Core migration files to seamlessly evolve your schema.

What is the best way to apply normalization to improve database schema integrity?▼

The best way to improve database schema integrity is by applying normalization techniques during the Entity-Relationship modeling phase, ensuring efficient data structure and reducing redundancy across your tables.

Does this database schema designer work with both SQL and MongoDB?▼

Yes, the database schema designer works with PostgreSQL, MySQL, SQLite, and MongoDB. It supports schema design, optimization, and generating migration scripts across these relational and NoSQL database systems.

How do I implement efficient indexing strategies for my database tables?▼

You implement efficient indexing strategies by analyzing your schema design and applying index optimization techniques. This suggests and implements specific indexes to enhance database query performance.

Related Skills

Explore More Software Engineering Skills→
musujmusuj

phase-1-schema

Define project terminology, entities, relationships, and data structures.

Community
Intermediate
mikkelkrogsholmmikkelkrogsholm
5

prisma

Generate a Prisma schema file for PostgreSQL databases.

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
neitui-coderneitui-coder

data-model-creation

Generate visual ER diagrams with automated foreign key management and field type mapping.

Community
Advanced