docs: clarify drizzle studio access via proxy URL

docker-compose.yml

@@ -84,7 +84,8 @@ services:
         condition: service_healthy
     networks:
       - internal
-    command: bun run db:studio
+      - web
+    command: [ "bun", "x", "drizzle-kit", "studio", "--port", "4983", "--host", "0.0.0.0" ]
 
 networks:
   internal:

package.json

@@ -16,7 +16,7 @@
     "db:push": "docker compose run --rm app drizzle-kit push",
     "db:push:local": "drizzle-kit push",
     "dev": "bun --watch bot/index.ts",
-    "db:studio": "drizzle-kit studio --host 0.0.0.0",
+    "db:studio": "drizzle-kit studio --port 4983 --host 0.0.0.0",
     "studio:remote": "bash shared/scripts/remote-studio.sh",
     "dashboard:remote": "bash shared/scripts/remote-dashboard.sh",
     "remote": "bash shared/scripts/remote.sh",

shared/scripts/remote-studio.sh

@@ -18,7 +18,11 @@ if [ -z "$VPS_HOST" ] || [ -z "$VPS_USER" ]; then
 fi
 
 echo "🔮 Establishing secure tunnel to Drizzle Studio..."
-echo "📚 Studio will be accessible at: https://local.drizzle.studio"
+echo ""
+echo "📚 Open this URL in your browser:"
+echo "   https://local.drizzle.studio?host=127.0.0.1&port=4983"
+echo ""
+echo "💡 Note: Drizzle Studio works via their proxy service, not direct localhost."
 echo "Press Ctrl+C to stop the connection."
 
 # -N means "Do not execute a remote command". -L is for local port forwarding.