fetch-meta-from-kb

Name: fetch-meta-from-kb
Author: tiangong-ai

Fetch recent `journals` rows directly from PostgreSQL and return a JSON array containing `doi`, `title`, `abstract`, and `date` (filtered by rolling `DAYS` on `created_at`). Use when users need raw pa

by tiangong-ai(0) 0 installs

Free

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

See reviews

About

Imported from tiangong-ai/agent-skills (fetch-meta-from-kb/SKILL.md). Install upstream with npx skills add tiangong-ai/agent-skills --skill fetch-meta-from-kb. Copyright stays with the author.

Fetch Meta from KB

Workflow

Read DB env vars from .env or process env: KB_DB_HOST, KB_DB_PORT, KB_DB_NAME, KB_DB_USER, KB_DB_PASSWORD.
Query journals where created_at >= now_utc - DAYS, ordered by created_at DESC, selecting only doi, title, abstract, date.
Return/write JSON array records with exactly these fields: doi, title, abstract, date.

Script

Run:

cd fetch-meta-from-kb
python3 scripts/fetch_meta_from_kb.py --days 7 --output selected-abstract.json

Env example:

KB_DB_HOST=<HOST>
KB_DB_PORT=5432
KB_DB_NAME=<DATABASE>
KB_DB_USER=<USER>
KB_DB_PASSWORD=<PASSWORD>

Output Rules

Return UTF-8 JSON.
Keep each item as: doi, title, abstract, date.
Do not output DB credentials.

# 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.

tiangong-ai-agent-skills-fetch-meta-from-kb.ocm.jsonjson

{
  "ocm": "1",
  "id": "tiangong-ai-agent-skills-fetch-meta-from-kb",
  "kind": "skill",
  "name": "fetch-meta-from-kb",
  "description": "Fetch recent `journals` rows directly from PostgreSQL and return a JSON array containing `doi`, `title`, `abstract`, and `date` (filtered by rolling `DAYS` on `created_at`). Use when users need raw paper payloads for downstream processing without LLM filtering or hotspot report generation.",
  "publisher": "tiangong-ai",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Fetch recent `journals` rows directly from PostgreSQL and return a JSON array containing `doi`, `title`, `abstract`, and `date` (filtered by rolling `DAYS` on `created_at`). Use when users need raw paper payloads for downstream processing without LLM filtering or hotspot report generation."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/tiangong-ai/agent-skills",
      "path": "fetch-meta-from-kb/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/tiangong-ai/agent-skills/blob/HEAD/fetch-meta-from-kb/SKILL.md",
      "key": "tiangong-ai/agent-skills/fetch-meta-from-kb/SKILL.md"
    }
  },
  "instructions": "# Fetch Meta from KB\n\n## Workflow\n\n1. Read DB env vars from `.env` or process env: `KB_DB_HOST`, `KB_DB_PORT`, `KB_DB_NAME`, `KB_DB_USER`, `KB_DB_PASSWORD`.\n2. Query `journals` where `created_at >= now_utc - DAYS`, ordered by `created_at DESC`, selecting only `doi`, `title`, `abstract`, `date`.\n3. Return/write JSON array records with exactly these fields: `doi`, `title`, `abstract`, `date`.\n\n## Script\n\nRun:\n\n```bash\ncd fetch-meta-from-kb\npython3 scripts/fetch_meta_from_kb.py --days 7 --output selected-abstract.json\n```\n\nEnv example:\n\n```dotenv\nKB_DB_HOST=<HOST>\nKB_DB_PORT=5432\nKB_DB_NAME=<DATA",
  "cost": {
    "context_tokens": 195
  }
}

Fetch it by URL: GET /api/v1/registry/tiangong-ai-agent-skills-fetch-meta-from-kb/manifest?version=1.0.0