# Golem Add Ignite Moonbit

> Golem Add Ignite Moonbit is an Agent Skill for apps & automation published in the golemcloud/golem repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Using golem:rdbms/ignite2 from a MoonBit Golem agent. Use when the user asks to connect to Apache Ignite 2, run SQL over Ignite, or use Ignite from MoonBit agent code.

- Skill name: `golem-add-ignite-moonbit`
- Category: [Apps & Automation](https://www.openparable.com/skill/apps-automation/1)
- Source: https://github.com/golemcloud/golem/blob/HEAD/golem-skills/skills/moonbit/golem-add-ignite-moonbit/SKILL.md
- Repository: golemcloud/golem (1,605 GitHub stars when collected)

## SKILL.md

# Using Apache Ignite from a MoonBit Agent

The MoonBit SDK already includes the generated package for `golem:rdbms/ignite2@1.5.0`.

## Add the Package Import

In the component's `moon.pkg`, add an alias for the package:

```text
import {
  "golemcloud/golem_sdk/interface/golem/rdbms/ignite2" @ignite,
}
```

## Open a Connection

Ignite uses thin-client URLs like `ignite://host:10800`.

```moonbit
let conn = @ignite.DbConnection::open("ignite://127.0.0.1:10800")
  .or_error!("failed to connect to Ignite")
```

## Query Data

Ignite placeholders use `?`.

```moonbit
let result = conn.query(
  "SELECT ?",
  [@ignite.DbValue::DbString("hello")],
).or_error!("query failed")

let row = result.rows[0]
let value = row.values[0]

let message = match value {
  @ignite.DbValue::DbString(value) => value
  _ => abort("unexpected Ignite value")
}
```

## Execute Statements

```moonbit
conn.execute(
  #|CREATE TABLE IF NOT EXISTS notes (
  #|  id INT PRIMARY KEY,
  #|  body VARCHAR
  #|) WITH "CACHE_NAME=notes"
  ,
  [],
).or_error!("create table failed")
```

Include `WITH "CACHE_NAME=..."` when creating tables through Ignite SQL.

## Transactions

```moonbit
let tx = conn.begin_transaction().or_error!("failed to start transaction")
tx.execute(
  "INSERT INTO notes (id, body) VALUES (?, ?)",
  [@ignite.DbValue::DbInt(1), @ignite.DbValue::DbString("hello")],
).or_error!("insert failed")
tx.commit().or_error!("commit failed")
```

---

Source: https://www.openparable.com/skill/apps-automation/golem-add-ignite-moonbit (OpenParable). Cite the canonical URL above.
