---

name: blog-publishing description: Handles the end-to-end workflow for publishing blog posts on THE LOST+UNFOUNDS. Use this when creating new posts or updating existing ones via SQL scripts.

Blog Publishing & Styling Skill

This skill ensures that every blog post is published correctly and adheres to the strict "Noir" aesthetic and styling rules.

Part 1: The 6-Step Publishing Workflow

1. Create SQL File: Create sql/create-blog-post-[slug].sql and public/sql/create-blog-post-[slug].sql.
   • Pattern: Must use DECLARE existing_post_id UUID; and a check-and-insert/update block.
   • Critical: Never use ON CONFLICT (slug).
2. Update SQL.tsx: Add fetch code and register in the allScripts array in src/pages/SQL.tsx.
3. Update API Endpoint: Add the new SQL file path to SQL_FILES in api/sql/latest.ts.
4. Commit Changes: Stage and commit with a descriptive message.
5. Merge to Production: Checkout main, pull, merge the branch, and push.
6. Verify Deployment:
   • URL: https://www.thelostandunfounds.com/sql/create-blog-post-[slug].sql
   • Page: https://www.thelostandunfounds.com/sql

Part 2: Content Styling & Formatting

1. Text Alignment (Critical)

• NEVER use text-center or text-justify for body content.
• ALWAYS use text-left. Applies to paragraphs, analysis components, and headers.

2. Book Title Formatting

• Bolding: All book titles must be bold.
• Case Preservation: Titles must preserve the author's original case.
• Linking: Max 2 links per book. Linked titles must be underlined.

3. Disclosure & Special Characters

• Disclosure: Author names must be UPPERCASE BOLD. Disclosure text can be justified.
• Remove "⸻": Do not use the long dash character. Use proper paragraph spacing.

SQL Template Pattern

CopyDO $$
DECLARE
    existing_post_id UUID;
BEGIN
    SELECT id INTO existing_post_id FROM blog_posts WHERE slug = '[slug]' LIMIT 1;
    IF existing_post_id IS NOT NULL THEN
        UPDATE blog_posts SET ... WHERE id = existing_post_id;
    ELSE
        INSERT INTO blog_posts (...) VALUES (...);
    END IF;
END $$;