3 files changed, 17 insertions, 0 deletions
diff --git a/packages/console/core/.gitignore b/packages/console/core/.gitignore
new file mode 100644
index 000000000..67b7c8e65
--- /dev/null
+++ b/packages/console/core/.gitignore
@@ -0,0 +1 @@
+script/scrap.ts
diff --git a/packages/console/core/package.json b/packages/console/core/package.json
index 8749c864a..b6748c42a 100644
--- a/packages/console/core/package.json
+++ b/packages/console/core/package.json
@@ -24,6 +24,9 @@
     "db": "sst shell drizzle-kit",
     "db-dev": "sst shell --stage dev -- drizzle-kit",
     "db-prod": "sst shell --stage production -- drizzle-kit",
+    "shell": "sst shell -- bun",
+    "shell-dev": "sst shell --stage dev -- bun",
+    "shell-prod": "sst shell --stage production -- bun",
     "update-models": "script/update-models.ts",
     "promote-models-to-dev": "script/promote-models.ts dev",
     "promote-models-to-prod": "script/promote-models.ts production",
diff --git a/packages/console/core/script/reset-db.ts b/packages/console/core/script/reset-db.ts
new file mode 100644
index 000000000..96ecf14e7
--- /dev/null
+++ b/packages/console/core/script/reset-db.ts
@@ -0,0 +1,13 @@
+import { Resource } from "@opencode-ai/console-resource"
+import { Database } from "@opencode-ai/console-core/drizzle/index.js"
+import { UserTable } from "@opencode-ai/console-core/schema/user.sql.js"
+import { AccountTable } from "@opencode-ai/console-core/schema/account.sql.js"
+import { WorkspaceTable } from "@opencode-ai/console-core/schema/workspace.sql.js"
+import { BillingTable, PaymentTable, UsageTable } from "@opencode-ai/console-core/schema/billing.sql.js"
+import { KeyTable } from "@opencode-ai/console-core/schema/key.sql.js"
+
+if (Resource.App.stage !== "frank") throw new Error("This script is only for frank")
+
+for (const table of [AccountTable, BillingTable, KeyTable, PaymentTable, UsageTable, UserTable, WorkspaceTable]) {
+  await Database.use((tx) => tx.delete(table))
+}