Isolate MediaRouter social DB connections in mediarouter schema

app/social/database.py

@@ -73,7 +73,11 @@ class SocialDatabase:
         self.database_url = normalize_async_database_url(settings.resolved_social_database_url)
         # Supabase/PgBouncer transaction pooling requires asyncpg's prepared
         # statement cache to be disabled to avoid stale statement-name reuse.
-        connect_args = {"statement_cache_size": 0} if self.database_url.startswith(("postgresql", "postgres")) else {}
+        connect_args = (
+            {"statement_cache_size": 0, "server_settings": {"search_path": "mediarouter"}}
+            if self.database_url.startswith(("postgresql", "postgres"))
+            else {}
+        )
         self.engine: AsyncEngine = create_async_engine(
             self.database_url, pool_pre_ping=True, connect_args=connect_args
         )
@@ -86,7 +90,11 @@ class SocialDatabase:
         self.worker_engine: AsyncEngine | None = None
         self.worker_session_factory: async_sessionmaker[AsyncSession] | None = None
         if self.worker_database_url:
-            worker_connect_args = {"statement_cache_size": 0} if self.worker_database_url.startswith(("postgresql", "postgres")) else {}
+            worker_connect_args = (
+                {"statement_cache_size": 0, "server_settings": {"search_path": "mediarouter"}}
+                if self.worker_database_url.startswith(("postgresql", "postgres"))
+                else {}
+            )
             self.worker_engine = create_async_engine(
                 self.worker_database_url, pool_pre_ping=True, connect_args=worker_connect_args
             )