skills.rest
bxmaximum
bxmaximumCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

bitrix-database

Access Bitrix databases directly for migrations and bulk operations.

33|3|Updated Jun 5, 2025
Search Tags:#migrations#transactions#raw-sql#database-ops#bitrix-database#sqlhelper#sqlexpression
One-click install
npx skills add https://github.com/bxmaximum/bitrix_ai_challenge --skill bitrix-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bitrix-database
Source: https://github.com/bxmaximum/bitrix_ai_challenge/tree/main/.agents/skills/bitrix-database
Command: npx skills add https://github.com/bxmaximum/bitrix_ai_challenge --skill bitrix-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Direct Bitrix database access is required when ORM cannot handle bulk operations, complex SQL, migrations, or multi-connection tasks.

Core Features & Use Cases

  • Direct access to Database connections via Application::getConnection and Bitrix DB interfaces (MysqliConnection, Pgsql etc) for raw SQL, migrations, and bulk operations.
  • Supports transactions (startTransaction/commitTransaction/rollbackTransaction), DDL and migrations, and multi-connection workflows.
  • Suitable for bulk inserts, data migrations, reports, analytics, and external database work.

Quick Start

Run a migration or bulk data operation directly against Bitrix databases, bypassing ORM when needed.

Frequently Asked Questions about bitrix-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run raw SQL queries in Bitrix when ORM cannot handle complex bulk operations?▼

Use Application::getConnection() in Bitrix to access database connections directly and execute raw SQL with prepared-like placeholders, bypassing ORM limitations for complex bulk operations and reporting.

What is the best way to execute database migrations safely in Bitrix?▼

Execute database migrations safely in Bitrix by combining DDL and ORM-safe migration patterns with transactions using startTransaction, commitTransaction, and rollbackTransaction to ensure data integrity during schema changes.

Can I work with multiple database connections simultaneously in Bitrix for analytics tasks?▼

Yes, Bitrix supports multi-connection workflows via Application::getConnection, allowing you to query across default and analytics databases simultaneously for complex reporting and external database work.

When do I need to use SqlHelper and SqlExpression in Bitrix database operations?▼

Use SqlHelper and SqlExpression in Bitrix when building complex SQL expressions and applying prepared-like placeholders for raw SQL queries, ensuring safe dynamic query construction outside ORM.

Does direct database access in Bitrix support PostgreSQL connections?▼

Yes, direct Bitrix database access supports PostgreSQL via Pgsql connection interfaces alongside MysqliConnection, enabling raw SQL execution and transaction management across multiple database engines.

Related Skills

Explore More Software Engineering Skills→
MacPhobosMacPhobos

Prisma ORM - Type-Safe Database Toolkit

Manage TypeScript database schemas and operations with Prisma ORM.

Community
Advanced
ngxtmngxtm

Diesel ORM

Facilitate type-safe database interactions in Rust applications using Diesel ORM.

Community
Intermediate
cathayriskcathayrisk

sql-and-database

Provide SQLAlchemy patterns for safe database operations in Python.

Community
Intermediate
7a336e6e7a336e6e
1

Writing Queries

Generate SQLAlchemy ORM models and repository patterns with session management.

Community
Intermediate