{"id":"32d2503f-2b38-44ad-882a-d4a17855ae32","shortId":"D4rHrE","kind":"skill","title":"database-design","tagline":"Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.","description":"# Database Design\n\n> **Learn to THINK, not copy SQL patterns.**\n\n## 🎯 Selective Reading Rule\n\n**Read ONLY files relevant to the request!** Check the content map, find what you need.\n\n| File | Description | When to Read |\n|------|-------------|--------------|\n| `database-selection.md` | PostgreSQL vs Neon vs Turso vs SQLite | Choosing database |\n| `orm-selection.md` | Drizzle vs Prisma vs Kysely | Choosing ORM |\n| `schema-design.md` | Normalization, PKs, relationships | Designing schema |\n| `indexing.md` | Index types, composite indexes | Performance tuning |\n| `optimization.md` | N+1, EXPLAIN ANALYZE | Query optimization |\n| `migrations.md` | Safe migrations, serverless DBs | Schema changes |\n\n---\n\n## ⚠️ Core Principle\n\n- ASK user for database preferences when unclear\n- Choose database/ORM based on CONTEXT\n- Don't default to PostgreSQL for everything\n\n---\n\n## Decision Checklist\n\nBefore designing schema:\n\n- [ ] Asked user about database preference?\n- [ ] Chosen database for THIS context?\n- [ ] Considered deployment environment?\n- [ ] Planned index strategy?\n- [ ] Defined relationship types?\n\n---\n\n## Anti-Patterns\n\n❌ Default to PostgreSQL for simple apps (SQLite may suffice)\n❌ Skip indexing\n❌ Use SELECT * in production\n❌ Store JSON when structured data is better\n❌ Ignore N+1 queries\n\n## When to Use\nThis skill is applicable to execute the workflow or actions described in the overview.\n\n## Limitations\n- Use this skill only when the task clearly matches the scope described above.\n- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.\n- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.","tags":["database","design","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows"],"capabilities":["skill","source-sickn33","skill-database-design","topic-agent-skills","topic-agentic-skills","topic-ai-agent-skills","topic-ai-agents","topic-ai-coding","topic-ai-workflows","topic-antigravity","topic-antigravity-skills","topic-claude-code","topic-claude-code-skills","topic-codex-cli","topic-codex-skills"],"categories":["antigravity-awesome-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/database-design","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add sickn33/antigravity-awesome-skills","source_repo":"https://github.com/sickn33/antigravity-awesome-skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 37911 github stars · SKILL.md body (1,724 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T18:50:54.252Z","embedding":null,"createdAt":"2026-04-18T20:32:39.484Z","updatedAt":"2026-05-18T18:50:54.252Z","lastSeenAt":"2026-05-18T18:50:54.252Z","tsv":"'+1':84,168 'action':182 'analyz':86 'anti':142 'anti-pattern':141 'app':149 'applic':176 'ask':98,122,220 'base':107 'better':165 'boundari':228 'chang':95 'check':38 'checklist':118 'choos':59,67,105 'chosen':127 'clarif':222 'clear':195 'composit':78 'consid':132 'content':40 'context':109,131 'copi':25 'core':96 'criteria':231 'data':163 'databas':2,4,18,19,60,101,125,128 'database-design':1 'database-selection.md':51 'database/orm':106 'dbs':93 'decis':9,117 'decision-mak':8 'default':112,144 'defin':138 'deploy':133 'describ':183,199 'descript':47 'design':3,5,12,20,73,120 'drizzl':62 'environ':134,211 'environment-specif':210 'everyth':116 'execut':178 'expert':216 'explain':85 'file':33,46 'find':42 'ignor':166 'index':13,76,79,136,154 'indexing.md':75 'input':225 'json':160 'kyse':66 'learn':21 'limit':187 'make':10 'map':41 'match':196 'may':151 'migrat':91 'migrations.md':89 'miss':233 'n':83,167 'need':45 'neon':54 'normal':70 'optim':88 'optimization.md':82 'orm':15,68 'orm-selection.md':61 'output':205 'overview':186 'pattern':27,143 'perform':80 'permiss':226 'pks':71 'plan':135 'postgresql':52,114,146 'prefer':102,126 'principl':6,97 'prisma':64 'product':158 'queri':87,169 'read':29,31,50 'relationship':72,139 'relev':34 'request':37 'requir':224 'review':217 'rule':30 'safe':90 'safeti':227 'schema':11,74,94,121 'schema-design.md':69 'scope':198 'select':16,28,156 'serverless':17,92 'simpl':148 'skill':174,190 'skill-database-design' 'skip':153 'source-sickn33' 'specif':212 'sql':26 'sqlite':58,150 'stop':218 'store':159 'strategi':14,137 'structur':162 'substitut':208 'success':230 'suffic':152 'task':194 'test':214 'think':23 'topic-agent-skills' 'topic-agentic-skills' 'topic-ai-agent-skills' 'topic-ai-agents' 'topic-ai-coding' 'topic-ai-workflows' 'topic-antigravity' 'topic-antigravity-skills' 'topic-claude-code' 'topic-claude-code-skills' 'topic-codex-cli' 'topic-codex-skills' 'treat':203 'tune':81 'turso':56 'type':77,140 'unclear':104 'use':155,172,188 'user':99,123 'valid':213 'vs':53,55,57,63,65 'workflow':180","prices":[{"id":"56ad6290-77e5-460b-8fd8-0218e442a1a4","listingId":"32d2503f-2b38-44ad-882a-d4a17855ae32","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"sickn33","category":"antigravity-awesome-skills","install_from":"skills.sh"},"createdAt":"2026-04-18T20:32:39.484Z"}],"sources":[{"listingId":"32d2503f-2b38-44ad-882a-d4a17855ae32","source":"github","sourceId":"sickn33/antigravity-awesome-skills/database-design","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-design","isPrimary":false,"firstSeenAt":"2026-04-18T21:35:39.299Z","lastSeenAt":"2026-05-18T18:50:54.252Z"},{"listingId":"32d2503f-2b38-44ad-882a-d4a17855ae32","source":"skills_sh","sourceId":"sickn33/antigravity-awesome-skills/database-design","sourceUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/database-design","isPrimary":true,"firstSeenAt":"2026-04-18T20:32:39.484Z","lastSeenAt":"2026-05-07T22:40:34.390Z"}],"details":{"listingId":"32d2503f-2b38-44ad-882a-d4a17855ae32","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"database-design","github":{"repo":"sickn33/antigravity-awesome-skills","stars":37911,"topics":["agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows","antigravity","antigravity-skills","claude-code","claude-code-skills","codex-cli","codex-skills","cursor","cursor-skills","developer-tools","gemini-cli","gemini-skills","kiro","mcp","skill-library"],"license":"mit","html_url":"https://github.com/sickn33/antigravity-awesome-skills","pushed_at":"2026-05-18T08:24:49Z","description":"Installable GitHub library of 1,400+ agentic skills for Claude Code, Cursor, Codex CLI, Gemini CLI, Antigravity, and more. Includes installer CLI, bundles, workflows, and official/community skill collections.","skill_md_sha":"592197fb4d96bffae59aeb866f87730d00ab5ba3","skill_md_path":"skills/database-design/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-design"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"name":"database-design","description":"Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/database-design"},"updatedAt":"2026-05-18T18:50:54.252Z"}}