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.
This skill ensures that every blog post is published correctly and adheres to the strict "Noir" aesthetic and styling rules.
sql/create-blog-post-[slug].sql and public/sql/create-blog-post-[slug].sql.
DECLARE existing_post_id UUID; and a check-and-insert/update block.ON CONFLICT (slug).allScripts array in src/pages/SQL.tsx.SQL_FILES in api/sql/latest.ts.mainhttps://www.thelostandunfounds.com/sql/create-blog-post-[slug].sqlhttps://www.thelostandunfounds.com/sqltext-center or text-justify for body content.text-left. Applies to paragraphs, analysis components, and headers.DO $$
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 $$;