1. Milestone update
   "Shipped [feature].
    What was hard to build: [technical challenge]
    Value to users: [concrete benefit]"

2. Weekly numbers
   "This week's numbers:
    Users: 247 (+12)
    MRR: $345 (+$21)
    Churned: 2
    Main improvement: [what I fixed]"

3. Sharing a failure
   "What I messed up this week: [specific failure]
    Root cause: [why]
    What I'll do differently: [lesson]
    Sharing this so you don't make the same mistake"

4. Decision-making process
   "Was torn between [option A] and [option B].
    What tipped it: [reason]
    Here's how I think through these decisions"

5. Technical tip (short form)
   "How I solved [problem] in Flutter:
    [3 lines of code or a diagram]
    Full post →"

6. Question / feedback request
   "Redesigning the [feature X] UI.
    Option A vs Option B — which feels more intuitive?
    Real user input matters"

7. Gratitude / community
   "[Follower name]'s feedback led to [improvement].
    Thank you — before/after comparison:"

Mon: last week's numbers (MRR / user count)
Wed: technical tip or failure story
Fri: what shipped this week or WIP screenshot
Sun: next week's goal (accountability post)

// supabase/functions/post-x-update/index.ts
// Review drafts generated by weekly-sns-draft, post approved ones
const { data: draft } = await supabase
  .from('sns_drafts')
  .select('content')
  .eq('platform', 'x')
  .eq('status', 'approved')
  .order('created_at')
  .limit(1)
  .single();

if (draft) {
  await postToX(draft.content);
  await supabase.from('sns_drafts')
    .update({ status: 'posted' })
    .eq('id', draft.id);
}

Core principle  → earn trust through transparency (imperfect is fine)
Post types      → rotate through: numbers / failures / tech / decisions
Frequency       → 4 posts/week is the sustainable ceiling
Automation      → weekly GHA generates draft → manual review → post