social-media-platform

name	social-media-platform
description	Build a plugin-based social media management platform with multi-platform publishing, content calendar, brand voices, AI content generation via LangGraph, and analytics. Use when building social media tools, content scheduling systems, or multi-platform publishing pipelines. Covers Facebook, Instagram, YouTube, Twitter/X, TikTok integration patterns.

Social Media Platform Builder

Build a complete social media management system with plugin architecture, AI-powered content generation, and multi-platform publishing.

Architecture

┌─────────────────────────────────────┐
│         Frontend (5 pages)          │
│  Dashboard│Compose│Calendar│Analytics│Settings│
├─────────────────────────────────────┤
│         API Layer (FastAPI)         │
│  Posts CRUD│Publishing│Calendar│AI  │
├─────────────────────────────────────┤
│      Plugin Registry (per-platform) │
│  Twitter│Instagram│YouTube│FB│TikTok│Manual│
├─────────────────────────────────────┤
│    LangGraph Content Pipeline       │
│  Voice→Research→Draft→Optimize→Save │
├─────────────────────────────────────┤
│         Supabase (6 tables)         │
└─────────────────────────────────────┘

Step 1: Supabase Tables

Create 6 tables:

• social_posts — id, platform, content, status (draft/scheduled/published/failed), media_urls, published_at, post_url, engagement_metrics (JSONB)
• platform_connections — id, platform, account_name, credentials (JSONB), status, scopes
• content_calendar — id, post_id (FK), scheduled_for, platform, status
• brand_voices — id, name, description, tone, example_phrases (JSONB array), is_default
• social_analytics — id, post_id (FK), platform, impressions, clicks, likes, shares, comments, fetched_at
• publish_queue — id, post_id (FK), platform, status, retry_count, error_message

Seed 3-5 brand voices. Example voices: