database-design

Solid

Tier 2: Database design and modeling. ER diagrams, schema design, normalization, optimization. Keywords: database design, schema, ER diagram, normalization, 数据库设计, 数据建模

Data & Documents 41 stars 7 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 87/100

Stars 20%
54
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
36
Issue Health 10%
80
License 10%
100
Description 5%
100

Skill Content

# Database Design ## Overview Database design and data modeling. ## Key Capabilities - Entity-Relationship (ER) modeling - Schema design - Normalization (1NF to 5NF) - Denormalization for performance - Indexing strategy - Query optimization ## Supported Databases - Relational: PostgreSQL, MySQL, SQL Server - NoSQL: MongoDB, Redis, Cassandra - NewSQL: CockroachDB, TiDB - Graph: Neo4j ## Process Flow 1. **Model** - Create ER diagram 2. **Normalize** - Apply normalization rules 3. **Optimize** - Indexing and query optimization 4. **Schema** - Generate schema DDL 5. **Document** - Database documentation ## Output Artifacts - ER diagram - Database schema - DDL scripts - Indexing strategy - Query optimization guide

Details

Author
badhope
Repository
badhope/skill
Created
3 months ago
Last Updated
yesterday
Language
TypeScript
License
MIT

Integrates with

OpenAI · AI Anthropic · AI PostgreSQL · Database MongoDB · Database Redis · Database MySQL · Database Tailwind CSS · Frontend

Similar Skills

Semantically similar based on skill content — not just same category

Data & Documents Listed

database-design

Tier 2: Database design and modeling. ER diagrams, schema design, normalization, optimization. Keywords: database design, schema, ER diagram, normalization, 数据库设计, 数据建模

9 Updated today
gabrielmoreira
Data & Documents Listed

database

Database design, SQL, NoSQL, and data management

0 Updated today
murtazatouqeer
API & Backend Solid

database-design

Designs database schemas, indexing strategies, query optimization, and migration patterns for SQL and NoSQL databases. Use when designing tables, optimizing queries, fixing N+1 problems, planning migrations, or when asked about database performance, normalization, ORMs, or data modeling.

1,367 Updated 2 days ago
CloudAI-X