1 files changed, 15 insertions, 0 deletions
diff --git a/apps/web/src/lib/waitlist.ts b/apps/web/src/lib/waitlist.ts
new file mode 100644
index 00000000..c397109d
--- /dev/null
+++ b/apps/web/src/lib/waitlist.ts
@@ -0,0 +1,15 @@
+import { db } from "@/lib/db";
+import { waitlist } from "@/lib/db/schema";
+import { sql } from "drizzle-orm";
+
+export async function getWaitlistCount() {
+  try {
+    const result = await db
+      .select({ count: sql<number>`count(*)` })
+      .from(waitlist);
+    return result[0]?.count || 0;
+  } catch (error) {
+    console.error("Failed to fetch waitlist count:", error);
+    return 0;
+  }
+}