1C Database Queries for Agents skill
1c-llm-requests
A tiny 1C extension with an HTTP service plus a skill, so an agent writes 1C queries itself and gets database data as TSV
- 56 ★ on the repository
- Last commit
- MIT
Extended access
Why this level
- The agent reads data from a working infobase, including personal data
- Infobase credentials are stored in a .env file
Install
- Works in
- Services
In your terminal, with SkillFoxx CLI
npx skillfoxx add skills/1c-llm-requestsDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewExtended accessThe tool runs code or makes network calls and only reads external data.
- The agent reads data from a working infobase, including personal data
- Infobase credentials are stored in a .env file
This is third-party code. Review the repository files before installing.
What it does
The extension publishes an HTTP service that accepts a 1C query text, checks its syntax and returns the result as a delimited table. The 1c-queries skill gives the agent bash and PowerShell scripts that read the URL and credentials from .env, plus detailed query writing rules: no ampersand parameters, always a FIRST N limit, reference comparison through attributes. This lets the agent investigate why a document fails to post using real data, or run ad hoc analysis. The author recommends pairing it with a metadata MCP so the agent reads the structure first.
Who it is for. For 1C developers and analysts who investigate errors and data in an infobase with an agent.
Good fit when
- You need to see why a document fails to post using actual data
- You need a one-off data analysis without building a report
- You need to verify that a 1C query is valid and returns what you expect
Not a fit when
- Infobase data must not be sent to an external model
- You need to modify data: the service is read-only
Example request
Why does receipt ССНФ-000002 from January 2 fail to post? Check the data in the infobaseLimitations
The agent reads any data the 1C user can see, including personal data: privacy is the infobase owner's responsibility, and the author suggests anonymizing data. You must install the extension and publish the HTTP service on a web server or via the standalone ibsrv server. The infobase login and password live in .env inside the skill folder.
How to disable. Delete .claude/skills/1c-queries from the project and disable the АПРО_ВнешниеЗапросы extension or the HTTP service publication.
FAQ
Can the agent break anything in the infobase?
According to the author, no: the service only runs read queries. But the agent can read everything the user has access to.
Why TSV instead of JSON?
A delimited table uses far fewer tokens, and models read it well.
Discussion
No questions or reviews yet.
Related
All 1C:Enterprise toolsA single-binary Go MCP server: the agent sees 1C metadata, searches code, runs read-only queries and writes accurate BSL
A 1C development skill collection for Codex and Claude Code: XML sources, forms, data composition, infobases, web publishing and an HTTP test bridge
A skill for 1C platform batch operations: build and unpack data processors, load and dump configurations and extensions, launch the base
A local OneScript MCP server for searching a 1C configuration dump right from Cursor
A free MCP server for a working 1C infobase: the agent reads data from plain requests and gets the metadata structure of any configuration
A guide with working scripts on safely connecting an agent to 1C and Bitrix24: OData, webhooks and a catalog of 14 vetted tools
README in short
The README explains that the extension is about twenty lines of code and grew out of debugging posting errors on real data. Quick start: install the extension, publish the HTTP service for a client-server or file infobase, test it with curl and fill the skill's .env. The author stresses the detailed SKILL.md and query syntax validation as agent feedback, shows sample reports and lists alternative solutions. MIT license.
README badge
Original SKILL.md
--- name: 1c-queries description: Выполняет запросы к базе данных 1С:Предприятие через HTTP-сервис. Используй этот навык когда нужно получить данные из 1С, выполнить анализ данных в базе 1С, написать или проверить запрос на языке 1С. --- # Выполнение запросов к базе 1С:Предприятие ## Обзор Этот навык позволяет выполнять запросы к базе данных 1С:Предприятие через HTTP-сервис. Используй его для анализа данных и получения информации из 1С. ## Скрипты для выполнения запросов Скрипты читают `.env` автоматически и отправляют запрос в 1С. **Windows (PowerShell):** ```powershell .\.claude\skills\1c-queries\scripts\query-1c.ps1 -Query 'ВЫБРАТЬ Кассы.Код, Кассы.Наименование ИЗ Справочник.Кассы КАК Кассы ГДЕ Кассы.Наименование = "Основная касса"' ``` **Linux (bash):** ```bash ./.claude/skills/1c-queries/scripts/query-1c.sh 'ВЫБРАТЬ Кассы.Код, Кассы.Наименование ИЗ Справочник.Кассы КАК Кассы ГДЕ Кассы.Наименование = "Основная касса"' ``` ## Формат ответа - Ответ в формате TSV (Tab-Separated Values) - Первая строка — заголовки колонок - Следующие строки — данные - При ошибке: HTTP 400 с описанием ошибки