blog-publishing

Coordinate SQL scripts to create and update blog posts with deployment verification.

Updated Nov 9, 2025
One-click install
npx skills add https://github.com/canyouseeus/thelostandunfounds --skill blog-publishing-canyouseeus
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: blog-publishing
Source: https://github.com/canyouseeus/thelostandunfounds/tree/main/.agent/skills/blog-publishing
Command: npx skills add https://github.com/canyouseeus/thelostandunfounds --skill blog-publishing-canyouseeus

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the end-to-end publishing workflow for THE LOST+UNFOUNDS blog by coordinating SQL-based creation and updates to blog posts through a structured deployment process.

Core Features & Use Cases

  • End-to-end publishing workflow (SQL templates, deployment checks, and versioned posts)
  • Enforces Noir styling rules and slug-based content integrity
  • Use Case: When creating or updating a post, trigger the SQL mutations, verify deployment, and publish live.

Quick Start

Create a new blog post by following the six-step SQL workflow and verify deployment.

Frequently Asked Questions about blog-publishing

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate blog publishing with SQL scripts?

The blog publishing workflow enforces Noir styling rules and slug-based content integrity by triggering SQL mutations that validate content structure before deployment, ensuring consistent formatting and reliable audit trails.

What is the workflow for deploying SQL-updated blog posts to production?

Deploying SQL-updated blog posts to production requires a six-step workflow: creating SQL mutations, enforcing slug-based content integrity, verifying Noir styling, checking deployment status, publishing live, and generating audit trails for versioned posts.

Do I need SQL database access to publish content through an automated deployment workflow?

Yes, SQL database access is required to execute the creation and update mutations for blog posts, as the publishing workflow relies on SQL scripts to manage content changes and verify slug-based content integrity before deployment.

Can I use this automated publishing workflow for content outside of Noir-styled posts?

No, this automated publishing workflow is specifically designed for content teams producing Noir-styled posts for THE LOST+UNFOUNDS blog, enforcing Noir styling rules and slug-based content integrity throughout the SQL mutation and deployment process.

What's the best way to ensure content integrity when updating an existing blog post via SQL?

The best way to ensure content integrity when updating a blog post via SQL is to enforce slug-based content validation during the SQL mutation process, verifying that deployment checks pass before the content is published live to production.

Why does my blog publishing workflow require deployment verification after running SQL scripts?

Blog publishing workflows require deployment verification after running SQL scripts to confirm that the database mutations have been successfully applied to production, ensuring the versioned post is live and maintaining a reliable audit trail.