← All skills

database-patterns

100 / 100 · Low risk

Fine to try.

By yanacuti1121/Yana-AI (GitHub) · coding · 13 stars · scanned at commit 54d4aa9

Design and optimize relational database schemas — normalization, indexing strategy, query optimization, N+1 elimination, pagination patterns, and migration safety. Use when asked to "design a schema", "fix slow queries", "add an index", "N+1 problem", "paginate results", "write a migration", or "database is slow". Covers PostgreSQL/MySQL patterns. Do NOT use for: NoSQL document design — that requires a separate approach. Do NOT use for: frontend performance.

Works with any agent that supports SKILL.md skills.

What this skill can do

We found nothing in the files we read that matches our rules. That does not prove the skill is safe: see the limits of static scanning.

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'database-patterns' ] || [ -L ~/.agents/skills/'database-patterns' ]; then echo 'A skill folder named database-patterns already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/yanacuti1121/Yana-AI' "$d" && git -C "$d" checkout --quiet '54d4aa9fa3241319f4d37212bd23826658bf6bed' -- '.claude/skills/database-patterns' && mkdir -p ~/.agents/skills && cp -R "$d"/'.claude/skills/database-patterns' ~/.agents/skills/'database-patterns' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'database-patterns' ~/.claude/skills/'database-patterns' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for yanacuti1121/Yana-AI shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/yanacuti1121/Yana-AI.svg)](https://zalavijaysinh.github.io/skilltrust/repos/yanacuti1121/Yana-AI/)

Score history

Also found in

Identical copies of this skill exist at:

• yanacuti1121/Yana-AI/core/skills/database-patterns