Database design, queries, optimization, and schema management. Use when working with databases.
47 stars
0 votes
0 copies
10 views
Added September 12, 2026
databasesdatabase
Security analysis
A100/100
Scanned September 12, 2026
$npx -y skills add skeletorflet/opencode-supreme-setup --skill db --agent claude-code
Installs into .claude/skills of the current project.
Are you the author of Db?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/skeletorflet-opencode-supreme-setup-opencode-supreme-setup)
---
name: db
description: Database design, queries, optimization, and schema management. Use when working with databases.
---
## db
Design and optimize databases.
### Design principles
- Normalize to reduce redundancy
- Appropriate data types
- Index WHERE, JOIN, ORDER BY columns
- Foreign keys for integrity
- Migration scripts
### Query optimization
- EXPLAIN ANALYZE to check plans
- Avoid SELECT *
- LIMIT results
- JOINs over subqueries
- Batch in transactions
