Index: backend/scripts/toggleModeratorStatus.js
===================================================================
--- backend/scripts/toggleModeratorStatus.js	(revision ee53e082b292a55aa024c48c3c454e9fa4429179)
+++ backend/scripts/toggleModeratorStatus.js	(revision ee53e082b292a55aa024c48c3c454e9fa4429179)
@@ -0,0 +1,47 @@
+const { createClient } = require('@supabase/supabase-js');
+require('dotenv').config();
+
+// This script toggles the moderator status of a user in the Supabase database.
+// node scripts/toggleModeratorStatus.js USER_ID_HERE
+
+const supabase = createClient(
+  process.env.SUPABASE_URL,
+  process.env.SUPABASE_SERVICE_ROLE_KEY 
+);
+
+async function toggleModeratorStatus(userId) {
+  try {
+    const { data: user, error: fetchError } = await supabase
+      .from('users')
+      .select('isModerator, username')
+      .eq('id', userId)
+      .single();
+    
+    if (fetchError) throw fetchError;
+    if (!user) {
+      console.error(`User with ID ${userId} not found`);
+      return;
+    }
+    
+    const { data: updatedUser, error: updateError } = await supabase
+      .from('users')
+      .update({ isModerator: !user.isModerator })
+      .eq('id', userId)
+      .select('username')
+      .single();
+      
+    if (updateError) throw updateError;
+    
+    console.log(`User ${user.username} moderator status changed to: ${!user.isModerator}`);
+  } catch (error) {
+    console.error('Error:', error);
+  }
+}
+
+const userId = process.argv[2];
+if (!userId) {
+  console.error('Please provide a user ID');
+  process.exit(1);
+}
+
+toggleModeratorStatus(userId);
