Does this skill modify data in ClickHouse?

No, the skill operates in a 'service_only' access mode and is strictly read-only regarding ClickHouse, ensuring your source data remains untouched.

How can I test the sync locally?

You can run the skill locally using the python -m app.services.mcp.jobs command or execute the provided pytest integration tests.

What is the primary purpose of the tbm skill?

The tbm skill (tbm-supabase-sync) is designed to push the latest TikTok readings from a ClickHouse database into a Supabase table to ensure external websites show updated content.

How is the data sync triggered?

The skill is configured with a cron schedule (12 * * * *) to run automatically every hour at the 12-minute mark.

TikTok Supabase Data Sync

Name: TikTok Supabase Data Sync
Author: OrionArchitekton

byOrionArchitekton

•

Database Management

Synchronizes TikTok engagement data and readings from ClickHouse to Supabase to keep web content updated.

About

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.

Key Features

Service-only access mode for secure database interaction
Automated ClickHouse to Supabase data migration
Built-in provenance tracking with UUID run identifiers
Integration-ready for Langfuse tracing and monitoring
1 GitHub stars
Scheduled execution for consistent data freshness

Use Cases

Updating web application content with live TikTok metrics
Syncing analytical data from ClickHouse to operational Supabase tables
Automating social media data pipelines for content management

About

Key Features

Service-only access mode for secure database interaction
Automated ClickHouse to Supabase data migration
Built-in provenance tracking with UUID run identifiers
Integration-ready for Langfuse tracing and monitoring
1 GitHub stars
Scheduled execution for consistent data freshness

Use Cases

Updating web application content with live TikTok metrics
Syncing analytical data from ClickHouse to operational Supabase tables
Automating social media data pipelines for content management