PlanetScale provider

export PLANETSCALE_ORG="your-org"
export PLANETSCALE_SERVICE_TOKEN_ID="your-token-id"
export PLANETSCALE_SERVICE_TOKEN="your-token"

import alchemy from "alchemy";
import { Database, Branch, Password } from "alchemy/planetscale";

const app = await alchemy("planetscale-app");

// Create a PlanetScale database
const database = await Database("db", {
  name: "my-database",
  region: "us-east",
});

// Create a development branch
const devBranch = await Branch("dev", {
  database,
  name: "development",
  parentBranch: "main",
});

// Create credentials
const password = await Password("credentials", {
  database,
  branch: devBranch,
  name: "app-credentials",
});

console.log(`Database URL: ${password.connectionString}`);

await app.finalize();

// Production database
const prod = await Database("prod-db", {
  name: "production",
});

// Create a branch for schema changes
const schemaBranch = await Branch("schema-updates", {
  database: prod,
  name: "add-user-table",
  parentBranch: "main",
});

// After testing, merge via PlanetScale UI or API

import { Database, Password } from "alchemy/planetscale";
import { Worker } from "alchemy/cloudflare";

const database = await Database("db", { name: "my-db" });
const password = await Password("creds", {
  database,
  branch: "main",
});

const worker = await Worker("api", {
  entrypoint: "./src/index.ts",
  bindings: {
    DATABASE_URL: password.connectionString,
  },
});