Agent skill

Database Ops

by bkywksj in bkywksj/knowledge-base

Tauri 本地数据库操作技能,使用 rusqlite 进行 SQLite 数据库操作. An agent skill from bkywksj/knowledge-base.

Custom licenceAuto-check passedDatabases

Install Database Ops

skills CLI
$ npx skills add bkywksj/knowledge-base --skill database-ops -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install bkywksj/knowledge-base database-ops --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/bkywksj/knowledge-base.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.codex/skills/database-ops .claude/skills/database-ops && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
database-ops
GitHub stars
330
Token cost
~1.9k tokens
SKILL.md length
162 words
Files
1
Skills in repo
37
Repo updated
First seen
Licence
Custom licence

At a glance

Tauri 本地数据库操作技能,使用 rusqlite 进行 SQLite 数据库操作. An agent skill from bkywksj/knowledge-base.

  • Works in 4 steps: Database 层(数据访问) → Service 层(业务逻辑) → Command 层(IPC 接口) → …
  • Tasks that involve SQL
  • SKILL.md covers 核心架构, 技术方案:rusqlite (推荐), Database 结构设计 and Schema 迁移(PRAGMA user_version), plus 5 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Database Ops is an agent skill from bkywksj/knowledge-base. Tauri 本地数据库操作技能,使用 rusqlite 进行 SQLite 数据库操作。 触发场景: - 需要在桌面应用中持久化数据 - 需要使用 SQLite 数据库 - 需要设计本地数据表结构 - 需要执行 CRUD 数据库操作 触发词:数据库、SQLite、SQL、持久化、存储、表、查询、CRUD、数据

Its SKILL.md is about 1.9k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering SQL. It works with SQLite, Tauri, SQL and Rust. The repository describes itself as: 本地优先的知识库桌面应用。Markdown 编辑器 + 全文搜索(FTS5) + 双向链接 / 知识图谱;多端同步(WebDAV / S3 / 同步盘,单笔记粒度增量 + 自动双向调度,含整库 ZIP 备份);AI 问答与智能规划(OpenAI 兼容 / Ollama / 自定义 provider,工具调用框架);支持导入 .md / .txt /…

When your agent uses it

  • Tasks that involve SQL

Example prompts

  • “/database-ops”

Workflow steps

4 steps, taken from the step headings in SKILL.md.

  1. Database 层(数据访问)
  2. Service 层(业务逻辑)
  3. Command 层(IPC 接口)
  4. 前端调用

What it can do on your machine

Read from SKILL.md and the folder at commit deb640b. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are rust, toml, typescript and sql).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Database Ops loads about 1.9k tokens when it runs. Until then it costs about 43 tokens; SKILL.md has 162 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~43
When it runs · the whole SKILL.md, loaded when a task matches
~1.9k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 162 words (~1,867 tokens).

name
database-ops

Read the full SKILL.md on GitHub

Files

Just SKILL.md in .codex/skills/database-ops of bkywksj/knowledge-base.

Open the folder on GitHubat commit deb640b

Compare with similar skills

Database Ops next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Database Ops compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Database Ops this skillbkywksj/knowledge-base330—~1.9kAutomated safety check: PassCustom licence
Rust SQL Testshencangsheng/easydb_app590—~1.2kAutomated safety check: PassMIT
SQL Database Support for pRESTprest/prest4.6k—~1.6kAutomated safety check: PassMIT
Cursor BYOK Database Schemaleookun/cursor-byok3.2k—~1.3kAutomated safety check: PassMIT
Squixeduardofuncao/squix273—~784Automated safety check: PassMIT
Add Domain Fieldopenfootmanager/openfootmanager1.1k—~1.7kAutomated safety check: PassGPL-3.0

Similar skills

  • Rust SQL Test

    shencangsheng/easydb_app

    Enforces unit test requirements for the Rust data-processing modules in src-tauri/src/sql/ (generator.rs, parse.rs) and src-tauri/src/reader/ (excel.rs and other readers).

    590 GitHub stars~1.2k tokensUpdated 1 mo ago
    Documents & OfficeAuto-check passed
  • Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects.

    4.6k GitHub stars~1.6k tokensUpdated today
    DatabasesAuto-check passed
  • Cursor BYOK Database Schema

    leookun/cursor-byok

    Guides SQLite schema changes in the Cursor BYOK server, keeping SQLx migrations, the Rust store, API contracts and fixtures aligned.

    3.2k GitHub stars~1.3k tokensUpdated today
    DatabasesAuto-check passed
  • Squix

    eduardofuncao/squix

    Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI.

    273 GitHub stars~784 tokensUpdated 15 days ago
    DatabasesAuto-check passed
  • Add Domain Field

    openfootmanager/openfootmanager

    Add a field to a domain type so it survives save/load. An agent skill from openfootmanager/openfootmanager.

    1.1k GitHub stars~1.7k tokensUpdated today
    DatabasesAuto-check passed
  • Diesel Guard

    ayarotsky/diesel-guard

    Lints Diesel and SQLx Postgres migrations for unsafe schema changes that lock tables or cause downtime, and authors custom Rhai checks.

    121 GitHub stars~3.1k tokensUpdated 9 days ago
    DatabasesAuto-check passed

More from bkywksj/knowledge-base

All 37 skills in this repo
  • Collaborating With Codex

    bkywksj/knowledge-base

    当用户明确点名要用 OpenAI Codex CLI 协同时使用此 Skill,把指定任务委托给 Codex 执行并整合结果。

    330 GitHub stars~1.1k tokensUpdated 5 days ago
    Auto-check passed
  • Collaborating With Gemini

    bkywksj/knowledge-base

    当用户明确点名要用 Google Gemini CLI 协同时使用此 Skill,把指定任务委托给 Gemini 执行并整合结果。

    330 GitHub stars~1.5k tokensUpdated 5 days ago
    Auto-check passed
  • AI Profile Integration

    bkywksj/knowledge-base

    用于本项目中与 ai-profile crate 相关的开发:模型服务预置、ai.profile 导入导出、「获取」零成本验证、上下文窗口限额。

    330 GitHub stars~2.1k tokensUpdated 5 days ago
    Auto-check passed
  • API Development

    bkywksj/knowledge-base

    Tauri Command (IPC API) 开发技能,指导如何设计和实现 Rust Command 供前端调用. An agent skill from bkywksj/knowledge-base.

    330 GitHub stars~2.9k tokensUpdated 5 days ago
    Auto-check passed
  • Architecture Design

    bkywksj/knowledge-base

    Tauri 架构设计技能,指导双进程架构下的模块拆分和代码组织. An agent skill from bkywksj/knowledge-base.

    330 GitHub stars~1k tokensUpdated 5 days ago
    Auto-check passed
  • Brainstorm

    bkywksj/knowledge-base

    当需要探索方案、头脑风暴、创意思维时自动使用此 Skill. An agent skill from bkywksj/knowledge-base.

    330 GitHub stars~1.4k tokensUpdated 5 days ago
    Auto-check passed

Categories

Questions about Database Ops

What does Database Ops do?

Tauri 本地数据库操作技能,使用 rusqlite 进行 SQLite 数据库操作. An agent skill from bkywksj/knowledge-base. Database Ops is an agent skill from bkywksj/knowledge-base.

When should I use Database Ops?

Database Ops fits situations like: tasks that involve SQL.

How do I install Database Ops in Claude Code?

Run `npx skills add bkywksj/knowledge-base --skill database-ops -a claude-code`. Or copy the skill folder (.codex/skills/database-ops in bkywksj/knowledge-base) into .claude/skills/database-ops in your project. Claude Code loads it when a task matches its description.

How do I install Database Ops in Codex?

Run `npx skills add bkywksj/knowledge-base --skill database-ops -a codex`. Or copy the skill folder (.codex/skills/database-ops in bkywksj/knowledge-base) into .agents/skills/database-ops in your project. Codex loads it when a task matches its description.

Can I use Database Ops in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add bkywksj/knowledge-base --skill database-ops -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database-ops, .gemini/skills/database-ops, .github/skills/database-ops and .opencode/skills/database-ops in your project.

What does Database Ops need to run?

SKILL.md names no scripts, command-line tools or credentials: Database Ops is instructions for the agent only.

Does Database Ops access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Database Ops safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Database Ops use?

Database Ops has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does Database Ops use?

About 1.9k tokens (SKILL.md is roughly 7.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Database Ops?

Skills that share tags, products or a category with Database Ops: Rust SQL Test (shencangsheng/easydb_app, 590 stars), SQL Database Support for pREST (prest/prest, 4.6k stars), Cursor BYOK Database Schema (leookun/cursor-byok, 3.2k stars) and Squix (eduardofuncao/squix, 273 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Database Ops?

bkywksj (a GitHub user) maintains it in bkywksj/knowledge-base, which has 330 GitHub stars. The repository holds 37 skills in this directory. The repository was last updated on October 2, 2026.

Source: bkywksj/knowledge-base on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.