AI Skills
Skills are reusable markdown instruction files that can be injected into agent context automatically or loaded on demand.
🎓 What are Skills?
.ai/skills/
sql-optimizer/
SKILL.md
coding/
boxlang-expert/
SKILL.md
code-reviewer/
SKILL.mdSkill File Format
---
name: SQL Optimizer
description: >
Expert at writing and optimizing SQL queries for performance.
Use this skill when working with database queries, indexes,
or query performance.
---
# SQL Optimization Expert
You are an expert SQL query optimizer. When writing or reviewing queries:
1. Always consider index usage — prefer index-covered queries
2. Avoid `SELECT *` — specify only required columns
3. Use `EXPLAIN` to analyze query plans
4. Prefer JOINs over subqueries where possible
5. Use CTEs (WITH clauses) for complex multi-step logic
## Common Patterns
**Pagination:**
Use keyset pagination instead of OFFSET for large tables:
```sql
SELECT * FROM orders WHERE id > :lastId ORDER BY id LIMIT 20Lazy-Loaded Skills (availableSkills)
availableSkills)Combining Both
Using the aiSkill() BIF
aiSkill() BIFGlobal Skills
Fluent API
Related Pages
Last updated