skills.rest
ortus-docs
ortus-docsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

boxlang-database-access

Write parameterized BoxLang database queries with queryExecute and bx:query.

16|78|Updated Nov 28, 2014
Search Tags:#database#transactions#datasource#jdbc#parameterized-queries#boxlang#queryexecute
One-click install
npx skills add https://github.com/ortus-docs/coldbox-docs --skill boxlang-database-access
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: boxlang-database-access
Source: https://github.com/ortus-docs/coldbox-docs/tree/main/.agents/skills/boxlang-database-access
Command: npx skills add https://github.com/ortus-docs/coldbox-docs --skill boxlang-database-access

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

BoxLang developers need reliable, safe, and efficient access to relational databases from BoxLang code, including executing parameterized queries, managing datasources, and handling transactions.

Core Features & Use Cases

  • Supports queryExecute (script) and bx:query (tag) with parameterization to prevent SQL injection.
  • Datasource configuration in boxlang.json or Application.bx, transaction support, and stored procedures for complex data workflows.
  • Use Case: Build data access layers for multi-datasource applications with robust error handling and QoQ capabilities.

Quick Start

Configure your main datasource and execute a simple parameterized query to retrieve sample data.

Frequently Asked Questions about boxlang-database-access

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

FAQPage Schema
How do I prevent SQL injection in BoxLang database queries?▼

You prevent SQL injection in BoxLang by using parameterized queries with queryExecute or bx:query, ensuring user input is safely separated from SQL statements.

What's the best way to configure multiple datasources in a BoxLang application?▼

Configure multiple datasources in BoxLang by defining them within boxlang.json or Application.bx, enabling your application to connect to and manage several distinct relational databases simultaneously.

How do I handle database transactions across multiple datasources in BoxLang?▼

Handle database transactions across multiple datasources in BoxLang using its built-in transaction management features, ensuring data integrity during complex multi-database data workflows.

Does BoxLang support stored procedures and Query of Queries?▼

Yes, BoxLang supports executing stored procedures for complex data workflows and provides Query of Queries (QoQ) capabilities for filtering and querying in-memory result sets.

Can I use both script and tag syntax for BoxLang database access?▼

Yes, you can write BoxLang database access code using either the script-based queryExecute function or the bx:query tag, both supporting parameterized queries to prevent SQL injection.

Related Skills

Explore More Software Engineering Skills→
ortus-docsortus-docs
16

boxlang-configuration

Configure BoxLang runtime settings via boxlang.json and environment variables.

Official
Intermediate
AgentPMTAgentPMT

web-data-convertor

Convert data between JSON, CSV, XML, YAML, Markdown, and HTML formats.

Official
Intermediate
ortus-boxlangortus-boxlang

bx-orm-querying

Query and manage ORM entities in BoxLang with HQL-style queries and lifecycle BIFs.

Official
Advanced
matlabmatlab
883

matlab-write-database

Write MATLAB table data to relational databases with transactions.

Official
Intermediate