Agent skill

Iptvnator Sqlite DB Worker

by 4gray in 4gray/iptvnator

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.

MITAuto-check passedDatabases

Install Iptvnator Sqlite DB Worker

skills CLI
$ npx skills add 4gray/iptvnator --skill iptvnator-sqlite-db-worker -a claude-code

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

GitHub CLI
$ gh skill install 4gray/iptvnator iptvnator-sqlite-db-worker --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/4gray/iptvnator.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.codex/skills/iptvnator-sqlite-db-worker .claude/skills/iptvnator-sqlite-db-worker && 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
iptvnator-sqlite-db-worker
GitHub stars
7.3k
Token cost
~824 tokens
SKILL.md length
286 words
Files
1
Skills in repo
8
Repo updated
First seen
Licence
MIT

At a glance

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.

  • Changing Electron SQLite IPC
  • SKILL.md covers Ownership and Flow, Identity, Progress, and… and Rebuild and Verify
  • Calls pnpm
  • Database-worker operations

What it does

Iptvnator Sqlite DB Worker is an agent skill from 4gray/iptvnator. Use when changing Electron SQLite IPC, database-worker operations, request-scoped progress or cancellation, worker packaging, or runtime verification of non-EPG database work.

Its SKILL.md is about 820 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases. It works with SQLite. The repository describes itself as: :tv: Cross-platform IPTV player application with multiple features, such as support of m3u and m3u8 playlists, favorites, TV guide, TV archive/catchup and more. The licence is MIT.

When your agent uses it

  • Changing Electron SQLite IPC
  • Database-worker operations
  • Request-scoped progress
  • Worker packaging

Example prompts

  • “/iptvnator-sqlite-db-worker”

What it can do on your machine

Read from SKILL.md and the folder at commit 6c8f502. 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

    Shell commands in SKILL.md call:

    • pnpm

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use pnpm, which can reach the network depending on how they are called.

    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

Iptvnator Sqlite DB Worker loads about 824 tokens when it runs. Until then it costs about 51 tokens; SKILL.md has 286 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
~824

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 4gray/iptvnator at commit 6c8f502, republished under its MIT licence (© 4gray). 286 words, ~824 tokens.

Download SKILL.mdSave it as .claude/skills/iptvnator-sqlite-db-worker/SKILL.md (or your agent's skills folder).
name
iptvnator-sqlite-db-worker
description
Use when changing Electron SQLite IPC, database-worker operations, request-scoped progress or cancellation, worker packaging, or runtime verification of non-EPG database work.

IPTVnator SQLite DB Worker

Ownership and Flow

  • Renderer service: libs/services/src/lib/database-electron.service.ts
  • Preload API: apps/electron-backend/src/app/api/main.preload.ts
  • IPC handlers: apps/electron-backend/src/app/events/database/
  • Client: apps/electron-backend/src/app/services/database-worker-client.ts
  • Protocol: apps/electron-backend/src/app/workers/database-worker.types.ts
  • Thin dispatcher: apps/electron-backend/src/app/workers/database.worker.ts
  • Connection: apps/electron-backend/src/app/workers/database.worker-connection.ts
  • Runtime paths: apps/electron-backend/src/app/workers/worker-runtime-paths.ts
  • SQL operations: apps/electron-backend/src/app/database/operations/
  • Shared schema: libs/shared/database/src/lib/schema.ts
  • Bundler: apps/electron-backend/build-worker.js
  • Canonical guide: docs/architecture/sqlite-db-worker.md

The chain is renderer DatabaseService → preload IPC → main event handler → DatabaseWorkerClient and its request protocol → worker dispatcher → worker connection → operation module → shared @iptvnator/shared/database/schema, then response or request-scoped event back to the originating renderer. Keep SQL-heavy logic in operation modules and the worker entrypoint focused on dispatch/orchestration.

The build script produces three bundles: EPG parser, database, and playlist refresh. EPG parsing stays in its dedicated worker. Do not silently migrate lightweight download handlers or EPG-specific main-process query/mapping/fetch handlers as part of unrelated database work.

Identity, Progress, and Cancellation

requestId is generated for every client request and correlates worker event/response transport. operationId is the renderer-visible identity for long-operation progress and cooperative cancellation.

Tracked operations are save content, delete Xtream content, restore Xtream user data, delete playlist, and delete all playlists. The first four are cancellable. Delete-all is deliberately tracked with cancellable: false.

Cancellation is cooperative at chunk checkpoints. Committed chunks remain committed and the request finally rejects with AbortError. For the operation/busy lifecycle, only a terminal completed/error/cancelled event settles UI state; a cancel-requested flag may update immediately.

Inside synchronous better-sqlite3 transactions, prepared writes must use .run(). .execute() defers work and can commit a silent no-op.

Rebuild and Verify

After worker source changes:

bash
pnpm nx test electron-backend
pnpm nx run electron-backend:build-worker
stat dist/apps/electron-backend/workers/database.worker.js

Confirm the artifact timestamp, restart Electron, then run the closest Electron E2E or CDP workflow.

For SQL output, IPTVNATOR_TRACE_DB=1 and IPTVNATOR_TRACE_SQL=1 emit only fixed, allowlisted statement types through the shared redacting summary in libs/shared/logging/src/lib/sql-trace-summary.ts; never log expanded SQL or bound values. DB transport traces remain separately redacted.

© 4gray, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .codex/skills/iptvnator-sqlite-db-worker of 4gray/iptvnator.

Open the folder on GitHubat commit 6c8f502

Compare with similar skills

Iptvnator Sqlite DB Worker 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.

Iptvnator Sqlite DB Worker compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Iptvnator Sqlite DB Worker this skill4gray/iptvnator7.3k—~824Automated safety check: PassMIT
Analyze Nsys Profilemlc-ai/pith-train355—~1.9kAutomated safety check: PassApache-2.0
Reactive Sqlite UIfastrepl/anarlog9.5k—~699Automated safety check: PassMIT
Composer Forensicsdxos/dxos525—~3.1kAutomated safety check: PassCustom licence
Sqlite Schema Designfastrepl/anarlog9.5k—~1.9kAutomated safety check: PassMIT
MakemigrationsdeusXmachina-dev/memorylane121—~973Automated safety check: PassGPL-3.0

Similar skills

  • 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.5k 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.5k 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
  • Toon

    butttons/dora

    Token-Oriented Object Notation is a compact, human-readable encoding of the JSON data model that minimizes tokens and makes structure easy for models to follow.

    109 GitHub stars~9.4k tokensUpdated 7 mo ago
    DatabasesAuto-check passed

More from 4gray/iptvnator

All 8 skills in this repo
  • A skill your agent uses when deciding where IPTVnator code belongs, creating or moving Nx projects, changing scoped aliases or tags, editing lint targets, or validating module boundaries.

    7.3k GitHub stars~828 tokensUpdated today
    Auto-check passed
  • Release Cut

    4gray/iptvnator

    A skill your agent uses when preparing, cutting, tagging, publishing, or verifying an IPTVnator release or its release assets.

    7.3k GitHub stars~929 tokensUpdated today
    Auto-check passed
  • Release Notes

    4gray/iptvnator

    A skill your agent uses when a change may need a .changes note, the Release note gate fails, or deciding whether type: internal or no-release-note applies.

    7.3k GitHub stars~446 tokensUpdated today
    Auto-check passed
  • Iptvnator Theme Style

    4gray/iptvnator

    A skill your agent uses when changing IPTVnator SCSS tokens, shared layout mixins, portal headers, sidebars, detail views, Electron drag regions, or cross-portal visual consistency.

    7.3k GitHub stars~796 tokensUpdated today
    Auto-check passed
  • Iptvnator UI Design

    4gray/iptvnator

    A skill your agent uses when changing user-visible Angular UI in IPTVnator, especially channel rows or lists, EPG views, settings and playlist surfaces, selection states, shared portal components…

    7.3k GitHub stars~519 tokensUpdated today
    Auto-check passed
  • Stalker Portal

    4gray/iptvnator

    A skill your agent uses when changing Stalker or Ministra routes, stores, catalog or series shapes, playback progress, favorites and recent items, EPG, or remote control.

    7.3k GitHub stars~990 tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Iptvnator Sqlite DB Worker

What does Iptvnator Sqlite DB Worker do?

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. Iptvnator Sqlite DB Worker is an agent skill from 4gray/iptvnator. Use when changing Electron SQLite IPC, database-worker operations, request-scoped progress or cancellation, worker packaging, or runtime verification of non-EPG database work.

When should I use Iptvnator Sqlite DB Worker?

Iptvnator Sqlite DB Worker fits situations like: changing Electron SQLite IPC; database-worker operations; request-scoped progress; worker packaging.

How do I install Iptvnator Sqlite DB Worker in Claude Code?

Run `npx skills add 4gray/iptvnator --skill iptvnator-sqlite-db-worker -a claude-code`. Or copy the skill folder (.codex/skills/iptvnator-sqlite-db-worker in 4gray/iptvnator) into .claude/skills/iptvnator-sqlite-db-worker in your project. Claude Code loads it when a task matches its description.

How do I install Iptvnator Sqlite DB Worker in Codex?

Run `npx skills add 4gray/iptvnator --skill iptvnator-sqlite-db-worker -a codex`. Or copy the skill folder (.codex/skills/iptvnator-sqlite-db-worker in 4gray/iptvnator) into .agents/skills/iptvnator-sqlite-db-worker in your project. Codex loads it when a task matches its description.

Can I use Iptvnator Sqlite DB Worker 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 4gray/iptvnator --skill iptvnator-sqlite-db-worker -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/iptvnator-sqlite-db-worker, .gemini/skills/iptvnator-sqlite-db-worker, .github/skills/iptvnator-sqlite-db-worker and .opencode/skills/iptvnator-sqlite-db-worker in your project.

What does Iptvnator Sqlite DB Worker need to run?

Going by SKILL.md and its folder, Iptvnator Sqlite DB Worker needs the command-line tools its instructions call (pnpm).

Does Iptvnator Sqlite DB Worker 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 Iptvnator Sqlite DB Worker 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 Iptvnator Sqlite DB Worker use?

Iptvnator Sqlite DB Worker is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Iptvnator Sqlite DB Worker use?

About 824 tokens (SKILL.md is roughly 3.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Iptvnator Sqlite DB Worker?

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

Who maintains Iptvnator Sqlite DB Worker?

4gray (a GitHub user) maintains it in 4gray/iptvnator, which has 7,305 GitHub stars. The repository holds 8 skills in this directory. The repository was last updated on October 7, 2026.

Source: 4gray/iptvnator on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.