Skip to content

aiskillstore/marketplace / skills/0xdarkmatter/sqlite-ops

sqlite-ops

Verified

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.

FileKindSize
SKILL.mdskill md2.3 KB
assets/.gitkeepother0 B
references/async-patterns.mdmarkdown8.4 KB
references/migration-patterns.mdmarkdown8.8 KB
references/schema-patterns.mdmarkdown5.5 KB
scripts/.gitkeepother0 B
skill-report.jsonconfig54.0 KB

skill-report.json

View on GitHub
{
  "schema_version": "2.0",
  "meta": {
    "generated_at": "2026-07-04T13:14:49.900Z",
    "slug": "0xdarkmatter-sqlite-ops",
    "source_url": "https://github.com/0xDarkMatter/claude-mods/tree/main/skills/sqlite-ops",
    "source_ref": "main",
    "model": "codex",
    "analysis_version": "3.0.0",
    "source_type": "community",
    "content_hash": "df940d65caace5c7092208210c35e0da978151e581f3230048a04fef10180615",
    "tree_hash": "a333ec2b56c8bfe456a1b4633ac28520781a69b997a8291db91639200907a9f5",
    "provenance": {
      "model_effective": "codex",
      "fallback_chain": [
        {
          "agent": "codex",
          "outcome": "success"
        }
      ],
      "analysis_version": "3.0.0"
    }
  },
  "skill": {
    "name": "sqlite-ops",
    "description": "SQLite patterns for Python projects, including local state, cache tables, migrations, WAL mode, sqlite3, and aiosqlite workflows.",
    "summary": "Use practical SQLite patterns for Python persistence, migrations, async operations, and local database maintenance.",
    "icon": "📦",
    "version": "1.0.1",
    "author": "0xDarkMatter",
    "license": "MIT",
    "tags": [
      "sqlite",
      "python",
      "database",
      "migrations",
      "aiosqlite"
    ],
    "supported_tools": [
      "claude",
      "codex",
      "claude-code"
    ],
    "risk_factors": [
      "network",
      "external_commands"
    ],
    "category": "data"
  },
  "security_audit": {
    "risk_level": "high",
    "is_blocked": false,
    "safe_to_publish": false,
    "analysis_status": "ok",
    "summary": "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.",
    "remediation": [
      {
        "issue": "Unvalidated SQL field interpolation",
        "suggestion": "Whitelist allowed column and JSON field names before constructing SQL. Reject unknown names before executing the query.",
        "severity": "high"
      },
      {
        "issue": "Database CLI examples can affect local files",
        "suggestion": "State that CLI commands should run only on user-approved database paths and backups.",
        "severity": "low"
      }
    ],
    "risk_factor_evidence": [
      {
        "factor": "network",
        "evidence": [
          {
            "file": "references/schema-patterns.md",
            "line_start": 74,
            "line_end": 74
          }
        ]
      },
      {
        "factor": "external_commands",
        "evidence": [
          {
            "file": "SKILL.md",
            "line_start": 17,
            "line_end": 26
          },
          {
            "file": "SKILL.md",
            "line_start": 26,
            "line_end": 30
          },
          {
            "file": "SKILL.md",
            "line_start": 30,
            "line_end": 41
          },
          {
            "file": "SKILL.md",
            "line_start": 41,
            "line_end": 47
          },
          {
            "file": "SKILL.md",
            "line_start": 47,
            "line_end": 49
          },
          {
            "file": "SKILL.md",
            "line_start": 49,
            "line_end": 62
          },
          {
            "file": "SKILL.md",
            "line_start": 62,
            "line_end": 63
          },
          {
            "file": "SKILL.md",
            "line_start": 63,
            "line_end": 67
          },
          {
            "file": "SKILL.md",
            "line_start": 67,
            "line_end": 73
          },
          {
            "file": "SKILL.md",
            "line_start": 73,
            "line_end": 86
          },
          {
            "file": "SKILL.md",
            "line_start": 86,
            "line_end": 87
          },
          {
            "file": "SKILL.md",
            "line_start": 87,
            "line_end": 88
          }
        ]
      }
    ],
    "static_findings": [
      {
        "id": "sensitive:references/async-patterns.md:71:certificate-key-files",
        "category": "sensitive",
        "severity": "high",
        "pattern": "Certificate/key files",
        "file": "references/async-patterns.md",
        "line_start": 71,
        "line_end": 71,
        "snippet": "set_clause = \", \".join(f\"{k} = ?\" for k in updates.keys())"
      },
      {
        "id": "sensitive:references/async-patterns.md:158:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/async-patterns.md",
        "line_start": 158,
        "line_end": 158,
        "snippet": "self.db_path = db_path"
      },
      {
        "id": "sensitive:references/async-patterns.md:165:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/async-patterns.md",
        "line_start": 165,
        "line_end": 165,
        "snippet": "conn = await aiosqlite.connect(self.db_path)"
      },
      {
        "id": "sensitive:references/async-patterns.md:198:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/async-patterns.md",
        "line_start": 198,
        "line_end": 198,
        "snippet": "pool = AsyncDBPool(\"mydb.sqlite\")"
      },
      {
        "id": "blocker:references/async-patterns.md:46:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 46,
        "line_end": 47,
        "snippet": "return cursor.lastrowid"
      },
      {
        "id": "blocker:references/async-patterns.md:57:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 57,
        "line_end": 57,
        "snippet": "\"SELECT * FROM items WHERE id = ?\", (item_id,)"
      },
      {
        "id": "blocker:references/async-patterns.md:76:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 76,
        "line_end": 76,
        "snippet": "f\"UPDATE items SET {set_clause} WHERE id = ?\","
      },
      {
        "id": "blocker:references/async-patterns.md:90:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 90,
        "line_end": 90,
        "snippet": "\"DELETE FROM items WHERE id = ?\", (item_id,)"
      },
      {
        "id": "blocker:references/async-patterns.md:119:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 119,
        "line_end": 119,
        "snippet": "\"UPDATE items SET status = ? WHERE id = ?\","
      },
      {
        "id": "blocker:references/async-patterns.md:120:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 120,
        "line_end": 120,
        "snippet": "[(status, id) for id in ids]"
      },
      {
        "id": "blocker:references/async-patterns.md:135:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 135,
        "line_end": 135,
        "snippet": "\"UPDATE accounts SET balance = balance - ? WHERE id = ?\","
      },
      {
        "id": "blocker:references/async-patterns.md:139:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 139,
        "line_end": 139,
        "snippet": "\"UPDATE accounts SET balance = balance + ? WHERE id = ?\","
      },
      {
        "id": "blocker:references/async-patterns.md:203:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 203,
        "line_end": 203,
        "snippet": "\"SELECT * FROM users WHERE id = ?\", (user_id,)"
      },
      {
        "id": "blocker:references/async-patterns.md:212:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 212,
        "line_end": 212,
        "snippet": "\"\"\"Yield items in batches to avoid memory issues.\"\"\""
      },
      {
        "id": "blocker:references/async-patterns.md:233:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 233,
        "line_end": 233,
        "snippet": "user_task = db.execute(\"SELECT * FROM users WHERE id = ?\", (user_id,))"
      },
      {
        "id": "blocker:references/async-patterns.md:235:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 235,
        "line_end": 235,
        "snippet": "\"SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC LIMIT 10\","
      },
      {
        "id": "blocker:references/async-patterns.md:239:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/async-patterns.md",
        "line_start": 239,
        "line_end": 239,
        "snippet": "\"SELECT COUNT(*) as count, SUM(total) as total FROM orders WHERE user_id = ?\","
      },
      {
        "id": "sensitive:references/migration-patterns.md:314:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/migration-patterns.md",
        "line_start": 314,
        "line_end": 314,
        "snippet": "sqlite3 mydb.sqlite < migrations/001_initial.sql"
      },
      {
        "id": "sensitive:references/migration-patterns.md:317:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/migration-patterns.md",
        "line_start": 317,
        "line_end": 317,
        "snippet": "sqlite3 mydb.sqlite \"SELECT * FROM schema_version\""
      },
      {
        "id": "sensitive:references/migration-patterns.md:320:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/migration-patterns.md",
        "line_start": 320,
        "line_end": 320,
        "snippet": "sqlite3 mydb.sqlite \".schema\" > schema.sql"
      },
      {
        "id": "sensitive:references/migration-patterns.md:323:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/migration-patterns.md",
        "line_start": 323,
        "line_end": 323,
        "snippet": "sqlite3 mydb.sqlite \".dump\" > backup.sql"
      },
      {
        "id": "sensitive:references/migration-patterns.md:326:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/migration-patterns.md",
        "line_start": 326,
        "line_end": 326,
        "snippet": "sqlite3 newdb.sqlite < backup.sql"
      },
      {
        "id": "sensitive:references/migration-patterns.md:329:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "references/migration-patterns.md",
        "line_start": 329,
        "line_end": 329,
        "snippet": "diff <(sqlite3 db1.sqlite \".schema\") <(sqlite3 db2.sqlite \".schema\")"
      },
      {
        "id": "blocker:references/migration-patterns.md:14:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 14,
        "line_end": 14,
        "snippet": "id INTEGER PRIMARY KEY,"
      },
      {
        "id": "blocker:references/migration-patterns.md:26:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 26,
        "line_end": 26,
        "snippet": "ALTER TABLE items ADD COLUMN user_id INTEGER;"
      },
      {
        "id": "blocker:references/migration-patterns.md:78:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 78,
        "line_end": 78,
        "snippet": "id INTEGER PRIMARY KEY,"
      },
      {
        "id": "blocker:references/migration-patterns.md:94:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 94,
        "line_end": 94,
        "snippet": "id INTEGER PRIMARY KEY,"
      },
      {
        "id": "blocker:references/migration-patterns.md:95:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 95,
        "line_end": 95,
        "snippet": "user_id INTEGER NOT NULL REFERENCES users(id),"
      },
      {
        "id": "blocker:references/migration-patterns.md:113:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 113,
        "line_end": 113,
        "snippet": "id INTEGER PRIMARY KEY,"
      },
      {
        "id": "blocker:references/migration-patterns.md:139:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 139,
        "line_end": 139,
        "snippet": "\"SELECT name FROM migrations ORDER BY id DESC LIMIT ?\","
      },
      {
        "id": "blocker:references/migration-patterns.md:216:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 216,
        "line_end": 216,
        "snippet": "id INTEGER PRIMARY KEY,"
      },
      {
        "id": "blocker:references/migration-patterns.md:266:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 266,
        "line_end": 266,
        "snippet": "id INTEGER PRIMARY KEY,"
      },
      {
        "id": "blocker:references/migration-patterns.md:304:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/migration-patterns.md",
        "line_start": 304,
        "line_end": 304,
        "snippet": "f\"UPDATE events SET payload = json_set(payload, '$.{field}', ?) WHERE id = ?\","
      },
      {
        "id": "network:references/schema-patterns.md:74:hardcoded-ip-address",
        "category": "network",
        "severity": "medium",
        "pattern": "Hardcoded IP address",
        "file": "references/schema-patterns.md",
        "line_start": 74,
        "line_end": 74,
        "snippet": "VALUES ('user_login', '{\"user_id\": 123, \"ip\": \"10.0.0.1\"}');"
      },
      {
        "id": "blocker:references/schema-patterns.md:63:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 63,
        "line_end": 63,
        "snippet": "id INTEGER PRIMARY KEY AUTOINCREMENT,"
      },
      {
        "id": "blocker:references/schema-patterns.md:90:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 90,
        "line_end": 90,
        "snippet": "Track seen items to avoid reprocessing:"
      },
      {
        "id": "blocker:references/schema-patterns.md:118:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 118,
        "line_end": 118,
        "snippet": "id INTEGER PRIMARY KEY AUTOINCREMENT,"
      },
      {
        "id": "blocker:references/schema-patterns.md:136:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 136,
        "line_end": 136,
        "snippet": "WHERE id = ("
      },
      {
        "id": "blocker:references/schema-patterns.md:137:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 137,
        "line_end": 137,
        "snippet": "SELECT id FROM job_queue"
      },
      {
        "id": "blocker:references/schema-patterns.md:147:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 147,
        "line_end": 147,
        "snippet": "WHERE id = ?;"
      },
      {
        "id": "blocker:references/schema-patterns.md:152:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 152,
        "line_end": 152,
        "snippet": "WHERE id = ?;"
      },
      {
        "id": "blocker:references/schema-patterns.md:162:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 162,
        "line_end": 162,
        "snippet": "user_id INTEGER NOT NULL,"
      },
      {
        "id": "blocker:references/schema-patterns.md:175:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/schema-patterns.md",
        "line_start": 175,
        "line_end": 175,
        "snippet": "-- Get valid session"
      },
      {
        "id": "external_commands:SKILL.md:17:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 17,
        "line_end": 26,
        "snippet": "```python"
      },
      {
        "id": "external_commands:SKILL.md:26:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 26,
        "line_end": 30,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:30:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 30,
        "line_end": 41,
        "snippet": "```python"
      },
      {
        "id": "external_commands:SKILL.md:41:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 41,
        "line_end": 47,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:47:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 47,
        "line_end": 49,
        "snippet": "```python"
      },
      {
        "id": "external_commands:SKILL.md:49:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 49,
        "line_end": 62,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:62:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 62,
        "line_end": 63,
        "snippet": "| Thread safety | Use `check_same_thread=False` |"
      },
      {
        "id": "external_commands:SKILL.md:63:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 63,
        "line_end": 67,
        "snippet": "| FK not enforced | Run `PRAGMA foreign_keys=ON` |"
      },
      {
        "id": "external_commands:SKILL.md:67:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 67,
        "line_end": 73,
        "snippet": "```bash"
      },
      {
        "id": "external_commands:SKILL.md:73:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 73,
        "line_end": 86,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:86:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 86,
        "line_end": 87,
        "snippet": "- `./references/schema-patterns.md` - State, cache, event, queue table designs"
      },
      {
        "id": "external_commands:SKILL.md:87:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 87,
        "line_end": 88,
        "snippet": "- `./references/async-patterns.md` - aiosqlite CRUD, batching, connection pools"
      },
      {
        "id": "sensitive:SKILL.md:68:sqlite-database-file",
        "category": "sensitive",
        "severity": "medium",
        "pattern": "SQLite database file",
        "file": "SKILL.md",
        "line_start": 68,
        "line_end": 68,
        "snippet": "sqlite3 mydb.sqlite    # Open database"
      }
    ],
    "finding_verdicts": [
      {
        "id": "sensitive:references/async-patterns.md:71:certificate-key-files",
        "verdict": "confirmed",
        "confidence": 0.9,
        "severity": "high",
        "reason": "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."
      },
      {
        "id": "sensitive:references/async-patterns.md:158:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "sensitive:references/async-patterns.md:165:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "sensitive:references/async-patterns.md:198:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "blocker:references/async-patterns.md:46:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:57:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:76:system-reconnaissance",
        "verdict": "confirmed",
        "confidence": 0.91,
        "severity": "high",
        "reason": "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."
      },
      {
        "id": "blocker:references/async-patterns.md:90:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:119:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:120:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:135:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:139:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:203:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:212:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:233:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:235:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/async-patterns.md:239:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "sensitive:references/migration-patterns.md:314:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "sensitive:references/migration-patterns.md:317:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "sensitive:references/migration-patterns.md:320:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "sensitive:references/migration-patterns.md:323:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "sensitive:references/migration-patterns.md:326:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "sensitive:references/migration-patterns.md:329:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      },
      {
        "id": "blocker:references/migration-patterns.md:14:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:26:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:78:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:94:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:95:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:113:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:139:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:216:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:266:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/migration-patterns.md:304:system-reconnaissance",
        "verdict": "confirmed",
        "confidence": 0.87,
        "severity": "high",
        "reason": "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."
      },
      {
        "id": "network:references/schema-patterns.md:74:hardcoded-ip-address",
        "verdict": "false_positive",
        "confidence": 0.95,
        "reason": "The IP address is sample data inside an event payload for a local SQLite log table. It does not create a network connection or send data anywhere."
      },
      {
        "id": "blocker:references/schema-patterns.md:63:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/schema-patterns.md:90:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/schema-patterns.md:118:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/schema-patterns.md:136:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/schema-patterns.md:137:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/schema-patterns.md:147:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/schema-patterns.md:152:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/schema-patterns.md:162:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "blocker:references/schema-patterns.md:175:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.88,
        "reason": "The cited line is a SQLite schema, query, or documentation example for application tables. It does not inspect the host system or perform reconnaissance."
      },
      {
        "id": "external_commands:SKILL.md:17:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:26:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:30:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:41:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:47:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:49:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:62:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:63:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:67:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:73:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:86:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "external_commands:SKILL.md:87:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.92,
        "reason": "The cited text is markdown syntax, inline formatting, or a local SQLite CLI example. It is not Ruby backtick execution and does not execute by itself."
      },
      {
        "id": "sensitive:SKILL.md:68:sqlite-database-file",
        "verdict": "false_positive",
        "confidence": 0.9,
        "reason": "The cited database path is a placeholder or parameter in documentation for local SQLite use. No real database file, credential, or secret content is embedded."
      }
    ],
    "semantic_findings": [
      {
        "title": "Unvalidated JSON Path Interpolation",
        "description": "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.",
        "severity": "high",
        "locations": [
          {
            "file": "references/migration-patterns.md",
            "line_start": 296,
            "line_end": 296
          }
        ],
        "confidence": 0.86,
        "confidence_reasoning": "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."
      }
    ],
    "critical_findings": [],
    "high_findings": [
      {
        "title": "Certificate/key files",
        "description": "set_clause = \", \".join(f\"{k} = ?\" for k in updates.keys())",
        "locations": [
          {
            "file": "references/async-patterns.md",
            "line_start": 71,
            "line_end": 71
          }
        ],
        "review_kind": "security",
        "source_category": "sensitive",
        "source_severity": "high",
        "confidence": 0.9,
        "confidence_reasoning": "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."
      },
      {
        "title": "System reconnaissance",
        "description": "f\"UPDATE items SET {set_clause} WHERE id = ?\",",
        "locations": [
          {
            "file": "references/async-patterns.md",
            "line_start": 76,
            "line_end": 76
          }
        ],
        "review_kind": "security",
        "source_category": "blocker",
        "source_severity": "low",
        "confidence": 0.91,
        "confidence_reasoning": "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."
      },
      {
        "title": "System reconnaissance",
        "description": "f\"UPDATE events SET payload = json_set(payload, '$.{field}', ?) WHERE id = ?\",",
        "locations": [
          {
            "file": "references/migration-patterns.md",
            "line_start": 304,
            "line_end": 304
          }
        ],
        "review_kind": "security",
        "source_category": "blocker",
        "source_severity": "low",
        "confidence": 0.87,
        "confidence_reasoning": "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."
      },
      {
        "title": "Unvalidated JSON Path Interpolation",
        "description": "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.",
        "locations": [
          {
            "file": "references/migration-patterns.md",
            "line_start": 296,
            "line_end": 296
          }
        ],
        "review_kind": "security",
        "source_category": "semantic",
        "source_severity": "high",
        "confidence": 0.86,
        "confidence_reasoning": "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."
      }
    ],
    "medium_findings": [],
    "low_findings": [],
    "dangerous_patterns": [
      {
        "title": "System reconnaissance",
        "description": "f\"UPDATE items SET {set_clause} WHERE id = ?\",",
        "locations": [
          {
            "file": "references/async-patterns.md",
            "line_start": 76,
            "line_end": 76
          }
        ],
        "review_kind": "security",
        "source_category": "blocker",
        "source_severity": "low",
        "confidence": 0.91,
        "confidence_reasoning": "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."
      },
      {
        "title": "System reconnaissance",
        "description": "f\"UPDATE events SET payload = json_set(payload, '$.{field}', ?) WHERE id = ?\",",
        "locations": [
          {
            "file": "references/migration-patterns.md",
            "line_start": 304,
            "line_end": 304
          }
        ],
        "review_kind": "security",
        "source_category": "blocker",
        "source_severity": "low",
        "confidence": 0.87,
        "confidence_reasoning": "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."
      }
    ],
    "files_scanned": 6,
    "total_lines": 941,
    "audit_model": "codex",
    "audited_at": "2026-07-04T13:14:49.900Z",
    "agent_auto_install_policy": "confirmation_required",
    "manual_install_policy": "allowed"
  },
  "content": {
    "user_title": "Build Reliable SQLite Workflows",
    "value_statement": "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.",
    "seo_keywords": [
      "Claude",
      "Codex",
      "Claude Code",
      "SQLite",
      "Python sqlite3",
      "aiosqlite",
      "database migrations",
      "WAL mode",
      "local persistence",
      "schema design"
    ],
    "actual_capabilities": [
      "Shows sqlite3 connection setup with row factories, WAL mode, and foreign key enforcement.",
      "Provides transaction patterns with commit, rollback, and context manager examples.",
      "Includes schema templates for state, cache, events, queues, sessions, and full-text search.",
      "Covers aiosqlite CRUD, batch operations, connection pooling, streaming, and concurrent queries.",
      "Outlines migration patterns, rollback handling, JSON storage, and SQLite CLI maintenance commands."
    ],
    "limitations": [
      "It provides examples and guidance, not a runnable database library.",
      "It does not inspect or modify databases unless the user asks the agent to act.",
      "Examples need review before use with untrusted table, column, or JSON field names.",
      "It focuses on SQLite and does not cover PostgreSQL, MySQL, or distributed databases."
    ],
    "use_cases": [
      {
        "title": "Add Local Persistence",
        "description": "Design a small SQLite database for app state, settings, cache data, or event logs.",
        "target_user": "Python application developer"
      },
      {
        "title": "Maintain Embedded Databases",
        "description": "Plan migrations, backups, schema checks, and safe rollback steps for local database files.",
        "target_user": "DevOps engineer"
      },
      {
        "title": "Build Async Data Access",
        "description": "Create aiosqlite access patterns for web apps, workers, and MCP server persistence.",
        "target_user": "AI tool builder"
      }
    ],
    "prompt_templates": [
      {
        "title": "Create a Basic Schema",
        "scenario": "Beginner schema planning",
        "prompt": "Use sqlite-ops to design a simple SQLite schema for app settings and recent activity. Include table purposes and indexes."
      },
      {
        "title": "Add Safe Transactions",
        "scenario": "Intermediate Python workflow",
        "prompt": "Use sqlite-ops to refactor my Python sqlite3 writes into transaction-safe helpers with rollback behavior and foreign keys enabled."
      },
      {
        "title": "Plan Migrations",
        "scenario": "Advanced schema evolution",
        "prompt": "Use sqlite-ops to create a migration plan for adding users and orders tables to an existing SQLite database."
      },
      {
        "title": "Review Async Access",
        "scenario": "Advanced async optimization",
        "prompt": "Use sqlite-ops to review my aiosqlite access layer for connection lifetime, batching, streaming, and query safety."
      }
    ],
    "output_examples": [
      {
        "input": "I need a cache table for API responses.",
        "output": "A table design with cache keys, stored values, creation time, expiry time, and cleanup guidance."
      },
      {
        "input": "I need to migrate an existing local database.",
        "output": "A migration sequence with version tracking, backup steps, rollback notes, and verification checks."
      },
      {
        "input": "My async worker reads too many rows at once.",
        "output": "A streaming approach with batch sizing, row conversion guidance, and connection cleanup notes."
      }
    ],
    "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."
    ],
    "anti_patterns": [
      "Do not concatenate user input into SQL identifiers or JSON path expressions.",
      "Do not run dump, restore, or vacuum commands on unknown database paths.",
      "Do not keep long write transactions open while serving concurrent readers."
    ],
    "faq": [
      {
        "question": "Does this skill include runnable code?",
        "answer": "It includes documentation examples and patterns. Users must adapt and test them inside their own project."
      },
      {
        "question": "Can it work with async Python applications?",
        "answer": "Yes. It includes aiosqlite patterns for CRUD, batching, connection pooling, streaming, and concurrent reads."
      },
      {
        "question": "Does it support database migrations?",
        "answer": "Yes. It describes version tracking, named migrations, rollback patterns, table recreation, and CLI migration checks."
      },
      {
        "question": "Is it limited to SQLite?",
        "answer": "Yes. The guidance targets SQLite and Python sqlite3 or aiosqlite usage."
      },
      {
        "question": "Can it help with local AI tool storage?",
        "answer": "Yes. It covers state tables, caches, queues, logs, sessions, and MCP server persistence patterns."
      },
      {
        "question": "What should users review before copying examples?",
        "answer": "Users should validate dynamic identifiers, protect database paths, add tests, and back up data before migrations."
      }
    ]
  },
  "file_structure": [
    {
      "name": "assets",
      "type": "dir",
      "path": "assets",
      "children": [
        {
          "name": ".gitkeep",
          "type": "file",
          "path": "assets/.gitkeep",
          "lines": 0
        }
      ]
    },
    {
      "name": "references",
      "type": "dir",
      "path": "references",
      "children": [
        {
          "name": "async-patterns.md",
          "type": "file",
          "path": "references/async-patterns.md",
          "lines": 289
        },
        {
          "name": "migration-patterns.md",
          "type": "file",
          "path": "references/migration-patterns.md",
          "lines": 331
        },
        {
          "name": "schema-patterns.md",
          "type": "file",
          "path": "references/schema-patterns.md",
          "lines": 230
        }
      ]
    },
    {
      "name": "scripts",
      "type": "dir",
      "path": "scripts",
      "children": [
        {
          "name": ".gitkeep",
          "type": "file",
          "path": "scripts/.gitkeep",
          "lines": 0
        }
      ]
    },
    {
      "name": "SKILL.md",
      "type": "file",
      "path": "SKILL.md",
      "lines": 89
    }
  ]
}
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall