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

Use it for database tuning, scheduled maintenance, lock diagnosis, monitoring, backup and restore checks, high availability, and scaling.

It provides a measurement-based way to tune, maintain, diagnose, back up, and scale databases instead of relying on remembered settings.

1c-dba — Skill for Claude Code by vgtitov/bsl-ai-toolkit

Install

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.

Any agent

npx skills add vgtitov/bsl-ai-toolkit --skill 1c-dba

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.

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.

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 3,082 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.

Model	Per session	Once invoked
Fable 5.1	$0.00501	$0.03082
Opus 5.5	$0.00200	$0.01233
Sonnet 5.5	$0.00100	$0.00616
Haiku 4.5	$0.00050	$0.00308

Measured 20d ago against content hash c62f818b5a29, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, 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 20d 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 · 130 lines

How it starts

The opening of the file, as written. The whole thing — 130 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 · 130 lines

Files

What ships with it

13 files 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.

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.

20d ago Changed · +6 lines c62f818b5a29
2mo 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 (34 stars, last pushed 3d ago), licensed MIT. It adds 501 tokens to every session and 3,082 once invoked, about $0.0020 per session on Opus 5.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.

1c 1c-enterprise Claude Code Databases PostgreSQL ai bsl claude

1c-dba next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
1c-dbavgtitov/bsl-ai-toolkit	Skill	34	3d ago	MIT	B	501	Claude Code
composing-1c-queriesDesko77/claude-code-skills-1c	Skill	92	7d ago	MIT	A	174	Claude Code, Codex
1c-db-listDesko77/claude-code-skills-1c	Skill	92	7d ago	MIT	A	47	Claude Code
1c-db-updateDesko77/claude-code-skills-1c	Skill	92	7d ago	MIT	A	37	Claude Code
1c-query-validateDesko77/claude-code-skills-1c	Skill	92	7d ago	MIT	A	60	Claude Code
1c-db-createDesko77/claude-code-skills-1c	Skill	92	7d ago	MIT	A	32	Claude Code
1c-db-dump-xmlDesko77/claude-code-skills-1c	Skill	92	7d ago	MIT	A	49	Claude Code

1c-dba