Agent skill

Kysely Queries

by exelearning in exelearning/exelearning

Change eXeLearning Kysely queries, transactions, result conversions or database dialect adapters.

AGPL-3.0Auto-check passedDatabases

Install Kysely Queries

skills CLI
$ npx skills add exelearning/exelearning --skill kysely-queries -a claude-code

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

GitHub CLI
$ gh skill install exelearning/exelearning kysely-queries --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/exelearning/exelearning.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/kysely-queries .claude/skills/kysely-queries && 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
kysely-queries
GitHub stars
146
Token cost
~507 tokens
SKILL.md length
229 words
Files
1
Skills in repo
17
Repo updated
First seen
Licence
AGPL-3.0

At a glance

Change eXeLearning Kysely queries, transactions, result conversions or database dialect adapters.

  • Databases work in your project
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Kysely Queries is an agent skill from exelearning/exelearning. Change eXeLearning Kysely queries, transactions, result conversions or database dialect adapters.

Its SKILL.md is about 510 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. The repository describes itself as: eXeLearning is an AGPL-licensed free/libre tool to create and publish open educational resources. The licence is AGPL-3.0.

When your agent uses it

  • Databases work in your project

Example prompts

  • “/kysely-queries”

What it can do on your machine

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

    No scripts in the folder and no shell commands in SKILL.md.

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

  • Network

    Links to these hosts (documentation or services it may open):

    • kysely.dev

    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

Kysely Queries loads about 507 tokens when it runs. Until then it costs about 28 tokens; SKILL.md has 229 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~28
When it runs · the whole SKILL.md, loaded when a task matches
~507

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 exelearning/exelearning at commit 319b5d2, republished under its AGPL-3.0 licence (© exelearning). 229 words, ~507 tokens.

Download SKILL.mdSave it as .claude/skills/kysely-queries/SKILL.md (or your agent's skills folder).
name
kysely-queries
description
Change eXeLearning Kysely queries, transactions, result conversions or database dialect adapters.

Kysely queries

Read src/db/types.ts, client.ts, dialect.ts, helpers.ts, dialects/, and the affected file under src/db/queries/. Reference paths in this paragraph after the first are relative to src/db/. Consult Kysely documentation for the installed API.

  • Query functions accept the database/transaction argument. Pass the same transaction through all related writes; do not accidentally use the global connection inside a transaction.
  • Keep the project's snake_case schema and explicit result mappings. A TypeScript generic on sql<T> does not convert runtime strings, bigints, booleans or binary data.
  • Reuse supportsReturning() and existing insert/update helpers. The MySQL adapter takes the fallback path; do not add unconditional .returning()/.onConflict() from a PostgreSQL example.
  • Use toBinaryData()/fromBinaryData() for Yjs updates and snapshots. mysql2 requires Buffer handling; preserve typed-array offsets when converting results.
  • Preserve ownership/collaborator and status filters. Projects use active/archived/inactive states; do not invent a universal deleted_at rule. Keep denied mutations side-effect free.
  • Parameterize values. Dynamic identifiers need the existing validated identifier path; never interpolate user text into sql.raw. Builder queries are immutable: retain the returned query when adding filters.
  • Prefer queries that fetch only needed data and avoid repeated per-row work, but do not impose a new domain-object or {data} envelope architecture on existing functions.

Run the colocated query tests and relevant helpers.spec.ts/dialect tests. Include empty results, unauthorized access, rollback and dialect result conversions when affected. For schema changes, also load database-migration; SQLite-only success is not evidence of all-driver compatibility.

© exelearning, AGPL-3.0. 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 .agents/skills/kysely-queries of exelearning/exelearning.

Open the folder on GitHubat commit 319b5d2

Compare with similar skills

Kysely Queries 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.

Kysely Queries compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Kysely Queries this skillexelearning/exelearning146—~507Automated safety check: PassAGPL-3.0
Keeper Stress AnalysisClickHouse/ClickHouse50k—~4.7kAutomated safety check: PassApache-2.0
Perf ComparisonClickHouse/ClickHouse50k—~3.9kAutomated safety check: NotesApache-2.0
Patch Release CheckClickHouse/ClickHouse50k—~4kAutomated safety check: NotesApache-2.0
Evolving The Data ModelTriliumNext/Trilium38k—~2.1kAutomated safety check: PassAGPL-3.0
Hybrid Cloud Outboxesgetsentry/sentry46k—~4.8kAutomated safety check: PassCustom licence

Similar skills

  • Keeper Stress Analysis

    ClickHouse/ClickHouse

    Analyze ClickHouse Keeper stress-test results from play.clickhouse.com / keeperstresstests data warehouse.

    50k GitHub stars~4.7k tokensUpdated today
    DatabasesAuto-check passed
  • Perf Comparison

    ClickHouse/ClickHouse

    Evaluate ClickHouse performance test results from existing CI/dashboard data or local perf.py runs.

    50k GitHub stars~3.9k tokensUpdated today
    DatabasesAuto-check: notes
  • Patch Release Check

    ClickHouse/ClickHouse

    Check whether ClickHouse's supported versions (last 3 majors + latest LTS) have recent stable patch releases, diagnose why the scheduled AutoReleases pipeline failed, and identify which releases…

    50k GitHub stars~4k tokensUpdated today
    DatabasesAuto-check: notes
  • Evolving The Data Model

    TriliumNext/Trilium

    A skill your agent uses when adding a DB migration or a new column/field to a Becca entity in Trilium ("add a migration", "new column on notes/attributes", "ALTER TABLE", "add a field to…

    38k GitHub stars~2.1k tokensUpdated today
    DatabasesAuto-check passed
  • Hybrid Cloud Outboxes

    getsentry/sentry

    Official

    Guide for creating and maintaining outbox-based eventually consistent operations in Sentry.

    46k GitHub stars~4.8k tokensUpdated today
    DatabasesAuto-check passed
  • Adaptive Spin Wait

    microsoft/garnet

    Official

    Selects Garnet spin-wait policies based on the slow-path cost.

    12k GitHub stars~1k tokensUpdated today
    DatabasesAuto-check passed

More from exelearning/exelearning

All 17 skills in this repo
  • E2E Test

    exelearning/exelearning

    Write or debug repository Playwright specs, including isolated projects, preview frames and multi-user fixtures.

    146 GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Frontend Module

    exelearning/exelearning

    Change vanilla JavaScript UI modules in public/app/, including DOM state, events and localization.

    146 GitHub stars~867 tokensUpdated today
    Auto-check passed
  • I18n

    exelearning/exelearning

    Add or change source-level localized strings using (), c() or the Nunjucks trans filter; not catalog extraction.

    146 GitHub stars~812 tokensUpdated today
    Auto-check passed
  • Idevice

    exelearning/exelearning

    Create or modify an eXeLearning iDevice, including edition/export data, legacy compatibility, assets, TypeScript bundles and teardown.

    146 GitHub stars~1.7k tokensUpdated today
    Auto-check passed
  • Verify Change

    exelearning/exelearning

    Choose and run the appropriate eXeLearning checks for a diff, including the final code gates or guidance-only validation.

    146 GitHub stars~676 tokensUpdated today
    Auto-check passed
  • Websocket Yjs

    exelearning/exelearning

    Change eXeLearning shared document mutations, WebSocket rooms, snapshots, reconnects or concurrent editing behavior.

    146 GitHub stars~759 tokensUpdated today
    Auto-check passed

Categories

Questions about Kysely Queries

What does Kysely Queries do?

Change eXeLearning Kysely queries, transactions, result conversions or database dialect adapters. Kysely Queries is an agent skill from exelearning/exelearning. Change eXeLearning Kysely queries, transactions, result conversions or database dialect adapters.

When should I use Kysely Queries?

Kysely Queries fits situations like: databases work in your project.

How do I install Kysely Queries in Claude Code?

Run `npx skills add exelearning/exelearning --skill kysely-queries -a claude-code`. Or copy the skill folder (.agents/skills/kysely-queries in exelearning/exelearning) into .claude/skills/kysely-queries in your project. Claude Code loads it when a task matches its description.

How do I install Kysely Queries in Codex?

Run `npx skills add exelearning/exelearning --skill kysely-queries -a codex`. Or copy the skill folder (.agents/skills/kysely-queries in exelearning/exelearning) into .agents/skills/kysely-queries in your project. Codex loads it when a task matches its description.

Can I use Kysely Queries 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 exelearning/exelearning --skill kysely-queries -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/kysely-queries, .gemini/skills/kysely-queries, .github/skills/kysely-queries and .opencode/skills/kysely-queries in your project.

What does Kysely Queries need to run?

SKILL.md names no scripts, command-line tools or credentials: Kysely Queries is instructions for the agent only.

Does Kysely Queries access the network?

SKILL.md names 1 domain. As links in the text: kysely.dev. This is read from the text; nothing was executed.

Is Kysely Queries 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 Kysely Queries use?

Kysely Queries is published under the AGPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Kysely Queries use?

About 507 tokens (SKILL.md is roughly 2k 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 Kysely Queries?

Skills that share tags, products or a category with Kysely Queries: Keeper Stress Analysis (ClickHouse/ClickHouse, 50k stars), Perf Comparison (ClickHouse/ClickHouse, 50k stars), Patch Release Check (ClickHouse/ClickHouse, 50k stars) and Evolving The Data Model (TriliumNext/Trilium, 38k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Kysely Queries?

exelearning (a GitHub organization) maintains it in exelearning/exelearning, which has 146 GitHub stars. The repository holds 17 skills in this directory. The repository was last updated on October 7, 2026.

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