sql

Name: sql
Author: verdverm

We have two databases

by verdverm(0) 0 installs

Free

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

See reviews

About

Instruction file imported from verdverm/atmunge (.github/instructions/sql.instructions.md). Copyright stays with the author.

We have two databases

(app) is a postgres database managed with Gorm
(acct) is a duckdb database managed with raw SQL

You can arbitrary queries on acct with the acct query command.

We have the following SQL files. They are embedded into the Go program in ./pkg/sql/embed.go

./ pkg/ sql/ acct/ index/ 0100_extract_refs.sql migrations/ 0001_init.sql query/ count_likes_by_did.sql count_records.sql count_records_by_nsid.sql count_refs_by_nsid.sql hack.sql refs-test.sql

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.

verdverm-atmunge-sql-instructions.ocm.jsonjson

{
  "ocm": "1",
  "id": "verdverm-atmunge-sql-instructions",
  "kind": "skill",
  "name": "sql",
  "description": "We have two databases",
  "publisher": "verdverm",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "coding",
      "data_analysis"
    ],
    "tags": [
      "skill-md",
      "github-instructions"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "We have two databases"
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github-instructions",
      "repository": "https://github.com/verdverm/atmunge",
      "path": ".github/instructions/sql.instructions.md",
      "ref": "795df36ac381833f329660ee3552d3e4dc150772",
      "url": "https://github.com/verdverm/atmunge/blob/795df36ac381833f329660ee3552d3e4dc150772/.github/instructions/sql.instructions.md",
      "key": "verdverm/atmunge/.github/instructions/sql.instructions.md"
    },
    "applies_to": "**/*.sql"
  },
  "instructions": "We have two databases\n\n1. (app) is a postgres database managed with Gorm\n2. (acct) is a duckdb database managed with raw SQL\n\nYou can arbitrary queries on acct with the `acct query` command.\n\nWe have the following SQL files.\nThey are embedded into the Go program in `./pkg/sql/embed.go`\n\n./\n  pkg/\n    sql/\n      acct/\n        index/\n          0100_extract_refs.sql\n        migrations/\n          0001_init.sql\n        query/\n          count_likes_by_did.sql\n          count_records.sql\n          count_records_by_nsid.sql\n          count_refs_by_nsid.sql\n          hack.sql\n          refs-test.sql",
  "cost": {
    "context_tokens": 149
  }
}

Fetch it by URL: GET /api/v1/registry/verdverm-atmunge-sql-instructions/manifest?version=1.0.0

About

Use it

Manifest

Reviews