bsl-ai-toolkit: Skill for Claude Code

.claude/skills/1c-dba/SKILL.md

1c-dba is a skill for Claude Code from vgtitov/bsl-ai-toolkit. It costs 501 tokens per session (2,841 once invoked), scanned B, original, MIT.

A database administration guide for 1C:Enterprise databases running mainly on PostgreSQL, including Postgres Pro Enterprise, and also on Microsoft SQL Server.

In plain words
What is it for?
Use it for database tuning, scheduled maintenance, lock diagnosis, monitoring, backup and restore checks, high availability, and scaling.
Why use it?
It provides a measurement-based way to tune, maintain, diagnose, back up, and scale databases instead of relying on remembered settings.

Skill for Claude Code

Written for Claude Code: installed under .claude/.

This is vgtitov/bsl-ai-toolkit's own configuration. It tells Claude Code how to work on bsl-ai-toolkit itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything bsl-ai-toolkit configures →

Reuse

Borrowing it

Nothing to install: this file belongs to vgtitov/bsl-ai-toolkit. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/vgtitov/bsl-ai-toolkit/main/.claude/skills/1c-dba/SKILL.md
Clone the repo
git clone --depth 1 https://github.com/vgtitov/bsl-ai-toolkit

Made for: Claude Code.

Wrote 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.

agentmods badge for 1c-dba

README.md
[![agentmods](https://agentmods.dev/badge/skills/vgtitov/bsl-ai-toolkit/1c-dba/github.svg)](https://agentmods.dev/skills/vgtitov/bsl-ai-toolkit/1c-dba)
Your own site
<a href="https://agentmods.dev/skills/vgtitov/bsl-ai-toolkit/1c-dba"><img src="https://agentmods.dev/badge/skills/vgtitov/bsl-ai-toolkit/1c-dba/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.

agentmods 80×15 button for 1c-dba

Your own site · 80×15
<a href="https://agentmods.dev/skills/vgtitov/bsl-ai-toolkit/1c-dba"><img src="https://agentmods.dev/badge/skills/vgtitov/bsl-ai-toolkit/1c-dba.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 501 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,841 The whole file, excluding the scripts and references it only reads on demand.
Security scan B 1 finding. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

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.

ModelPer sessionOnce invoked
Fable 5.1 $0.00501 $0.02841
Opus 5 $0.00251 $0.01421
Sonnet 5 $0.00100 $0.00568
Haiku 4.5 $0.00050 $0.00284

Measured 10d ago against content hash 079df56bbc99, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-10, from the pricing page.

Security

Grade B, and why

1c-dba scanned grade B with 1 finding 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 10d ago.

The scan reads SKILL.md. This mod also ships 2 executable files (scripts/pg_1c_daily_maintenance.sh, scripts/pg_periodic_freeze.sh), listed below but not scanned — reading those needs a real analyzer, not pattern matching.

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.

Asks for rootmediumPrivilege escalation

A mod that escalates privileges can change anything on the machine, not only the project.

(VACUUM FREEZE раз в месяц/квартал): что делают, как настроить `.conf` и `~/.pgpass` (chmod 0600).
.claude/skills/1c-dba/SKILL.md · 124 lines

How it starts

The opening of the file, as written. The whole thing — 124 lines — stays where its author put it; the contents beside it link to each section on GitHub.

DBA для 1С (PostgreSQL / MS SQL) — настраивать и обслуживать СУБД по измерениям, не по памяти

Локализация (сначала, если есть)

Если в скилле есть каталог references/local/ — прочитай его ПЕРЕД работой: version-stack.md (версии платформы/библиотек, режим совместимости, префиксы ТВОЕЙ компании) и остальные карты. При противоречии локальное побеждает generic. Контракт — docs/SKILL_LOCALIZATION.md toolkit.

Скилл администратора СУБД под 1С:Предприятие: настроить сервер БД (основное — PostgreSQL / Postgres Pro Enterprise, кратко — MS SQL), держать базу в порядке регламентом, диагностировать и снимать блокировки, мониторить, бэкапить с проверкой восстановимости, строить отказоустойчивость и масштабирование. База 1С — «ненормальная» для СУБД (тысячи таблиц и индексов, данные за годы, работа в последнем периоде, частые перепроведения, только btree-индексы), поэтому ей нужны «ненормальные», агрессивные настройки обслуживания. Адаптируется под любой проект — версии и железо заполни под себя.

Главное правило: сначала измерь, потом меняй

Нейросеть врёт в деталях СУБД и 1С: путает значения по умолчанию, единицы, поведение версий. Источник истины — реальное измерение и официальная справка, не память:

  • Перед выводом сними данные: pg_stat_activity / pg_locks / pg_stat_statements / pgpro_stats, EXPLAIN (ANALYZE, BUFFERS), iostat/vmstat/top, технологический журнал 1С (ТЖ), счётчики ОС. Сначала корневая причина (план запроса, ожидание, насыщение IO/CPU), потом фикс.
  • Любую правку postgresql.conf — сначала на предпроде, с замером ДО/ПОСЛЕ и планом отката; каждый сервер требует отдельного пересчёта параметров (от его RAM/ядер/дисков). Меняешь — снимаешь бэкап конфига и базы.
  • Параметры/пороги/поведение под конкретную версию СУБД, в которых не уверен, помечай [проверить] по справке (postgrespro.ru/docs под свою версию, ИТС), не выдавай за факт.
  • Пароли/токены/перс-данные — НИКОГДА в чат и репозиторий (см. «Безопасность»).

Read the full file on GitHub · 124 lines

Changes

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.

  1. 10d ago First seen · 124 lines · 501 tokens per session scan B 079df56bbc99

Subscribe to this mod's changes

1c-dba is a skill published in the GitHub repository vgtitov/bsl-ai-toolkit (21 stars, last pushed 2d ago), licensed MIT. It adds 501 tokens to every session and 2,841 once invoked, about $0.0025 per session on Opus 5. A static security scan graded it B with 1 finding (asks for root). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.