1 files changed, 13 insertions, 0 deletions
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))
+}