According to AlphaMoat, as of 2026-10, SQLite has 10,101 downloads and 7 stars — ranked by downloads #2,699 among 10,914 AI skills in this ranking, and #208 of 1,069 in Development.
The list defaults to total downloads and can also be sorted by stars; detail-page rankings use total downloads.
| Platform | Downloads | Stars | Comments |
|---|---|---|---|
| ClawHub ↗ | 7.7K | 6 | - |
| SkillHub ↗ | 10.1K | 7 | — |
Platforms count differently and update at different times.
It covers concurrency, pragmas, and type handling: only one writer is allowed at a time, so concurrent writes queue or fail and SQLite is not for high-write workloads; enabling WAL mode lets reads run during writes, and a busy timeout waits before returning a busy error. Foreign key enforcement must be turned on per connection.
Profile published 2026-10-27
Generated from the skill’s documentation as examples; not results of actual runs.
The counting method changed in 2026-09: skills with the same name are now counted separately by author, and the full catalog is covered. Dashed lines show months before the change; they are not compared with later months, and no growth is computed across the change.
| Month | Downloads | MoM | Stars |
|---|---|---|---|
| 2026-10 | 10.1K | — | 7 |
| 2026-09 | 7.4K | — | 7 |
| 2026-08 | 7.1K | +6.7% | 7 |
| 2026-07 | 6.6K | +7.3% | 7 |
| 2026-06 | 6.2K | +4.6% | 6 |
| 2026-05 | 5.9K | — | 6 |
| 2026-03 | 4.8K | — | 6 |
The author’s original file, shown as plain text without edits or review by AlphaMoat. Links are not clickable; check commands before running them. Fetched 2026-10-23.
---
name: SQLite
description: Use SQLite correctly with proper concurrency, pragmas, and type handling.
metadata: {"clawdbot":{"emoji":"🪶","requires":{"bins":["sqlite3"]},"os":["linux","darwin","win32"]}}
---
## Concurrency (Biggest Gotcha)
- Only one writer at a time—concurrent writes queue or fail; not for high-write workloads
- Enable WAL mode: `PRAGMA journal_mode=WAL`—allows reads during writes, huge improvement- Set busy timeout: `PRAGMA busy_timeout=5000`—waits 5s before SQLITE_BUSY instead of failing immediately - WAL needs `-wal` and `-shm` files—don't forget to copy them with main database - `BEGIN IMMEDIATE` to grab write lock early—prevents deadlocks in read-then-write patterns ## Foreign Keys (Off by Default!) - `PRAGMA foreign_keys=ON` required per connection—not persisted in database - Without it, foreign key constraints silently ignored—data integrity broken - Check before relying: `PRAGMA foreign_keys` returns 0 or 1 - ON DELETE CASCADE only works if foreign_keys is ON ## Type System - Type affinity, not strict types—INTEGER column accepts "hello" without error - `STRICT` tables enforce types—but only SQLite 3.37+ (2021) - No native DATE/TIME—use TEXT as ISO8601 or INTEGER as Unix timestamp - BOOLEAN doesn't exist—use INTEGER 0/1; TRUE/FALSE are just aliases - REAL is 8-byte float—same precision issues as any float ## Schema Changes - `ALTER TABLE` very limited—can add column, rename table/column; that's mostly it - Can't change column type, add constraints, or drop columns (until 3.35) - Workaround: create new table, copy data, drop old, rename—wrap in transaction - `ALTER TABLE ADD COLUMN` can't have PRIMARY KEY, UNIQUE, or NOT NULL without default ## Performance Pragmas - `PRAGMA optimize` before closing long-running connections—updates query planner stats - `PRAGMA cache_size=-64000` for 64MB cache—negative = KB; default very small - `PRAGMA synchronous=NORMAL` with WAL—good balance of safety and speed - `PRAGMA temp_store=MEMORY` for temp tables in RAM—faster sorts and temp results ## Vacuum & Maintenance - Deleted data doesn't shrink file—`VACUUM` rewrites entire database, reclaims space - `VACUUM` needs 2x disk space temporarily—ensure enough room - `PRAGMA auto_vacuum=INCREMENTAL` with `PRAGMA incremental_vacuum`—partial reclaim without full rewrite - After bulk deletes, always vacuum or file stays bloated ## Backup Safety - Never copy database file while open—corrupts if write in progress - Use `.backup` command in sqlite3—or `sqlite3_backup_*` API - WAL mode: `-wal` and `-shm` must be copied atomically with main file - `VACUUM INTO 'backup.db'` creates standalone copy (3.27+) ## Indexing - Covering indexes work—add extra columns to avoid table lookup - Partial indexes supported (3.8+): `CREATE INDEX ... WHERE condition` - Expression indexes (3.9+): `CREATE INDEX ON t(lower(name))` - `EXPLAIN QUERY PLAN` shows index usage—simpler than PostgreSQL EXPLAIN ## Transactions - Autocommit by default—each statement is own transaction; slow for bulk inserts - Batch inserts: `BEGIN; INSERT...; INSERT...; COMMIT`—10-100x faster - `BEGIN EXCLUSIVE` for exclusive lock—blocks all other connections - Nested transactions via `SAVEPOINT name` / `RELEASE name` / `ROLLBACK TO name` ## Common Mistakes - Using SQLite for web app with concurrent users—one writer blocks all; use PostgreSQL - Assuming ROWID is stable—`VACUUM` can change ROWIDs; use explicit INTEGER PRIMARY KEY - Not setting busy_timeout—random SQLITE_BUSY errors under any concurrency - In-memory database `':memory:'`—each connection gets different database; use `file::memory:?cache=shared` for shared
【全栈能力】编程大神.Skill:面向复杂真实项目的高阶全栈编程助手。不止生成代码,而是从一句目标接手陌生代码库,拆解需求、补齐实现、追到根因、完成重构、联调前后端,并把结果推进到能运行、能验证、能交付。覆盖 Web、后端、脚本、iOS、安卓、鸿蒙 ArkUI、微信小程序及其他技术栈,支持中英文工程、疑难 Bug、跨模块任务和长任务续做;用构建、日志、真实入口、设备或接口证据说明结果。仅问概念时直接回答,要求落地时持续推进到验收或明确阻塞。
编程专家 Pro:融合编程专家 2.0.3 工程专题与编程大神的鸿蒙 ArkTS/ArkUI、微信小程序和小游戏开发资料。用于项目实现、根因调试、审查、重构、测试、架构性能分析及多端开发验证。支持自然语言和 @专题标识,按任务读取包内知识;只问概念时直接回答。
编程专家.Skill P8级编程助手,25年实战经验技能Skill,全栈:Java/Php网站/软件项目、API设计、Bug诊断、代码生成、代码审查、重构、测试用例、性能基准、技术选型、文档生成、任务拆解、Spec驱动、Karpathy规范、CMS二次开发、前端设计、MySQL/Mariadb、项目知识图谱,以及工程纪律层(根因调试硬闭环、阶段导航、事故复盘/SLO、威胁建模/供应链安全、生产就绪/渐进式发布、AI编码治理、面向Agent代码可读性、LLM应用安全)。支持 @标识 显式调用跳过路由。
编程专家.Skill P8级编程助手,25年实战经验技能Skill,全栈:Java/Php网站/软件项目、API设计、Bug诊断、代码生成、代码审查、重构、测试用例、性能基准、技术选型、文档生成、任务拆解、Spec驱动、Karpathy规范、CMS二次开发、前端设计、MySQL/Mariadb、项目知识图谱,以及工程纪律层(根因调试硬闭环、阶段导航、事故复盘/SLO、威胁建模/供应链安全、生产就绪/渐进式发布、AI编码治理、面向Agent代码可读性、LLM应用安全)。支持 @标识 显式调用跳过路由。
工程专题、鸿蒙与微信小程序开发的集成派生版
编程专家 Pro:融合编程专家 2.0.3 工程专题与编程大神的鸿蒙 ArkTS/ArkUI、微信小程序和小游戏开发资料。用于项目实现、根因调试、审查、重构、测试、架构性能分析及多端开发验证。支持自然语言和 @专题标识,按任务读取包内知识;只问概念时直接回答。
适用场景:全栈编程助手。接到需求先读现有代码和约束,再动手:Java/PHP 开发、接口设计、缺陷定位、代码评审、重构、测试用例、性能排查、技术选型与文档产出,也做 CMS 二次开发、前端页面和 MySQL 调优。每次改动先给方案和影响范围,改完必须跑验证,交付附交接说明。适合要把代码真正跑通、而不是只要片段的场景。写完代码常要配套的造价、法律、工程文档,站内已有现成技能,用「查找技能」按需求找即可。
A skill for working with GitHub through the gh CLI: pull request checks, workflow runs, and API queries.
Turns corrections and self-review into tiered memory and promotes or archives it by use.
Creates, inspects, and edits Excel files while keeping formulas, formatting, and workbook structure intact.
A working guide for Word and DOCX documents that keeps styles, numbering, and layout intact after edits.
An AI video generation and orchestration skill across several model APIs.
A data-analysis skill that turns databases, spreadsheets, and raw exports into decision-ready conclusions.
Data as of 2026-10. Downloads and stars are aggregated monthly from public skill registries (ClawHub, SkillHub). See data methodology.