Sqlite Ops

What it does

When your agent uses it

• Database schema
• Tasks that involve State management
• Tasks that involve Database schema design

Example prompts

• “Use the sqlite-ops skill to pattern for SQLite databases in Python projects - state management, caching, and async operations”
• “/sqlite-ops”

Requirements

• Python 3
• Compatibility (from SKILL.md): Requires Python 3.8+ with sqlite3 (standard library) or aiosqlite for async.
• Pre-approved tools (allowed-tools): Read, Write, Bash

What it can do on your machine

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

• Tool permissions

  Pre-approves these tools, so the agent can use them without asking each time:

  • Read
  • Write
  • Bash

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Ships 1 file in scripts/, which the agent can run.

  Shell commands in SKILL.md call:

  • sqlite3

  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.

• Compatibility

  Requires Python 3.8+ with sqlite3 (standard library) or aiosqlite for async.

  From compatibility in the SKILL.md frontmatter.

Context cost

Sqlite Ops loads about 578 tokens when it runs, and up to ~6.4k if it reads all its reference files. Until then it costs about 51 tokens; SKILL.md has 112 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~51

When it runs · the whole SKILL.md, loaded when a task matches

~578

With references · SKILL.md plus every file in references/, read only if the agent opens them

~6.4k

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

• NotePre-approves every shell command (allowed-tools: Bash)SKILL.md

  allowed-tools: Read, Write, Bash

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); the scripts in this folder are not scanned.

SKILL.md

The full file from aiskillstore/marketplace at commit 4ac52da, republished under its MIT licence (© aiskillstore). 112 words, ~578 tokens.

name

sqlite-ops

description

Patterns for SQLite databases in Python projects - state management, caching, and async operations. Triggers on: sqlite, sqlite3, aiosqlite, local database, database schema, migration, wal mode.

allowed-tools

Read, Write, Bash

compatibility

Requires Python 3.8+ with sqlite3 (standard library) or aiosqlite for async.

license

MIT

metadata.author

claude-mods

import sqlite3

def get_connection(db_path: str) -> sqlite3.Connection:
    conn = sqlite3.connect(db_path, check_same_thread=False)
    conn.row_factory = sqlite3.Row  # Dict-like access
    conn.execute("PRAGMA journal_mode=WAL")  # Better concurrency
    conn.execute("PRAGMA foreign_keys=ON")
    return conn

from contextlib import contextmanager

@contextmanager
def db_transaction(conn: sqlite3.Connection):
    try:
        yield conn
        conn.commit()
    except Exception:
        conn.rollback()
        raise

conn.execute("PRAGMA journal_mode=WAL")

sqlite3 mydb.sqlite    # Open database
.tables                # Show tables
.schema items          # Show schema
.headers on && .mode csv && .output data.csv  # Export CSV
VACUUM;                # Reclaim space

© aiskillstore, MIT. 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 6 other files (scripts, references, assets) in skills/0xdarkmatter/sqlite-ops of aiskillstore/marketplace.

• SKILL.md
• assets/.gitkeep
• references/async-patterns.md
• references/migration-patterns.md
• references/schema-patterns.md
• scripts/.gitkeep
• skill-report.json

Open the folder on GitHubat commit 4ac52da

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in aiskillstore/marketplace, which our catalogue first saw on October 7, 2026.

• NeverSight/learn-skills.devdata/skills-md/0xdarkmatter/claude-mods/sqlite-ops