Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add Desko77/claude-code-skills-1c --skill 1c-query-optimizationgit clone --depth 1 https://github.com/Desko77/claude-code-skills-1cWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/desko77/claude-code-skills-1c/1c-query-optimization)<a href="https://agentmods.dev/skills/desko77/claude-code-skills-1c/1c-query-optimization"><img src="https://agentmods.dev/badge/skills/desko77/claude-code-skills-1c/1c-query-optimization/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/desko77/claude-code-skills-1c/1c-query-optimization"><img src="https://agentmods.dev/badge/skills/desko77/claude-code-skills-1c/1c-query-optimization.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00038 | $0.00795 |
| Opus 5 | $0.00019 | $0.00398 |
| Sonnet 5 | $0.00008 | $0.00159 |
| Haiku 4.5 | $0.00004 | $0.00080 |
Grade A, and why
1c-query-optimization scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 5d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
Copies of this mod
1 near-identical copy found in the catalogue:
- 1c-query-optimization — 100% identical, 0 lines differ
How it starts
The opening of the file, as written. The whole thing — 73 lines — stays where its author put it; the contents beside it link to each section on GitHub.
1C Query Optimization Skill (Advanced Patterns)
Продвинутые паттерны оптимизации запросов. Базовые оптимизации (ВЫРАЗИТЬ, ПРЕДСТАВЛЕНИЕ, ВТ вместо подзапросов, ОБЪЕДИНИТЬ ВСЕ, индексы, СКД) - см. правило query-optimization-tips.md. Анти-паттерны (запрос в цикле, обращение через точку) - см. anti_patterns.md.
Validate Query via AI-EDT
Если сервер AI-EDT подключен (инструменты ai-edt доступны), проверяй оптимизированный запрос через validate_query - убедись, что после рефакторинга нет синтаксических/семантических ошибок. Для запросов СКД: dcsMode=true.
When to Use
Invoke this skill when:
- Working with complex multi-step data processing
- Optimizing joins and subqueries
- Implementing DCS reports
- Processing large datasets in portions
Temporary Tables - When to Use
Use temporary tables for:
- Complex multi-step data processing
- Joining data from multiple sources
- Reusing intermediate results
Join vs Subquery (basic choice)
// PREFERRED: Join (usually faster)
"ВЫБРАТЬ
| Заказы.Ссылка КАК Заказ,
| Контрагенты.ИНН КАК ИНН
|ИЗ
| Документ.ЗаказКлиента КАК Заказы
| ЛЕВОЕ СОЕДИНЕНИЕ Справочник.Контрагенты КАК Контрагенты
| ПО Заказы.Контрагент = Контрагенты.Ссылка"
// AVOID: Subquery in SELECT (N+1 problem)
"ВЫБРАТЬ
| Заказы.Ссылка КАК Заказ,
| (ВЫБРАТЬ К.ИНН ИЗ Справочник.Контрагенты КАК К
| ГДЕ К.Ссылка = Заказы.Контрагент) КАК ИНН
|ИЗ
| Документ.ЗаказКлиента КАК Заказы"
Avoid Aggregation in Subqueries
// SLOW: Subquery with aggregation
"ВЫБРАТЬ
| Номенклатура.Ссылка,
| (ВЫБРАТЬ СУММА(Остатки.Количество) ...) КАК Остаток
|ИЗ
| Справочник.Номенклатура КАК Номенклатура"
// FAST: Join with pre-aggregated data
"ВЫБРАТЬ
| Номенклатура.Ссылка КАК Номенклатура,
| ЕСТЬNULL(Остатки.КоличествоОстаток, 0) КАК Остаток
|ИЗ
| Справочник.Номенклатура КАК Номенклатура
| ЛЕВОЕ СОЕДИНЕНИЕ РегистрНакопления.ТоварыНаСкладах.Остатки КАК Остатки
| ПО Номенклатура.Ссылка = Остатки.Номенклатура"
Reference: ITS Query Optimization Standards
What ships with it
1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 5d ago First seen · 73 lines · 38 tokens per session scan A f66f42cfbbe1
1c-query-optimization is a skill published in the GitHub repository Desko77/claude-code-skills-1c (60 stars, last pushed 6d ago), licensed MIT. It adds 38 tokens to every session and 795 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.
Other skills, from other repositories
1c-db-load-cf
A tool that imports a CF file into a 1C information base. A CF file is a binary package containing a 1C configuration.
1c-db-dump-cf
A tool that exports the configuration of a 1C information base to a CF file. A CF file contains the configuration, but not the database's business data.
1c-db-dump-dt
A tool that exports an entire 1C information base to a DT backup file. The file includes the configuration, data, users, and settings.
1c-query-validate
A checker for 1C query text against an exported configuration index. It verifies that referenced tables, register tables, tabular parts, and fields exist.
kd2-rules
A skill for creating and editing data-exchange rules in the 1C Data Conversion 2.0 application through an HTTP toolkit. It exports the resulting rules as XML for use in another 1C configuration.
1c-db-create
A tool for creating a new 1C information base, either as a local file-based database or on a server. It can also create one from a template.