database-design

Name: database-design
Author: Hnzsama

Gunakan prinsip:

by Hnzsama(0) 0 installs

Free

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Imported from Hnzsama/man-finansial-nya-diatur-ya (.gemini/skills/database-design/SKILL.md). Install upstream with npx skills add Hnzsama/man-finansial-nya-diatur-ya --skill database-design. Copyright stays with the author.

Database Design Rules

Gunakan prinsip:

normalization first
optimize later

Wajib

foreign key
indexes
timestamps
soft delete jika diperlukan

Jangan

menyimpan data yang dapat dihitung ulang
membuat kolom duplikat
menggunakan JSON tanpa alasan

Naming

Tables:

snake_case
plural

Columns:

snake_case

Foreign key:

user_id
wallet_id
category_id

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

# after Install: the listing is in your workspace's routing pool - a plan picks it for its slot
curl -s -X POST https://api.opensmartroute.ai/api/v1/route -H 'Authorization: Bearer $OSR_API_KEY' -H 'Content-Type: application/json' -d '{"text": "...", "plan": true}'

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

hnzsama-man-finansial-nya-diatur-ya-database-design.ocm.jsonjson

{
  "ocm": "1",
  "id": "hnzsama-man-finansial-nya-diatur-ya-database-design",
  "kind": "skill",
  "name": "database-design",
  "description": "Gunakan prinsip:",
  "publisher": "Hnzsama",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "github"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Gunakan prinsip:"
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github",
      "repository": "https://github.com/Hnzsama/man-finansial-nya-diatur-ya",
      "path": ".gemini/skills/database-design/SKILL.md",
      "ref": "53003492111cb96f2a86b8064bbbdf73797d2aab",
      "url": "https://github.com/Hnzsama/man-finansial-nya-diatur-ya/blob/53003492111cb96f2a86b8064bbbdf73797d2aab/.gemini/skills/database-design/SKILL.md",
      "key": "Hnzsama/man-finansial-nya-diatur-ya/.gemini/skills/database-design/SKILL.md"
    }
  },
  "instructions": "# Database Design Rules\n\nGunakan prinsip:\n\n- normalization first\n- optimize later\n\n---\n\n## Wajib\n\n- foreign key\n- indexes\n- timestamps\n- soft delete jika diperlukan\n\n---\n\n## Jangan\n\n- menyimpan data yang dapat dihitung ulang\n- membuat kolom duplikat\n- menggunakan JSON tanpa alasan\n\n---\n\n## Naming\n\nTables:\n\n- snake_case\n- plural\n\nColumns:\n\n- snake_case\n\nForeign key:\n\n- user_id\n- wallet_id\n- category_id",
  "cost": {
    "context_tokens": 101
  }
}

Fetch it by URL: GET /api/v1/registry/hnzsama-man-finansial-nya-diatur-ya-database-design/manifest?version=1.0.0