{"id":"32d2503f-2b38-44ad-882a-d4a17855ae32","shortId":"D4rHrE","kind":"skill","title":"Database Design","tagline":"Antigravity Awesome Skills skill by Sickn33","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"],"capabilities":["skill","source-sickn33","category-antigravity-awesome-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":{"install_from":"skills.sh"}},"qualityScore":"0.300","qualityRationale":"deterministic score 0.30 from registry signals: · indexed on skills.sh · published under sickn33/antigravity-awesome-skills","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:v1","enrichmentVersion":1,"enrichedAt":"2026-04-25T11:40:42.259Z","embedding":null,"createdAt":"2026-04-18T20:32:39.484Z","updatedAt":"2026-04-25T11:40:42.259Z","lastSeenAt":"2026-04-25T11:40:42.259Z","tsv":"'+1':74,158 'action':172 'analyz':76 'anti':132 'anti-pattern':131 'antigrav':3 'app':139 'applic':166 'ask':88,112,210 'awesom':4 'base':97 'better':155 'boundari':218 'category-antigravity-awesome-skills' 'chang':85 'check':28 'checklist':108 'choos':49,57,95 'chosen':117 'clarif':212 'clear':185 'composit':68 'consid':122 'content':30 'context':99,121 'copi':15 'core':86 'criteria':221 'data':153 'databas':1,9,50,91,115,118 'database-selection.md':41 'database/orm':96 'dbs':83 'decis':107 'default':102,134 'defin':128 'deploy':123 'describ':173,189 'descript':37 'design':2,10,63,110 'drizzl':52 'environ':124,201 'environment-specif':200 'everyth':106 'execut':168 'expert':206 'explain':75 'file':23,36 'find':32 'ignor':156 'index':66,69,126,144 'indexing.md':65 'input':215 'json':150 'kyse':56 'learn':11 'limit':177 'map':31 'match':186 'may':141 'migrat':81 'migrations.md':79 'miss':223 'n':73,157 'need':35 'neon':44 'normal':60 'optim':78 'optimization.md':72 'orm':58 'orm-selection.md':51 'output':195 'overview':176 'pattern':17,133 'perform':70 'permiss':216 'pks':61 'plan':125 'postgresql':42,104,136 'prefer':92,116 'principl':87 'prisma':54 'product':148 'queri':77,159 'read':19,21,40 'relationship':62,129 'relev':24 'request':27 'requir':214 'review':207 'rule':20 'safe':80 'safeti':217 'schema':64,84,111 'schema-design.md':59 'scope':188 'select':18,146 'serverless':82 'sickn33':8 'simpl':138 'skill':5,6,164,180 'skip':143 'source-sickn33' 'specif':202 'sql':16 'sqlite':48,140 'stop':208 'store':149 'strategi':127 'structur':152 'substitut':198 'success':220 'suffic':142 'task':184 'test':204 'think':13 'treat':193 'tune':71 'turso':46 'type':67,130 'unclear':94 'use':145,162,178 'user':89,113 'valid':203 'vs':43,45,47,53,55 'workflow':170","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-04-25T06:50:57.699Z"},{"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-04-25T11:40:42.259Z"}],"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","source":"skills_sh","category":"antigravity-awesome-skills","skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/database-design"},"updatedAt":"2026-04-25T11:40:42.259Z"}}