rajbos/jarvis/check-db

Claude Code and agent skill by rajbos/jarvis

Trust tier 2
  • community
LLM review pending
Source check pending

Checking that the SKILL.md file is still in the repository.

Inspect the live Jarvis SQLite database to check the schema migration version and list all tables. Use this when verifying a migration ran correctly, checking what tables exist before writing a new migration, confirming the user_version matches the expected schema, or debugging "table not found" errors at runtime.

Install

npx vskill@latest install rajbos/jarvis/check-db

SKILL.md

Check Jarvis Database

Run check-db.js from the repo root to inspect %APPDATA%\jarvis\jarvis.db without starting the app.

How to run

shell
node check-db.js

What it outputs

  • user_version — the current schema migration number (set by PRAGMA user_version in src/storage/schema.ts)
  • tables — comma-separated list of all tables in sqlite_master

Example output

user_version: 3
tables: chat_messages, github_repos, notifications, secrets, settings

When to use this skill

SituationWhat to look for
After changing src/storage/schema.tsuser_version incremented; new table/column exists
Before adding a migrationConfirm current user_version so the next one is N+1
"Table not found" error at runtimeCheck whether the table is actually present
Suspecting a corrupt or stale DBSee all tables at a glance

Script source

The full script is at check-db.js in this skill folder:

js
const initSqlJs = require('./node_modules/sql.js');
const fs = require('fs');
const path = require('path');
const dbPath = path.join(process.env.APPDATA, 'jarvis', 'jarvis.db');
initSqlJs().then(SQL => {
  const buf = fs.readFileSync(dbPath);
  const db = new SQL.Database(buf);
  const ver = db.exec('PRAGMA user_version')[0].values[0][0];
  const tables = db.exec("SELECT name FROM sqlite_master WHERE type='table' ORDER BY name");
  const tableNames = tables.length > 0 ? tables[0].values.map(r => r[0]) : [];
  console.log('user_version:', ver);
  console.log('tables:', tableNames.join(', '));
  db.close();
});

Security

  • Security scanPassed, 100 of 100Pattern checks on the skill's files.
  • Model reviewNot runA model review is scheduled for the next rescan.

See the full security report

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

See evaluation results

Source

Popularity

7-day trend score
5

Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/rajbos/jarvis/check-db/badge)](https://verified-skill.com/skills/rajbos/jarvis/check-db)

Something wrong with this skill or its page? Tell us.