boxlang-database-access

Name: boxlang-database-access
Availability: InStock
Author: BoxLang

Enforce parameterized queries and manage datasources in BoxLang.

Updated Apr 10, 2026

Search Tags:#database #sql #transactions #parameterized-queries #stored-procedures #boxlang #datasource-config

Ready to run

npx skills add https://github.com/ortus-boxlang/skills --skill boxlang-database-access-ortus-boxlang

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: boxlang-database-access
Source: https://github.com/ortus-boxlang/skills/tree/main/boxlang-developer/database-access
Command: npx skills add https://github.com/ortus-boxlang/skills --skill boxlang-database-access-ortus-boxlang

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

BoxLang Database Access provides a robust, consistent pattern for interacting with relational databases from BoxLang, including safe parameterized queries, datasource configuration, and support for transactions and stored procedures.

Core Features & Use Cases

Parameterized queries to prevent SQL injection in queryExecute and bx:query.
Datasource configuration via boxlang.json or Application.bx with main and read replicas.
Support for transactions, stored procedures, and QoQ for in-memory data processing with multiple datasources.
Usage scenarios include implementing authentication audit logs, reporting, and data migrations.

Quick Start

Use BoxLang’s parameterized query workflow to safely fetch data from your configured datasource with queryExecute or bx:query.

Frequently Asked Questions about boxlang-database-access

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

FAQPage Schema

How do I write parameterized queries in BoxLang to prevent SQL injection?▼

Parameterized queries in BoxLang prevent SQL injection by binding variables safely using queryExecute or bx:query. This approach separates SQL logic from data values, ensuring user input is treated strictly as data rather than executable code.

How do I configure a datasource in BoxLang using boxlang.json or Application.bx?▼

Datasource configuration in BoxLang is managed within boxlang.json or Application.bx files. You define connection properties directly in these configuration files, enabling structured setup for both main and read replicas across multiple datasources.

Can I use transactions and stored procedures with BoxLang database access?▼

Yes, BoxLang database access fully supports managing transactions and invoking stored procedures. It provides structured patterns for transaction control and executing stored procedures across single or multiple configured datasources.

What is the best way to handle multiple datasources for read replicas in BoxLang?▼

Handling multiple datasources in BoxLang involves configuring main and read replicas within boxlang.json or Application.bx. This setup enables efficient query load distribution by directing read operations to designated replica datasources.

Does BoxLang support Query of Queries for in-memory data processing?▼

Yes, BoxLang supports Query of Queries (QoQ) for in-memory data processing. This feature allows you to run SQL-like queries directly against existing result sets in memory, simplifying complex data manipulation workflows.