db-query-migration-db

Name: db-query-migration-db
Author: Son-Dam

Query postgresql database (migration-db)

by Son-Dam(0) 0 installs

Free

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

See reviews

About

Imported from Son-Dam/agents (tests/fixtures/sample_repo/.github/skills/db-query-migration-db/SKILL.md). Install upstream with npx skills add Son-Dam/agents --skill db-query-migration-db. Copyright stays with the author.

Database Query — postgresql (migration-db)

Runs queries against the postgresql database via $DATABASE_URL.

Check Tables

Available tables: users, orders

Row Count

psql $DATABASE_URL -c 'SELECT COUNT(*) FROM users'

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.

son-dam-agents-db-query-migration-db.ocm.jsonjson

{
  "ocm": "1",
  "id": "son-dam-agents-db-query-migration-db",
  "kind": "skill",
  "name": "db-query-migration-db",
  "description": "Query postgresql database (migration-db)",
  "publisher": "Son-Dam",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "data_analysis"
    ],
    "tags": [
      "skill-md",
      "github"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Query postgresql database (migration-db)"
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github",
      "repository": "https://github.com/Son-Dam/agents",
      "path": "tests/fixtures/sample_repo/.github/skills/db-query-migration-db/SKILL.md",
      "ref": "c43484c580059674cad45969c27e486a347f3332",
      "url": "https://github.com/Son-Dam/agents/blob/c43484c580059674cad45969c27e486a347f3332/tests/fixtures/sample_repo/.github/skills/db-query-migration-db/SKILL.md",
      "key": "Son-Dam/agents/tests/fixtures/sample_repo/.github/skills/db-query-migration-db/SKILL.md"
    }
  },
  "instructions": "# Database Query — postgresql (migration-db)\n\nRuns queries against the postgresql database via `$DATABASE_URL`.\n\n## Check Tables\nAvailable tables: `users, orders`\n\n## Row Count\n```bash\npsql $DATABASE_URL -c 'SELECT COUNT(*) FROM users'\n```",
  "cost": {
    "context_tokens": 59
  }
}

Fetch it by URL: GET /api/v1/registry/son-dam-agents-db-query-migration-db/manifest?version=1.0.0