Using MySQL from a TypeScript Agent
The TypeScript SDK already includes the host module declaration for golem:rdbms/mysql@1.5.0.
Imports
import { DbConnection, type DbValue } from "golem:rdbms/mysql@1.5.0";Open a Connection
const conn = DbConnection.open("mysql://user:password@localhost:3306/app");Query Data
MySQL placeholders use ?.
const result = conn.query("SELECT ?", [{ tag: "varchar", val: "hello" } satisfies DbValue]);
const value = result.rows[0]?.values[0];
if (
!value ||
!["varchar", "text", "tinytext", "mediumtext", "longtext", "fixchar"].includes(value.tag)
) {
throw new Error(`Unexpected MySQL value: ${JSON.stringify(value)}`);
}
const message = value.val;Execute Statements
conn.execute("INSERT INTO notes (id, body) VALUES (?, ?)", [
{ tag: "int", val: 1 },
{ tag: "varchar", val: "hello" },
]);Transactions
const tx = conn.beginTransaction();
tx.execute("UPDATE notes SET body = ? WHERE id = ?", [
{ tag: "varchar", val: "updated" },
{ tag: "int", val: 1 },
]);
tx.commit();