SkillFoxx

Bitrix24 BI Reports Skill

Claude Skills для Битрикс24

A skill for Bitrix24's BI constructor on Trino and Superset: datasets, SQL patterns and a table of common pitfalls

  • 1 ★ on the repository
  • Last commit
  • MIT
Skill

Minimal access

Why this level

  • Only produces SQL queries and reporting advice, does not write to the portal
  • Requires read access to the portal's BI constructor
All reasons and checks
Russian stack

maxadrom/maxadrom-bitrix24-skillsAuthor:Максим

Install

Services

In your terminal, with SkillFoxx CLI

npx skillfoxx add skills/claude-skills-dlya-bitriks24

Detects the agents on your machine, shows the access level and pins the version.

Other ways to install

Access and checks

How we review

Minimal accessThe tool runs nothing and makes no network calls.

  • Only produces SQL queries and reporting advice, does not write to the portal
  • Requires read access to the portal's BI constructor

This is third-party code. Review the repository files before installing.

What it does

The bitrix24-bi-reports skill packages hands-on experience building reports and dashboards in Bitrix24's BI constructor (Trino on top of Apache Superset 6.0). It has a dataset catalog (tasks, CRM, stage history, products and stock, smart processes, telephony, orders, traffic, business processes) noting which tables are verified in real reports. It also covers Trino-specific syntax (CONCAT instead of ||, MOD instead of %, type casting between deal and stage fields), SQL patterns for clickable links, cumulative funnels and conversions, telephony gotchas (not confusing call_duration with record_duration), the structure of smart processes, and coloring table cells via CONCAT and HTML because Superset's built-in conditional formatting does not work for string columns. It includes a table of over 20 common problems with fixes and a 15-point checklist before delivering a report.

Who it is for. For anyone building reports and dashboards in Bitrix24's BI constructor who wants to avoid known Trino and SQL pitfalls.

Good fit when

  • You need to write a Trino SQL query against Bitrix24 data in the BI constructor
  • You need a sales funnel, stage-conversion or call report
  • You are not sure why a query fails with a Trino type or syntax error

Not a fit when

  • You need the Bitrix24 REST API, not the Trino-based BI constructor
  • You need .docx document generation: that skill is not ready yet, only announced as coming

Example request

Build a quarterly deal stage-conversion report in the Bitrix24 BI constructor

Limitations

The skill covers only the BI constructor (Trino and Superset), not the general Bitrix24 REST API. Datasets and fields can differ by portal; the author marks which tables are verified and which still need exploring. A second skill, bitrix24-documents, is not published yet.

How to disable. Remove the skills/bitrix24-bi-reports folder from your agent's skills directory (~/.claude/skills/, ~/.codex/skills/ or ~/.qwen/skills/ depending on the agent).

FAQ

Why doesn't plain SQL work in the BI constructor?

Because it runs on Trino, not MySQL: you need CONCAT instead of ||, MOD instead of %, and explicit casting between VARCHAR and BIGINT, and the skill collects these differences in one place.

Does the skill work outside Claude?

Yes, SKILL.md follows the open Agent Skills standard and installs into ChatGPT, Codex and Qwen Code, only the install path changes.

Discussion

No questions or reviews yet.

All Bitrix24 tools
Russian stack

A skill for administering, diagnosing and developing boxed Bitrix24 and Bitrix Framework, built from official documentation

SkillExtended access1
Russian stack

Four skills for Bitrix24 apps: install and OAuth, a batching REST client, events and iframe placements, CRM business processes and calendar

SkillExtended access

Bitrix24 BI-connector Claude Code skill

Bitrix24 BI-connector — Claude Code skill

Russian stack

A Claude Code skill for Bitrix24 BI-analytics: list tables, describe columns and pull rows with natural-language filters

SkillExtended access9
Russian stack

A Claude Code skill that parses and validates Bitrix24 business process bpt templates and finds broken activity and constant references

SkillExtended access
Official

Router skills with operational coding rules for 1C-Bitrix and Bitrix24: controllers, ORM, cache, routing

SkillMinimal access27
Russian stack

A Bitrix24 REST skill split into capability packs with a method allowlist, risk confirmations and an audit log

SkillBroad access26

README in short

The README describes a collection of Claude Skills for Bitrix24 with one finished skill, bitrix24-bi-reports, and a second, bitrix24-documents, announced as coming. It gives a table of trigger phrases, lists the skill's contents in detail (datasets, Trino specifics, SQL patterns, telephony, smart processes, formatting, pitfalls, checklist) and install paths for Claude.ai, Claude Code, ChatGPT, Codex and Qwen Code. The author identifies as a Bitrix24 expert and invites PRs with new pitfalls. MIT license.

README badge

Report a problem