Skip to content
Development
Skill

/database

Database architecture, schema design, and index planning

From plugin
pudo-code-system
538 skills1 agent

Claude Code

$ npx -y skills add DongDuong2001/pudo-code-system --skill database --agent claude-code

SKILL.md

database.SKILL.md
name: database-plan
description: Database architecture, schema design, and index planning

Database Planning Skill

This skill is essential when designing data storage solutions and defining schema boundaries.

When to use this skill

  • When determining whether to use SQL vs NoSQL vs Time-Series databases.
  • When designing entity-relationship diagrams (ERD) schemas.
  • When planning indexing, partitioning, or sharding strategies.

Guidelines

  • Normalize data by default to reduce redundancy, but denormalize strategically for read-heavy performance bottlenecks.
  • Plan indexes based on expected query patterns, not just foreign keys. Remember that excessive indexing slows down write operations.
  • Avoid using UUIDs/GUIDs as primary clustered keys in massive tables where sequential inserts are critical for performance, unless mitigated by the DB engine.
@dongduong2001
Ships withpudo-code-system

Modular, scalable, automated development intelligence.

538 skills1 agent
Get the whole plugin

Stars on GitHub

Momentum

stars in total
5
Star history of DongDuong2001/pudo-code-system on GitHub, a chart by star-history.com

Other skills on pudo-code-system.

pudo

pudo

PUDO workflow: Plan -> Understand -> Develop -> Optimize. Use on any non-trivial coding task (features, bug fixes, refactors,…

fastapi

fastapi

- [ ] **API Design:** Define RESTful endpoints, path parameters, and query parameters. - [ ] **Data Validation:** Plan Pydantic…

rust

rust

- [ ] **Framework Selection:** Choose web framework (Axum, Actix-web) based on performance vs. ecosystem needs. - [ ] **Crate…

More skills from other plugins.

brainstorming
Auto-invoked

brainstorming

You MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or…

@obra@obraInstall Skill
ask-matt

ask-matt

Ask which skill or flow fits your situation. A router over the skills in this repo.

skills10d309k
@mattpocock@mattpocockInstall Skill
accessibility
Auto-invoked

accessibility

Design, implement, and audit accessible UI to WCAG 2.2 Level AA across Web, iOS, and Android — semantic ARIA roles and labels,…

ecc12d293k
@affaan-m@affaan-mInstall Skill
compiler-commit

compiler-commit

Use when you want to verify compiler changes and commit with the correct convention. Runs tests, lint, and format, then commits…

react1d252k
@facebook@facebookInstall Skill

Questions about database.

Which coding agents can use database?
database installs in Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, OpenCode and Windsurf with the skills CLI, using each agent's flag shown on this page. Flowy's auto-invocation, which fires a skill when your prompt matches, runs in Claude Code only.