Agent skill

DB Performance

by IngvarConsulting in IngvarConsulting/unica

Производительность БД и запросов 1С. An agent skill from IngvarConsulting/unica.

Custom licenceAuto-check passedDatabases

Install DB Performance

skills CLI
$ npx skills add IngvarConsulting/unica --skill db-performance -a claude-code

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

GitHub CLI
$ gh skill install IngvarConsulting/unica db-performance --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/IngvarConsulting/unica.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/unica/skills/db-performance .claude/skills/db-performance && 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
db-performance
GitHub stars
215
Token cost
~920 tokens
SKILL.md length
451 words
Files
1
Skills in repo
50
Repo updated
First seen
Licence
Custom licence

At a glance

Производительность БД и запросов 1С. An agent skill from IngvarConsulting/unica.

  • Works in 7 steps: Name the slow scenario first: user… → Extract exact query/DCS text with… → Find callers with unica.search by the… → …
  • Tasks that involve Query optimization
  • SKILL.md covers MCP routing, References, Workflow and Stop rules, plus 1 more section
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

DB Performance is an agent skill from IngvarConsulting/unica. Производительность БД и запросов 1С. Используй когда нужно диагностировать slow query, SQL/DBMS trace, индексы, блокировки, deadlock, TEMPDB/WAL, размеры таблиц или СКД на больших данных.

Its SKILL.md is about 920 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, covering Query optimization and SQL. It works with SQL and Model Context Protocol. The repository describes itself as: Unica (Ю́ника) — публичный плагин Codex и Claude Code для разработки на 1С:Предприятии.

When your agent uses it

  • Tasks that involve Query optimization
  • Tasks that involve SQL

Example prompts

  • “/db-performance”

Workflow steps

7 steps, taken from the first numbered list in SKILL.md.

  1. Name the slow scenario first: user action, API call, report, background job, exchange step, or posting.
  2. Extract exact query/DCS text with unica.search or unica.view on the schema node; inspect large candidate modules with unica.view on the…
  3. Find callers with unica.search by the method name when the performance issue depends on execution path, query-in-loop risk, or impact of…
  4. Inspect unica.view on the object node for both the local object structure and related modules, roles, subscriptions, functional options…
  5. Gather evidence: row counts, generated SQL, query plan, managed locks, lock order, lock/deadlock participants, long transaction…
  6. Separate causes: inefficient platform query, missing or harmful index, broad virtual table read, query-in-loop, lock contention, DBMS…
  7. Propose one measurable change at a time; check syntax with unica.check (test runs are outside the v0.13 surface), and require separate…

What it can do on your machine

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

    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.

Context cost

DB Performance loads about 920 tokens when it runs. Until then it costs about 51 tokens; SKILL.md has 451 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
~920

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

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 451 words (~920 tokens).

“контракт каждой — argsSchema, execution, previewRequired, dryRunRequired. Контракт вызова бери оттуда, а не из этого текста; при implemented: true используй опубликованную argsSchema; при support.state: limited разрешено только подмножество support.supportedArgs. При support.state: unavailable остановись; не выдумывай аргументов при argsSchema: null. Для…”

— opening of SKILL.md by IngvarConsulting, Custom licence
name
db-performance

Read the full SKILL.md on GitHub

Files

Just SKILL.md in plugins/unica/skills/db-performance of IngvarConsulting/unica.

Open the folder on GitHubat commit 8053a33

Compare with similar skills

DB Performance 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.

DB Performance compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
DB Performance this skillIngvarConsulting/unica215—~920Automated safety check: PassCustom licence
Pytorch Clickhousepytorch/test-infra113—~2.8kAutomated safety check: PassCustom licence
Aurora Dsqlaws/agent-toolkit-for-aws2.8k—~9.6kAutomated safety check: PassApache-2.0
StarRocks SQL Doc Auto-FixStarRocks/starrocks12k—~7.6kAutomated safety check: NotesApache-2.0
Schema Explorationtimescale/pg-aiguide1.9k—~1.1kAutomated safety check: PassApache-2.0
SQL Optimization Patternsynulihao/AgentSkillOS61710 repos~3.3kAutomated safety check: PassNone

Similar skills

  • Pytorch Clickhouse

    pytorch/test-infra

    Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database.

    113 GitHub stars~2.8k tokensUpdated today
    DatabasesAuto-check passed
  • Aurora Dsql

    aws/agent-toolkit-for-aws

    Official

    Provisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless…

    2.8k GitHub stars~9.6k tokensUpdated today
    Backend & APIsAuto-check passed
  • StarRocks SQL Doc Auto-Fix

    StarRocks/starrocks

    Proposes verified fixes for failing SQL examples in StarRocks docs across three languages and several versions, then opens draft pull requests and never merges.

    12k GitHub stars~7.6k tokensUpdated today
    DatabasesAuto-check: notes
  • Schema Exploration

    timescale/pg-aiguide

    Explore an existing PostgreSQL database before answering questions about its data or writing SQL.

    1.9k GitHub stars~1.1k tokensUpdated 6 days ago
    DatabasesAuto-check passed
  • SQL Optimization Patterns

    ynulihao/AgentSkillOS

    Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

    617 GitHub starsUsed in 10 repos~3.3k tokens
    DatabasesAuto-check passed
  • PostgreSQL Documentation Reference

    2025Emma/vibe-coding-cn

    PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with PostgreSQL…

    23k GitHub starsUsed in 1 repo~19k tokens
    DatabasesAuto-check passed

More from IngvarConsulting/unica

All 50 skills in this repo
  • Unica Testing

    IngvarConsulting/unica

    Выбор, написание, запуск и ревью тестов самого Unica — граница проверки, размеры small/medium/large, Rust nextest, Python unittest и разбор падений.

    215 GitHub stars~3.3k tokensUpdated today
    Auto-check passed
  • API Design

    IngvarConsulting/unica

    Проектирование и ревью API 1С: публичный программный интерфейс, служебный интерфейс, переопределяемые модули, совместимость, версионирование и миграция потребителей.

    215 GitHub stars~1.8k tokensUpdated today
    Auto-check passed
  • Autonomous Server

    IngvarConsulting/unica

    Автономный сервер отладки 1С. An agent skill from IngvarConsulting/unica.

    215 GitHub stars~879 tokensUpdated today
    Auto-check passed
  • Bsp Patterns

    IngvarConsulting/unica

    Поиск и применение паттернов БСП. An agent skill from IngvarConsulting/unica.

    215 GitHub stars~808 tokensUpdated today
    Auto-check passed
  • Cfe Borrow

    IngvarConsulting/unica

    Заимствовать объект верхнего уровня из конфигурации 1С в расширение или обновить ранее заимствованный объект, сохранив его идентификаторы и локальные перекрытия.

    215 GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Cfe Diff

    IngvarConsulting/unica

    Анализ расширения конфигурации 1С (CFE) — состав, заимствованные объекты, перехватчики, сверка с конфигурацией.

    215 GitHub stars~1.2k tokensUpdated today
    Auto-check passed

Categories

Questions about DB Performance

What does DB Performance do?

Производительность БД и запросов 1С. An agent skill from IngvarConsulting/unica. DB Performance is an agent skill from IngvarConsulting/unica. Производительность БД и запросов 1С.

When should I use DB Performance?

DB Performance fits situations like: tasks that involve Query optimization; tasks that involve SQL.

How do I install DB Performance in Claude Code?

Run `npx skills add IngvarConsulting/unica --skill db-performance -a claude-code`. Or copy the skill folder (plugins/unica/skills/db-performance in IngvarConsulting/unica) into .claude/skills/db-performance in your project. Claude Code loads it when a task matches its description.

How do I install DB Performance in Codex?

Run `npx skills add IngvarConsulting/unica --skill db-performance -a codex`. Or copy the skill folder (plugins/unica/skills/db-performance in IngvarConsulting/unica) into .agents/skills/db-performance in your project. Codex loads it when a task matches its description.

Can I use DB Performance 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 IngvarConsulting/unica --skill db-performance -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/db-performance, .gemini/skills/db-performance, .github/skills/db-performance and .opencode/skills/db-performance in your project.

What does DB Performance need to run?

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

Does DB Performance 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 DB Performance 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 DB Performance use?

DB Performance has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does DB Performance use?

About 920 tokens (SKILL.md is roughly 3.7k 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 DB Performance?

Skills that share tags, products or a category with DB Performance: Pytorch Clickhouse (pytorch/test-infra, 113 stars), Aurora Dsql (aws/agent-toolkit-for-aws, 2.8k stars), StarRocks SQL Doc Auto-Fix (StarRocks/starrocks, 12k stars) and Schema Exploration (timescale/pg-aiguide, 1.9k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains DB Performance?

IngvarConsulting (a GitHub organization) maintains it in IngvarConsulting/unica, which has 215 GitHub stars. The repository holds 50 skills in this directory. The repository was last updated on October 7, 2026.

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