schema-design

Name: schema-design
Author: pwang347

Design a PostgreSQL schema for a new domain entity.

by pwang347(0) 0 installs

Free

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

See reviews

About

Imported from pwang347/slow-customizations (.claude/skills/schema-design/SKILL.md). Install upstream with npx skills add pwang347/slow-customizations --skill schema-design. Copyright stays with the author.

Schema Design

Design a PostgreSQL schema for a new domain entity.

Steps

Understand the context from $ARGUMENTS
Read relevant source files
Plan the approach
Implement the solution
Verify with tests

Resources

See reference.md for patterns and examples
See checklist.md for completion criteria

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.

pwang347-slow-customizations-schema-design.ocm.jsonjson

{
  "ocm": "1",
  "id": "pwang347-slow-customizations-schema-design",
  "kind": "skill",
  "name": "schema-design",
  "description": "Design a PostgreSQL schema for a new domain entity.",
  "publisher": "pwang347",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "github"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Design a PostgreSQL schema for a new domain entity."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github",
      "repository": "https://github.com/pwang347/slow-customizations",
      "path": ".claude/skills/schema-design/SKILL.md",
      "ref": "c0aaa61b8cc2479664507b573bbe2a850d0cb945",
      "url": "https://github.com/pwang347/slow-customizations/blob/c0aaa61b8cc2479664507b573bbe2a850d0cb945/.claude/skills/schema-design/SKILL.md",
      "key": "pwang347/slow-customizations/.claude/skills/schema-design/SKILL.md"
    }
  },
  "instructions": "# Schema Design\n\nDesign a PostgreSQL schema for a new domain entity.\n\n## Steps\n\n1. Understand the context from `$ARGUMENTS`\n2. Read relevant source files\n3. Plan the approach\n4. Implement the solution\n5. Verify with tests\n\n## Resources\n\n- See [reference.md](./reference.md) for patterns and examples\n- See [checklist.md](./checklist.md) for completion criteria",
  "cost": {
    "context_tokens": 90
  }
}

Fetch it by URL: GET /api/v1/registry/pwang347-slow-customizations-schema-design/manifest?version=1.0.0