@@ -1,13 +1,38 @@
 NODE_ENV=development
 NEXT_PUBLIC_NODE_ENV=development
 
-NEXT_PUBLIC_SUPABASE_BUCKET_NAME=
-NEXT_PUBLIC_SUPABASE_URL=
-NEXT_PUBLIC_SUPABASE_ANON_KEY=
+# MySQL database
+DATABASE_URL=mysql://user:password@localhost:3306/devpulse
 
+# NextAuth
+NEXTAUTH_SECRET=
+NEXTAUTH_URL=http://localhost:3000
+
+# OAuth providers (optional)
+GOOGLE_CLIENT_ID=
+GOOGLE_CLIENT_SECRET=
+GITHUB_CLIENT_ID=
+GITHUB_CLIENT_SECRET=
+AZURE_AD_CLIENT_ID=
+AZURE_AD_CLIENT_SECRET=
+AZURE_AD_TENANT_ID=
+
+# Email 
+NODE_MAILER_HOST=smtp.gmail.com
+NODE_MAILER_PORT=465
+NODE_MAILER_USER=
+NODE_MAILER_PASS=
+NODE_MAILER_SECURE=true
+
+# Global chat conversation ID (seed with a cuid, e.g. from `npx cuid`)
+GLOBAL_CONVERSATION_ID=
+NEXT_PUBLIC_GLOBAL_CONVERSATION_ID=
+
+# Cron job secret (protects POST /api/cron/cleanup-messages)
+CRON_SECRET=
+
+# hCaptcha
 NEXT_PUBLIC_HCAPTCHA_SITE_KEY=
 
+# Norton Safe Web
 NEXT_PUBLIC_NORTON_SAFEWEB_SITE_VERIFICATION=
-
-SUPABASE_ACCESS_TOKEN=
-SUPABASE_PROJECT_ID=vswabkwgipyweqsabzwv
 
@@ -54,3 +54,5 @@ supabase/*
 
 yarn.lock
 pnpm-lock.yaml
+
+/app/generated/prisma
@@ -1,40 +1,26 @@
-<img src="public/images/devpulse.cover.png" alt="Screenshot of the floating console extension in action" width="600">
-  
+<img src="public/images/devpulse.cover.png" alt="Devpulse" width="600">
+
 # devpulse
 
 Measure and share your coding productivity with personalized leaderboards. Compare your progress with peers while keeping full control over privacy and leaderboard settings with project management features.
 
 ## Getting Started
+
 Install the dependencies:
 
 npm install
-```
-
-## Supabase
 
-First by creating a supabase cloud project:
-
-- go to [Supabase Dashboard](https://app.supabase.com)
-- click `New Project`
-- choose:
-  - Organization → (create one if needed)
-  - Project Name → e.g. devpulse
-  - Database Password → choose a secure one
-  - Region → pick the nearest location
-- Click Create new project
-- Wait a few moments for the database to be provisioned.
+````
 
 ## Setup Environment
 
 Copy the .env.example to .env
 
 ```bash
 cp .env.example .env
+````
 
-# Open .env and fill in the values for:
-# NEXT_PUBLIC_SUPABASE_URL=your_supabase_url
-# NEXT_PUBLIC_SUPABASE_ANON_KEY=your_supabase_anon_key
-```
+and fill in the values for the environment variables.
 
 ## Development
 
@@ -46,80 +32,6 @@ npm run dev
 
 Open [http://localhost:3000](http://localhost:3000) with your browser to see the result.
 
-## Database Migrations
-
-For a brand-new Supabase project, use this flow from the repo root.
-
-This repository now uses a squashed baseline migration for fresh installs:
-
-- Active baseline: `supabase/migrations/20260407120000_baseline_fresh_setup.sql`
-
-- Historical migrations archive: `supabase/migrations_archive/`
-
-1. Login to Supabase CLI:
-
-```bash
-npx supabase login
-```
-
-2. Initialize local Supabase config (only if missing):
-
-```bash
-npx supabase init
-```
-
-3. Link this repo to your cloud project:
-
-```bash
-npx supabase link
-```
-
-You can select from the project list, or run `npx supabase link --project-ref <project-ref>`.
-
-4. Push all migrations to the new project:
-
-```bash
-npx supabase db push
-```
-
-On a fresh project this applies only the single baseline migration.
-
-5. (Optional) Pull remote schema changes into migrations:
-
-```bash
-npx supabase db pull
-```
-
-6. Regenerate Supabase TypeScript types after schema changes:
-
-```bash
-npx supabase gen types typescript --project-id <project-id> --schema public > app/supabase-types.ts
-```
-
-If you want to re-run the full migration chain on local development:
-
-```bash
-npx supabase db reset
-```
-
-If you need to inspect migration history, use the files in `supabase/migrations_archive/`.
-
-
-## Learn More
-
-To learn more about Next.js, take a look at the following resources:
-
-- [Next.js Documentation](https://nextjs.org/docs) - learn about Next.js features and API.
-- [Learn Next.js](https://nextjs.org/learn) - an interactive Next.js tutorial.
-
-You can check out [the Next.js GitHub repository](https://github.com/vercel/next.js) - your feedback and contributions are welcome!
-
-## Deploy on Vercel
-
-The easiest way to deploy this Next.js app is to use the [Vercel Platform](https://vercel.com/new/clone?repository-url=https://github.com/mrepol742/devpulse) from the creators of Next.js.
-
-Check out our [Next.js deployment documentation](https://nextjs.org/docs/app/building-your-application/deploying) for more details.
-
 ## Contribution Guidelines
 
 Contributions to devpulse are welcome! Please follow these guidelines:
@@ -135,4 +47,5 @@ Contributions to devpulse are welcome! Please follow these guidelines:
 Help us keep the codebase ("Devpulse") clean, stable, and maintainable.
 
 ## License
+
 This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.
@@ -44,7 +44,7 @@ export default function ForgotPasswordPage() {
   return (
     <Suspense
       fallback={
-        <div className="min-h-screen flex items-center justify-center bg-[#0a0a1a] text-white">
+        <div className="min-h-screen flex items-center justify-center ">
           Loading...
         </div>
       }
 
@@ -57,7 +57,7 @@ export default async function LoginPage() {
   return (
     <Suspense
       fallback={
-        <div className="min-h-screen flex items-center justify-center bg-[#0a0a1a] text-white">
+        <div className="min-h-screen flex items-center justify-center ">
           Loading...
         </div>
       }
 
@@ -0,0 +1,24 @@
+import { Suspense } from "react";
+import Logout from "@/app/components/auth/Logout";
+import { auth } from "@/app/lib/auth";
+import { redirect } from "next/navigation";
+
+export default async function LogoutPage() {
+  const session = await auth();
+
+  if (!session) {
+    return redirect("/login");
+  }
+
+  return (
+    <Suspense
+      fallback={
+        <div className="min-h-screen flex items-center justify-center">
+          Loading...
+        </div>
+      }
+    >
+      <Logout />
+    </Suspense>
+  );
+}
@@ -47,9 +47,9 @@ export const metadata: Metadata = {
 
 export default async function ResetPassword() {
   return (
-    <div className="min-h-screen flex bg-[#0a0a1a] text-white relative">
+    <div className="min-h-screen flex  relative">
       {/* Left Side - Visual / Branding */}
-      <div className="hidden lg:flex lg:w-1/2 relative flex-col justify-between p-12 md:p-16 xl:p-24 border-r border-white/5 bg-gradient-to-br from-[#0a0a1a] to-[#0a0a1a] overflow-hidden">
+      <div className="hidden lg:flex lg:w-1/2 relative flex-col justify-between p-12 md:p-16 xl:p-24 border-r border-gray-200 bg-blue-600 overflow-hidden">
         {/* Background elements */}
         <div className="absolute inset-0 grid-bg opacity-30" />
 
@@ -59,22 +59,22 @@ export default async function ResetPassword() {
             className="flex items-center gap-3 w-fit hover:opacity-80 transition"
           >
             <Image src="/logo.svg" alt="Devpulse Logo" width={40} height={40} />
-            <span className="text-2xl font-bold tracking-tight text-white">
+            <span className="text-2xl font-bold tracking-tight text-gray-900">
               Devpulse
             </span>
           </Link>
         </div>
 
         <div className="relative z-10 max-w-md">
-          <h1 className="text-4xl font-extrabold mb-5 leading-tight text-transparent bg-clip-text bg-gradient-to-r from-white to-gray-400">
+          <h1 className="text-4xl font-extrabold mb-5 leading-tight text-gray-900">
             Change your password and get back to tracking your coding activity!
           </h1>
-          <p className="text-gray-400 text-lg leading-relaxed mb-8">
+          <p className="text-gray-500 text-lg leading-relaxed mb-8">
             Your Devpulse dashboard is waiting for you. Enter a new password to
             regain access and continue your coding journey.
           </p>
 
-          <div className="glass-card border border-white/5 rounded-2xl p-5 bg-white/5 backdrop-blur-md shadow-2xl">
+          <div className="glass-card border border-gray-200 rounded-2xl p-5 bg-gray-50 backdrop-blur-md shadow-2xl">
             <div className="flex items-center gap-2 mb-4">
               <div className="w-3 h-3 rounded-full bg-red-500/80"></div>
               <div className="w-3 h-3 rounded-full bg-yellow-500/80"></div>
@@ -85,26 +85,26 @@ export default async function ResetPassword() {
             </div>
             <div className="space-y-1.5 font-mono text-sm">
               <div className="flex">
-                <span className="text-purple-400 mr-2">const</span>
-                <span className="text-blue-400">dev</span>
-                <span className="text-gray-200 mx-2">=</span>
-                <span className="text-indigo-400">getAccount</span>
-                <span className="text-gray-200">(</span>
-                <span className="text-yellow-200">this</span>
-                <span className="text-gray-200">);</span>
+                <span className="text-purple-600 mr-2">const</span>
+                <span className="text-blue-600">dev</span>
+                <span className="text-gray-700 mx-2">=</span>
+                <span className="text-indigo-600">getAccount</span>
+                <span className="text-gray-700">(</span>
+                <span className="text-yellow-700">this</span>
+                <span className="text-gray-700">);</span>
               </div>
               <div className="flex mt-2">
-                <span className="text-blue-400">dev</span>
-                <span className="text-gray-200">.</span>
-                <span className="text-yellow-200">setNewPassword</span>
-                <span className="text-gray-200">(</span>
-                <span className="text-gray-200">
+                <span className="text-blue-600">dev</span>
+                <span className="text-gray-700">.</span>
+                <span className="text-yellow-700">setNewPassword</span>
+                <span className="text-gray-700">(</span>
+                <span className="text-gray-700">
                   &quot;your-new-password&quot;
                 </span>
-                <span className="text-gray-200">);</span>
+                <span className="text-gray-700">);</span>
               </div>
               <div className="flex mt-3">
-                <span className="text-emerald-400/80">
+                <span className="text-emerald-600/80">
                   {"// And just like that, you&apos;re back in the game. 🎉"}
                 </span>
               </div>
@@ -127,14 +127,14 @@ export default async function ResetPassword() {
             className="lg:hidden flex items-center justify-center gap-3 mb-10"
           >
             <Image src="/logo.svg" alt="Devpulse Logo" width={40} height={40} />
-            <h2 className="text-3xl font-bold text-white">Devpulse</h2>
+            <h2 className="text-3xl font-bold text-gray-900">Devpulse</h2>
           </Link>
 
           <div className="mb-8 text-left">
-            <h2 className="text-3xl font-bold text-white mb-2">
+            <h2 className="text-3xl font-bold text-gray-900 mb-2">
               Reset your password
             </h2>
-            <p className="text-gray-400">
+            <p className="text-gray-500">
               New password, who dis? Enter a new password to regain access to
               your account and get back to tracking your coding stats!
             </p>
@@ -148,7 +148,7 @@ export default async function ResetPassword() {
             <ResetPasswordForm />
           </Suspense>
 
-          <p className="mt-8 text-center text-sm text-gray-400">
+          <p className="mt-8 text-center text-sm text-gray-500">
             Already have an account?{" "}
             <Link
               href="/login"
Original file line number	Diff line number	Diff line change
`@@ -44,7 +44,7 @@ export default function ForgotPasswordPage() {`
`44`	`44`	`return (`
`45`	`45`	`<Suspense`
`46`	`46`	`fallback={`
`47`		`- <div className="min-h-screen flex items-center justify-center bg-[#0a0a1a] text-white">`
	`47`	`+ <div className="min-h-screen flex items-center justify-center ">`
`48`	`48`	`Loading...`
`49`	`49`	`</div>`
`50`	`50`	`}`
Original file line number	Diff line number	Diff line change
`@@ -57,7 +57,7 @@ export default async function LoginPage() {`
`57`	`57`	`return (`
`58`	`58`	`<Suspense`
`59`	`59`	`fallback={`
`60`		`- <div className="min-h-screen flex items-center justify-center bg-[#0a0a1a] text-white">`
	`60`	`+ <div className="min-h-screen flex items-center justify-center ">`
`61`	`61`	`Loading...`
`62`	`62`	`</div>`
`63`	`63`	`}`