Can I use this for NoSQL databases?

While it mentions JSON fields for semi-structured data, this skill is specifically optimized for relational (SQL) database design and integrity.

Does it integrate with ORMs like Prisma or TypeORM?

Yes, one of the key steps in its process is adapting the conceptual design into the specific syntax of the ORM used in your project.

Does it automatically create indices?

It suggests indices based on foreign keys and expected query patterns (WHERE, JOIN, ORDER BY) rather than applying them blindly to every column.

Can it help me normalize an existing messy database?

Absolutely. It can analyze current table structures and suggest steps to reach Third Normal Form (3NF) to reduce redundancy.

Does this skill support specific database engines?

Yes, it focuses on universal relational principles applicable to PostgreSQL, MySQL, and SQLite, and can adapt the output to various ORMs.

Database Schema Design

Name: Database Schema Design
Author: 686f6c61

by686f6c61

•

데이터베이스 관리

Designs normalized relational database schemas with optimized indices, integrity constraints, and comprehensive documentation.

This skill streamlines the creation of robust relational database models by translating functional requirements into well-structured schemas. It enforces 3NF normalization, consistent naming conventions, and strategic indexing to ensure high performance and data integrity. Ideal for both new projects and refactoring legacy systems, the skill also assists in mapping designs to modern ORMs like Prisma, Drizzle, or SQLAlchemy and logging key architectural decisions for long-term maintenance and team alignment.

주요 기능

01Strategic index optimization based on query patterns

0237 GitHub stars

03Automatic 3NF normalization to ensure data integrity

04Cardinality and relationship mapping (1:1, 1:N, N:M)

05Cross-ORM compatibility for Prisma, Drizzle, and more

06Standardized naming conventions and audit logging

사용 사례

01Refactoring legacy tables to eliminate data redundancy

02Designing a scalable schema for a new SaaS application

03Generating migration-ready ORM models from business logic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add 686f6c61/alfred-dev datos

For use in Claude.ai and ChatGPT

Download Skill