Skip to content
Skillv1.0.0

opencode

opencode database guide

by xiaomu120413(0) 0 installs
Free
Sign in to install

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

See reviews

About

Imported from xiaomu120413/ho-llm-cli-refactor (packages/ho-cli/vendor/opencode-workspace/packages/opencode/AGENTS.md). Install upstream with npx skills add xiaomu120413/ho-llm-cli-refactor --skill opencode. Copyright stays with the author.

opencode database guide

Database

  • Schema: Drizzle schema lives in src/**/*.sql.ts.
  • Naming: tables and columns use snake*case; join columns are <entity>_id; indexes are <table>*<column>\_idx.
  • Migrations: generated by Drizzle Kit using drizzle.config.ts (schema: ./src/**/*.sql.ts, output: ./migration).
  • Command: bun run db generate --name <slug>.
  • Output: creates migration/<timestamp>_<slug>/migration.sql and snapshot.json.
  • Tests: migration tests should read the per-folder layout (no _journal.json).

Use it

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

yaml
targets:
  - https://api.opensmartroute.ai/api/v1/registry/xiaomu120413-ho-llm-cli-refactor-opencode/manifest   # or paste the manifest below

Manifest

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

xiaomu120413-ho-llm-cli-refactor-opencode.ocm.jsonjson
{
  "ocm": "1",
  "id": "xiaomu120413-ho-llm-cli-refactor-opencode",
  "kind": "skill",
  "name": "opencode",
  "description": "opencode database guide",
  "publisher": "xiaomu120413",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "github-agents"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "opencode database guide"
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github-agents",
      "repository": "https://github.com/xiaomu120413/ho-llm-cli-refactor",
      "path": "packages/ho-cli/vendor/opencode-workspace/packages/opencode/AGENTS.md",
      "ref": "3b1cba862d925009643063602433bab7f4be7e9b",
      "url": "https://github.com/xiaomu120413/ho-llm-cli-refactor/blob/3b1cba862d925009643063602433bab7f4be7e9b/packages/ho-cli/vendor/opencode-workspace/packages/opencode/AGENTS.md",
      "key": "xiaomu120413/ho-llm-cli-refactor/packages/ho-cli/vendor/opencode-workspace/packages/opencode/AGENTS.md"
    }
  },
  "instructions": "# opencode database guide\n\n## Database\n\n- **Schema**: Drizzle schema lives in `src/**/*.sql.ts`.\n- **Naming**: tables and columns use snake*case; join columns are `<entity>_id`; indexes are `<table>*<column>\\_idx`.\n- **Migrations**: generated by Drizzle Kit using `drizzle.config.ts` (schema: `./src/**/*.sql.ts`, output: `./migration`).\n- **Command**: `bun run db generate --name <slug>`.\n- **Output**: creates `migration/<timestamp>_<slug>/migration.sql` and `snapshot.json`.\n- **Tests**: migration tests should read the per-folder layout (no `_journal.json`).",
  "cost": {
    "context_tokens": 140
  }
}

Fetch it by URL: GET /api/v1/registry/xiaomu120413-ho-llm-cli-refactor-opencode/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.