bitrix-database
D7 Connection, SqlHelper, SqlExpression placeholders, raw SQL, upserts, transactions, named locks, DDL builders, SqlTracker. Use when ORM is not enough: bulk SQL, reports, extra connections, schema changes, query debugging.
How do I install this agent skill?
npx skills add https://github.com/bxmaximum/bitrix-framework-skills --skill bitrix-databaseIs this agent skill safe to install?
- Gen Agent Trust Hubpass
The skill provides a comprehensive and secure guide for interacting with the Bitrix database using the D7 API. It explicitly mandates safety practices such as using SqlExpression placeholders and SqlHelper for escaping to prevent SQL injection. No malicious code, unauthorized access, or data exfiltration patterns were detected.
- Socketpass
No alerts
- Snykpass
Risk: LOW · No issues
What does this agent skill do?
Direct database access
Baseline: main 23.0+ · Verified: main 26.800.0
ORM first (bitrix-orm: query(), batch writes, merge, deleteByFilter). Drop to SQL for upserts, windows/CTE, heavy reports, extra connections and schema changes.
| Task | Read |
|---|---|
connections config, extra DBs, charset, after-connect hook, named locks | rules/connections.md |
query*, add/addMulti, SqlHelper, placeholders, upsert, transactions | rules/queries.md |
| DDL builders, table/index changes, SqlTracker | rules/ddl-debug.md |
Invariants
- Every value reaches SQL through
SqlExpressionplaceholders orSqlHelper(forSql,convertToDb*). The$bindsargument ofquery()/queryExecute()is not a prepared statement. - Identifiers from input: whitelist first, then
quote()/?#. - Raw writes skip ORM events and cache: call
XxxTable::cleanCache()afterwards. - Portable SQL only: SqlHelper functions, no backticks,
ENGINE,UNSIGNED(bitrix-postgresql). - One connection per transaction; keep transactions short.
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/bxmaximum/bitrix-framework-skills/bitrix-database">View bitrix-database on skillZs</a>