Agent skill

Sqlite Guide Skill

by jiushiwon in jiushiwon/wg-skills

SQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。

Apache-2.0Auto-check passedDatabases

Install Sqlite Guide Skill

skills CLI
$ npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a claude-code

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

GitHub CLI
$ gh skill install jiushiwon/wg-skills sqlite-guide-skill --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/jiushiwon/wg-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/vibeCoding/backend/database/sqlite-guide-skill .claude/skills/sqlite-guide-skill && 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
sqlite-guide-skill
GitHub stars
110
Token cost
~908 tokens
SKILL.md length
55 words
Files
5 (incl. references)
Skills in repo
121
Repo updated
First seen
Licence
Apache-2.0

At a glance

SQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。

  • Databases work in your project
  • SKILL.md covers 能力清单, 触发场景, 核心配置 and 表结构设计, plus 4 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Sqlite Guide Skill is an agent skill from jiushiwon/wg-skills. SQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。

Its SKILL.md is about 910 tokens, which your agent loads only when the skill is triggered. The skill folder holds 5 other files, including reference files (for example `README.md`, `references/connection-pool.md` and `references/performance-tuning.md`).

It sits in Databases. It works with SQLite. The licence is Apache-2.0.

When your agent uses it

  • Databases work in your project

Example prompts

  • “SQLite 学习”
  • “SQLite 入门”
  • “SQLite 选型”
  • “/sqlite-guide-skill”

Requirements

  • Python 3

What it can do on your machine

Read from SKILL.md and the folder at commit a4a640b. 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 python, go, java 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

Sqlite Guide Skill loads about 908 tokens when it runs, and up to ~7.5k if it reads all its reference files. Until then it costs about 43 tokens; SKILL.md has 55 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
~908
With references · SKILL.md plus every file in references/, read only if the agent opens them
~7.5k

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

The full file from jiushiwon/wg-skills at commit a4a640b, republished under its Apache-2.0 licence (© jiushiwon). 55 words, ~908 tokens.

Download SKILL.mdSave it as .claude/skills/sqlite-guide-skill/SKILL.md (or your agent's skills folder). This skill also uses 4 other files; get the full folder from GitHub.
name
sqlite-guide-skill
description
SQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。

SQLite Module Skill

面向已有后端项目的开发者,快速集成 SQLite 能力。

能力清单

能力说明
连接配置SQLite 连接/文件路径配置
CRUD 操作增删改查/批量操作
事务处理事务提交/回滚
并发访问WAL 模式/锁机制
ORM 映射实体类/Repository

触发场景

用户说"帮我加 SQLite"或"集成 SQLite"时触发。

核心配置

Python (FastAPI)
python
# config.py
class Settings(BaseSettings):
    db_path: str = "./data/myapp.db"

# database.py
import sqlite3
from contextlib import contextmanager

class SQLiteClient:
    def __init__(self, db_path: str):
        self.db_path = db_path
        # 启用 WAL 模式提升并发
        self._init_db()
    
    def _init_db(self):
        with self.get_conn() as conn:
            conn.execute("PRAGMA journal_mode=WAL")
            conn.execute("PRAGMA synchronous=NORMAL")
    
    @contextmanager
    def get_conn(self):
        conn = sqlite3.connect(self.db_path)
        conn.row_factory = sqlite3.Row
        try:
            yield conn
            conn.commit()
        finally:
            conn.close()
    
    def execute(self, sql: str, params: tuple = ()):
        with self.get_conn() as conn:
            cursor = conn.execute(sql, params)
            return cursor.lastrowid
    
    def query(self, sql: str, params: tuple = ()):
        with self.get_conn() as conn:
            cursor = conn.execute(sql, params)
            return [dict(row) for row in cursor.fetchall()]
Go
go
import (
    "database/sql"
    _ "github.com/mattn/go-sqlite3"
)

func InitDB(dbPath string) (*sql.DB, error) {
    db, err := sql.Open("sqlite3", dbPath)
    if err != nil {
        return nil, err
    }
    
    // 启用 WAL 模式
    db.Exec("PRAGMA journal_mode=WAL")
    db.Exec("PRAGMA synchronous=NORMAL")
    
    return db, nil
}
Java
java
// application.yml
spring:
  datasource:
    url: jdbc:sqlite:./data/myapp.db
    driver-class-name: org.sqlite.JDBC

表结构设计

基础表模板
sql
CREATE TABLE IF NOT EXISTS "wg_user" (
    "id" INTEGER PRIMARY KEY AUTOINCREMENT,
    "username" TEXT NOT NULL UNIQUE,
    "password" TEXT NOT NULL,
    "nickname" TEXT,
    "email" TEXT,
    "status" INTEGER NOT NULL DEFAULT 1,
    "created_at" TEXT NOT NULL DEFAULT (datetime('now')),
    "updated_at" TEXT NOT NULL DEFAULT (datetime('now')),
    "deleted_at" TEXT
);

CREATE INDEX IF NOT EXISTS "idx_username" ON "wg_user"("username");
CREATE INDEX IF NOT EXISTS "idx_status" ON "wg_user"("status");

事务处理

python
def transfer_money(from_id: int, to_id: int, amount: float):
    with sqlite_client.get_conn() as conn:
        try:
            # 扣款
            conn.execute(
                "UPDATE wg_account SET balance = balance - ? WHERE id = ?",
                (amount, from_id)
            )
            # 加款
            conn.execute(
                "UPDATE wg_account SET balance = balance + ? WHERE id = ?",
                (amount, to_id)
            )
            conn.commit()
        except Exception:
            conn.rollback()
            raise

并发优化

python
# WAL 模式:读写可以并发
conn.execute("PRAGMA journal_mode=WAL")

# 同步模式:平衡安全与性能
conn.execute("PRAGMA synchronous=NORMAL")  # 推荐

# 缓存大小(MB)
conn.execute("PRAGMA cache_size=10000")

# 临时文件内存
conn.execute("PRAGMA temp_store=MEMORY")

使用场景

场景适用性
单机工具✅ 完美
小型应用✅ 推荐
嵌入式设备✅ 完美
高并发 Web❌ 不推荐
分布式系统❌ 不推荐

不做

  • 不负责高并发场景优化
  • 不处理大规模数据(建议迁移到 MySQL/PG)
  • 不提供主从复制

© jiushiwon, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 4 other files (references) in vibeCoding/backend/database/sqlite-guide-skill of jiushiwon/wg-skills.

  • SKILL.md
  • README.md
  • references/connection-pool.md
  • references/performance-tuning.md
  • references/troubleshooting.md

Open the folder on GitHubat commit a4a640b

Compare with similar skills

Sqlite Guide Skill 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.

Sqlite Guide Skill compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Sqlite Guide Skill this skilljiushiwon/wg-skills110—~908Automated safety check: PassApache-2.0
Iptvnator Sqlite DB Worker4gray/iptvnator7.3k—~824Automated safety check: PassMIT
Analyze Nsys Profilemlc-ai/pith-train355—~1.9kAutomated safety check: PassApache-2.0
Reactive Sqlite UIfastrepl/anarlog9.4k—~699Automated safety check: PassMIT
Composer Forensicsdxos/dxos525—~3.1kAutomated safety check: PassCustom licence
Sqlite Schema Designfastrepl/anarlog9.4k—~1.9kAutomated safety check: PassMIT

Similar skills

  • A skill your agent uses when changing Electron SQLite IPC, database-worker operations, request-scoped progress or cancellation, worker packaging, or runtime verification of non-EPG database work.

    7.3k GitHub stars~824 tokensUpdated yesterday
    DatabasesAuto-check passed
  • Analyze Nsys Profile

    mlc-ai/pith-train

    Query a captured PithTrain Nsight Systems profile to measure compute/communication overlap, locate exposed comm by DualPipeV stage, and inspect per-rank stream behavior.

    355 GitHub stars~1.9k tokensUpdated 3 days ago
    DatabasesAuto-check passed
  • Reactive Sqlite UI

    fastrepl/anarlog

    Build SQLite-backed reactive UI in apps/desktop using stable patterns for reads, selection, forms, writes, and loading states.

    9.4k GitHub stars~699 tokensUpdated today
    DatabasesAuto-check passed
  • Forensically inspect and repair Composer browser profiles — offline (Chrome OPFS / SQLite extract) or live via /recovery.html debug port.

    525 GitHub stars~3.1k tokensUpdated today
    DatabasesAuto-check passed
  • Sqlite Schema Design

    fastrepl/anarlog

    Design or review schemas for crates/cloudsync using SQLite Sync constraints, not generic SQLite advice.

    9.4k GitHub stars~1.9k tokensUpdated today
    DatabasesAuto-check passed
  • Makemigrations

    deusXmachina-dev/memorylane

    Create SQLite migrations for MemoryLane storage schema changes.

    121 GitHub stars~973 tokensUpdated yesterday
    DatabasesAuto-check passed

More from jiushiwon/wg-skills

All 121 skills in this repo
  • Frontend UI Foundry

    jiushiwon/wg-skills

    A skill your agent uses when generating UI for a specific scenario (mobile/PC/官网/管理端/营销页/文档/金融/原生/3D), when refactoring an existing HTML/Vue/React project to a unified design system, when extracting…

    110 GitHub stars~1.4k tokensUpdated 3 days ago
    Auto-check passed
  • Workflow Diagram Skill

    jiushiwon/wg-skills

    A skill your agent uses when 用户想用一句话生成流程图、工作流图解、开发流程图、AI 流程图或任何步骤型图解,支持多风格输出(flat icon / 暖白手账风 / dark / cute),并提供现成模板一键出图。

    110 GitHub stars~1.2k tokensUpdated 3 days ago
    Auto-check passed
  • Uniapp App Generate Skill

    jiushiwon/wg-skills

    This skill should be used when the user wants to create a standardized uni-app project for WeChat mini-program, H5, and App from scratch.

    110 GitHub stars~5k tokensUpdated 3 days ago
    Auto-check: notes
  • Fastapi Init Skill

    jiushiwon/wg-skills

    FastAPI 项目一键初始化技能。面向零基础小白,提供环境探测、自动安装、完整 Web 骨架生成、SSE 流式框架、JWT 鉴权、统一响应封装、文件上传接口、一键启动/重启脚本、Swagger 文档,内置 MySQL(默认)/ PostgreSQL / MongoDB 数据库选择。用户只需说"帮我搭一个 FastAPI 项目"即可一条命令完成从零到跑的完整链路。触发词:"FastAPI…

    110 GitHub stars~1.8k tokensUpdated 3 days ago
    Auto-check: notes
  • Ffmpeg Skill

    jiushiwon/wg-skills

    FFmpeg 多媒体处理技能 — 将自然语言描述转为正确的 ffmpeg 命令,覆盖视频剪辑、转码、水印、合成、提取、生成等操作。内置一键安装脚本(Windows/Mac/Linux)。触发词:ffmpeg、视频剪辑、视频裁剪、视频转码、视频压缩、去水印、加水印、视频拼接、视频合成、提取音频、视频转…

    110 GitHub stars~1.4k tokensUpdated 3 days ago
    Auto-check passed
  • Frontend Request Skill

    jiushiwon/wg-skills

    A skill your agent uses when designing or reviewing the request layer of a frontend project (web / uni-app / mini-program), including request.ts wrappers, interceptors, deduplication, mocks, error…

    110 GitHub stars~3.6k tokensUpdated 3 days ago
    Auto-check passed

Works with

Categories

Questions about Sqlite Guide Skill

What does Sqlite Guide Skill do?

SQLite 学习与选型指南。面向需要了解 SQLite 的开发者,提供核心概念、安装配置、CRUD、事务处理、并发访问、与业务场景匹配推荐等(不含具体框架集成)。触发词:"SQLite 学习"、"SQLite 入门"、"SQLite 选型"、"轻量数据库"、"嵌入式数据库"、"sqlite 概念"。. Sqlite Guide Skill is an agent skill from jiushiwon/wg-skills.

When should I use Sqlite Guide Skill?

Sqlite Guide Skill fits situations like: databases work in your project.

How do I install Sqlite Guide Skill in Claude Code?

Run `npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a claude-code`. Or copy the skill folder (vibeCoding/backend/database/sqlite-guide-skill in jiushiwon/wg-skills) into .claude/skills/sqlite-guide-skill in your project. Claude Code loads it when a task matches its description.

How do I install Sqlite Guide Skill in Codex?

Run `npx skills add jiushiwon/wg-skills --skill sqlite-guide-skill -a codex`. Or copy the skill folder (vibeCoding/backend/database/sqlite-guide-skill in jiushiwon/wg-skills) into .agents/skills/sqlite-guide-skill in your project. Codex loads it when a task matches its description.

Can I use Sqlite Guide Skill 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 jiushiwon/wg-skills --skill sqlite-guide-skill -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sqlite-guide-skill, .gemini/skills/sqlite-guide-skill, .github/skills/sqlite-guide-skill and .opencode/skills/sqlite-guide-skill in your project.

What does Sqlite Guide Skill need to run?

SKILL.md names no scripts, command-line tools or credentials: Sqlite Guide Skill is instructions for the agent only. Our summary lists: Python 3.

Does Sqlite Guide Skill 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 Sqlite Guide Skill 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 Sqlite Guide Skill use?

Sqlite Guide Skill is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Sqlite Guide Skill use?

About 908 tokens (SKILL.md is roughly 3.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 6.6k tokens, read only when the agent opens those files.

What are the alternatives to Sqlite Guide Skill?

Skills that share tags, products or a category with Sqlite Guide Skill: Iptvnator Sqlite DB Worker (4gray/iptvnator, 7.3k stars), Analyze Nsys Profile (mlc-ai/pith-train, 355 stars), Reactive Sqlite UI (fastrepl/anarlog, 9.4k stars) and Composer Forensics (dxos/dxos, 525 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Sqlite Guide Skill?

jiushiwon (a GitHub user) maintains it in jiushiwon/wg-skills, which has 110 GitHub stars. The repository holds 121 skills in this directory. The repository was last updated on October 4, 2026.

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