Databases

Databases give StackMachine apps durable application state for records, user data, queues, and product workflows. Create a database for an app, store the returned credentials securely, and rotate credentials whenever access changes.

Features

Per-app databases

Create databases against an app ID and list the databases attached to that app. The SDK returns host, port, username, and explorer URLs where available.

Engine selection

The JavaScript SDK accepts POSTGRES, MYSQL, or SQLITE as database engines. Use the engine that matches your application runtime and migration workflow.

Credentials returned once

Creation and rotation return a plaintext password once. Store it as an environment variable or secret immediately.

Credential rotation

Rotate database credentials from the SDK when replacing secrets or handing ownership to another environment.

Common workflow

Create the database with the app ID, engine, and name.
Store the returned password in the app environment.
List databases to verify the attachment.
Rotate credentials when access should change.

SDK examples

Create, list, and rotate credentials

Create a Postgres database for an app, inspect the connection fields, list databases, and rotate credentials.

databases.js

const { database, password } = await client.apps.databases.create({
  app: "da_XYZ",
  dbEngine: "POSTGRES",
  name: "primary",
});
 
console.log(database.host, database.port, database.username);
console.log("Initial password, returned once:", password);
 
const databases = await client.apps.databases
  .list({ app: "da_XYZ", limit: 10 })
  .autoPagingToArray({ limit: 25 });
console.log(databases.map((item) => item.name));
 
const rotated = await client.apps.databases.rotateCredentials(database.id);
console.log("Rotated password, returned once:", rotated.password);

Source: stackmachine/sdks JavaScript examples.