Skills sqlite-ops

📦

sqlite-ops

Name: sqlite-ops
Author: 0xDarkMatter

Content revision r1 High Risk 🌐 Network access⚙️ External commands

Build Reliable SQLite Workflows

SQLite is simple, but production use needs safe connection, schema, migration, and async patterns. This skill gives Claude, Codex, and Claude Code practical templates for local persistence.

Supports: Claude Codex Code(CC)

⚠️ 38 Poor

Stop for confirmation before installing.

Review the plan and obtain explicit user consent before changing files.

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request

Review the Skillstore skill "sqlite-ops" from https://skillstore.io/skills/0xdarkmatter-sqlite-ops.md and its manifest at https://skillstore.io/api/skills/0xdarkmatter-sqlite-ops/manifest. Verify the artifact. Stop and obtain explicit user consent before installing or changing files.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/0xdarkmatter-sqlite-ops.md Signed manifest GET /api/skills/0xdarkmatter-sqlite-ops/manifest Signed lockfile GET /api/skills/0xdarkmatter-sqlite-ops/lockfile

Test it

Using "sqlite-ops". I need a cache table for API responses.

Expected outcome:

A table design with cache keys, stored values, creation time, expiry time, and cleanup guidance.

Using "sqlite-ops". I need to migrate an existing local database.

Expected outcome:

A migration sequence with version tracking, backup steps, rollback notes, and verification checks.

Using "sqlite-ops". My async worker reads too many rows at once.

Expected outcome:

A streaming approach with batch sizing, row conversion guidance, and connection cleanup notes.

Security Audit

High Risk

v7 • 7/4/2026 Open versioned report

Most static detections are false positives from markdown code fences, SQLite filenames, schema IDs, and placeholder IP data. I confirmed dynamic SQL examples that interpolate unvalidated field names, which can become SQL injection when copied with user-controlled input. No prompt injection attempts or exfiltration intent were found.

Files scanned

941

Lines analyzed

Review items

False positives ignored

Confirmed security concerns (4)

High

references/async-patterns.md:71

Certificate/key files

set_clause = ", ".join(f"{k} = ?" for k in updates.keys())

The pattern label is wrong, but the code builds a SET clause from arbitrary update keys. If callers pass untrusted keys, they can alter SQL identifiers because no whitelist is shown.

High

references/async-patterns.md:76

System reconnaissance

f"UPDATE items SET {set_clause} WHERE id = ?",

The UPDATE statement interpolates set_clause into SQL while only parameterizing values. This creates a SQL injection risk when update field names are not strictly controlled.

High

references/migration-patterns.md:304

System reconnaissance

f"UPDATE events SET payload = json_set(payload, '$.{field}', ?) WHERE id = ?",

The JSON update helper interpolates a field name into a SQL JSON path. User-controlled field values could change the SQL expression because no validation or whitelist is shown.

High

references/migration-patterns.md:296

Unvalidated JSON Path Interpolation

The query_json_field example interpolates field into a SQL string for json_extract without validation. If field comes from user input, it can change the SQL expression.

The f-string directly embeds the field parameter in SQL, and no whitelist or escaping is shown. It is an example, so exploitation depends on unsafe reuse.

Risk Factors

🌐 Network access (1)

references/schema-patterns.md:74

⚙️ External commands (12)

SKILL.md:17-26 SKILL.md:26-30 SKILL.md:30-41 SKILL.md:41-47 SKILL.md:47-49 SKILL.md:49-62 SKILL.md:62-63 SKILL.md:63-67 SKILL.md:67-73 SKILL.md:73-86 SKILL.md:86-87 SKILL.md:87-88

Detected Patterns

System reconnaissance×2

Audited by: codex View Audit History →

Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report

Copy report link

https://skillstore.io/skills/0xdarkmatter-sqlite-ops/audits/7?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/0xdarkmatter-sqlite-ops/security.svg)](https://skillstore.io/skills/0xdarkmatter-sqlite-ops?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/0xdarkmatter-sqlite-ops?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/0xdarkmatter-sqlite-ops/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/0xdarkmatter-sqlite-ops.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>

Academic citations (APA · BibTeX · CFF)

APA citation

0xDarkMatter. (2026). sqlite-ops security audit report (audit version 7) [Author version unspecified]. Skillstore. https://skillstore.io/skills/0xdarkmatter-sqlite-ops/audits/7

BibTeX citation

@techreport{0xdarkmatter-0xdarkmatter-sqlite-ops-2026,
  author = {0xDarkMatter},
  title = {sqlite-ops security audit report (audit version 7)},
  institution = {Skillstore},
  year = {2026},
  number = {7},
  url = {https://skillstore.io/skills/0xdarkmatter-sqlite-ops/audits/7},
  note = {Author version unspecified}
}

CITATION.cff

cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "sqlite-ops security audit report (audit version 7)"
version: "unspecified"
type: report
authors:
  - name: "0xDarkMatter"
date-released: "2026-07-04"
url: "https://skillstore.io/skills/0xdarkmatter-sqlite-ops/audits/7"
identifiers:
  - type: other
    value: "skillstore:0xdarkmatter-sqlite-ops:audit:7"
    description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: Medium

Architecture

Maintainability

Content

Community

Spec Compliance

What You Can Build

Add Local Persistence

Design a small SQLite database for app state, settings, cache data, or event logs.

Maintain Embedded Databases

Plan migrations, backups, schema checks, and safe rollback steps for local database files.

Build Async Data Access

Create aiosqlite access patterns for web apps, workers, and MCP server persistence.

Try These Prompts

Create a Basic Schema

Use sqlite-ops to design a simple SQLite schema for app settings and recent activity. Include table purposes and indexes.

Add Safe Transactions

Use sqlite-ops to refactor my Python sqlite3 writes into transaction-safe helpers with rollback behavior and foreign keys enabled.

Plan Migrations

Use sqlite-ops to create a migration plan for adding users and orders tables to an existing SQLite database.

Review Async Access

Use sqlite-ops to review my aiosqlite access layer for connection lifetime, batching, streaming, and query safety.

Best Practices

Enable WAL mode and foreign keys when the application needs concurrency and relational checks.
Use parameterized values and whitelist any dynamic table, column, or JSON field names.
Back up the database before migrations, dumps, restores, or table recreation steps.