Synchronizes TikTok engagement data and readings from ClickHouse to Supabase to keep web content updated.
The TikTok Supabase Data Sync skill automates the critical data pipeline between ClickHouse analytical storage and Supabase operational databases. Specifically designed for platforms like tarotbymarie.com, it ensures that the latest TikTok readings are pushed to the tiktok_posts table while maintaining strict data provenance. By utilizing a service-only access mode via MemoryClient, the skill ensures secure, read-only interactions with ClickHouse, providing a reliable way to bridge backend analytics with frontend-facing content displays.
主な機能
01Service-only access mode for secure database interaction
02Automated ClickHouse to Supabase data migration
03Built-in provenance tracking with UUID run identifiers
04Integration-ready for Langfuse tracing and monitoring
051 GitHub stars
06Scheduled execution for consistent data freshness
ユースケース
01Updating web application content with live TikTok metrics
02Syncing analytical data from ClickHouse to operational Supabase tables
03Automating social media data pipelines for content management
