database-design

Solid

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

Data & Documents 30 stars 7 forks Updated yesterday NOASSERTION

Install

View on GitHub

Quality Score: 76/100

Stars 20%

Recency 20%

100

Frontmatter 20%

Documentation 15%

Issue Health 10%

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: NOASSERTION

Integrates with

PostgreSQL · Database MongoDB · Database Redis · Database MySQL · Database

Similar Skills

Semantically similar based on skill content — not just same category

API & Backend Solid

database-patterns

Use when designing database schemas, implementing repository patterns, writing optimized queries, managing migrations, or working with indexes and transactions for SQL/NoSQL databases.

280 Updated 2 months ago

MadAppGang

Web & Frontend Solid

design

Designs modular high-level architectures from functional requirements and produces design documents for each module. Use when designing a new system, creating architecture documentation, or producing module-level design specs with integration contracts and test specifications.

423 Updated 1 months ago

vladikk

API & Backend Featured

design-postgis-tables

Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications

1,742 Updated 4 days ago

timescale

Web & Frontend Solid

design-dna

Extract, define, and apply design DNA across three dimensions: design system (tokens), design style (qualitative feel), and visual effects (Canvas, WebGL, 3D, particles, shaders, scroll effects, etc.). Use this skill when: (1) a user wants to see the full 3-dimension design structure/schema, (2) a user provides images, screenshots, or URLs of reference designs and wants them analyzed into a structured JSON profile covering all three dimensions, (3) a user has a Design DNA JSON and content and wants a design generated from it, or (4) any combination of these phases. Triggers on "design DNA", "extract design style", "analyze design", "design tokens from reference", "generate design from JSON", "design system from screenshot", "design profile", "style guide JSON", "visual effects analysis", "design with effects", "3d design analysis".

701 Updated 1 months ago

zanwei

Testing & QA Listed

dbt-coder

dbt (data build tool) patterns for model organization, incremental strategies, and testing.

39 Updated 1 weeks ago

majesticlabs-dev