curl -fsSl https://get.brightstack.ai/install | bash

bright login

bright engine create --name <ENGINE_NAME> --type <ENGINE_TYPE>

bright engine start <ENGINE_ID_OR_NAME>

bright engine list

bright sql run --engine <ENGINE_ID_OR_NAME> 'SELECT 1;'

bright engine stop <ENGINE_ID_OR_NAME>

bright engine start <ENGINE_ID_OR_NAME>

bright key create <name>

npm install @brightstack/client

// dw.ts
import { brightstack } from "@brightstack/client";

// will auto-detect settings from your environment
const dw = brightstack({
  apiKey: "MY_API_KEY",
  engine: "production",
  database: "myapp",
});

export default dw;

import dw from "./dw";

// Create a new database
await dw.sql("CREATE DATABASE hits;");

// Use the database
await dw.sql("USE hits;");

import dw from "./dw";

// Simple query
const result = await dw.sql("SELECT * FROM users LIMIT 10;");
// Result: [{ id: 'usr_d78as6bg', name: 'Bob' }]

// Create a table and insert data
await dw.sql(`
  CREATE TABLE products (
    id INTEGER PRIMARY KEY,
    name VARCHAR,
    price DECIMAL(10,2)
  );
`);

await dw.sql(`
  INSERT INTO products VALUES 
    (1, 'Laptop', 999.99),
    (2, 'Mouse', 29.99),
    (3, 'Keyboard', 79.99);
`);

// Query the data
const products = await dw.sql("SELECT COUNT(*) as total FROM products;");
console.log(products); // [{ total: '3' }]