lehuuhau1231/techjobs/database-design

Name: database-design
Author: lehuuhau1231

Claude Code and agent skill by lehuuhau1231/techjobs

Trust tier 3

community

By lehuuhau1231
Data
lehuuhau1231/techjobs
tech-job-client/.agent/skills/database-design/SKILL.md
Updated 5 Oct 2026
Version 1.0.01 version recorded

Source check pending

Checking that the SKILL.md file is still in the repository.

Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.

Install

npx vskill@latest install lehuuhau1231/techjobs/database-design

SKILL.md

The same SKILL.md was published earlier as one-man-company/skills-contextmanager/database-design.

Database Design

Learn to THINK, not copy SQL patterns.

🎯 Selective Reading Rule

Read ONLY files relevant to the request! Check the content map, find what you need.

File	Description	When to Read
`database-selection.md`	PostgreSQL vs Neon vs Turso vs SQLite	Choosing database
`orm-selection.md`	Drizzle vs Prisma vs Kysely	Choosing ORM
`schema-design.md`	Normalization, PKs, relationships	Designing schema
`indexing.md`	Index types, composite indexes	Performance tuning
`optimization.md`	N+1, EXPLAIN ANALYZE	Query optimization
`migrations.md`	Safe migrations, serverless DBs	Schema changes

⚠️ Core Principle

ASK user for database preferences when unclear
Choose database/ORM based on CONTEXT
Don't default to PostgreSQL for everything

Decision Checklist

Before designing schema:

[ ] Asked user about database preference?
[ ] Chosen database for THIS context?
[ ] Considered deployment environment?
[ ] Planned index strategy?
[ ] Defined relationship types?

Anti-Patterns

❌ Default to PostgreSQL for simple apps (SQLite may suffice) ❌ Skip indexing ❌ Use SELECT * in production ❌ Store JSON when structured data is better ❌ Ignore N+1 queries

Security

Security scanPassed, 90 of 100Pattern checks on the skill's files.
Model reviewPassed

See the full security report

Quality evaluation

Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

See evaluation results

Source

SKILL.md in the repositoryCheckingtech-job-client/.agent/skills/database-design/SKILL.md

Popularity

7-day trend score: 5

Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

Claude Code
Cursor
GitHub Copilot
Windsurf
Codex
Gemini CLI
Cline
Amp
Roo Code
Goose
Continue
Kilo Code
Junie
Trae
OpenHands
Qwen Code
AI Agent
Tabnine Chat
Sourcegraph Cody
Amazon Q
Firebase Genkit
Sweep
Devin
Phind
Mentat
Claude Desktop
Aider
GPT Pilot
Plandex
bolt.new
v0
Replit Agent
Anse
TypingMind
BetterChatGPT
LibreChat
Warp AI
Pieces
Fig AI

Embed badge

[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/lehuuhau1231/techjobs/database-design/badge)](https://verified-skill.com/skills/lehuuhau1231/techjobs/database-design)

Something wrong with this skill or its page? Tell us.