staticflow-cli-publisher

Publish and verify StaticFlow articles, images, and notes in LanceDB via sf-cli.

2|Updated Jun 18, 2026
One-click install
npx skills add https://github.com/zero-yx/static_flow --skill staticflow-cli-publisher-zero-yx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: staticflow-cli-publisher
Source: https://github.com/zero-yx/static_flow/tree/main/skills/staticflow-cli-publisher
Command: npx skills add https://github.com/zero-yx/static_flow --skill staticflow-cli-publisher-zero-yx

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Publishing Markdown articles, images, and notes into a LanceDB-backed StaticFlow site requires correct metadata, bilingual fields, vectors, and post-write verification; this Skill standardizes that entire publish-and-verify workflow through the sf-cli command line. ## Core Features & Use Cases - Article Publishing: Write single Markdown articles with inferred or explicit metadata (summary, tags, category), bilingual content files, pre-computed vectors, and local image import. - Batch Ingestion: Bulk-import image directories with thumbnails and sync whole notes directories into LanceDB tables. - Verification & Safety Gates: Verify writes through fresh API-equivalent queries, and enforce hard-stop rules that halt publishing on storage-integrity symptoms instead of attempting ad-hoc repair. - Use Case: You have a new bilingual blog post with images. The Skill infers missing metadata, generates summaries in-session, publishes via write-article, then confirms the article, taxonomy rows, and images are readable through sf-cli api. ## Quick Start Publish the Markdown file posts/my-post.md into the LanceDB database at ./data/lancedb, inferring any missing metadata and verifying the result with sf-cli.

Frequently Asked Questions about staticflow-cli-publisher

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

FAQPage Schema
How do I publish a Markdown article to LanceDB with sf-cli?▼

Run sf-cli write-article with --db-path and --file pointing to your Markdown post. If frontmatter is incomplete, pass --summary, --tags, --category, and --category-description explicitly, or let the Skill infer them from content and existing taxonomies.

How do I batch import images into a StaticFlow database?▼

Use sf-cli write-images with --db-path and --dir targeting the image directory, optionally adding --recursive, --generate-thumbnail, and --thumbnail-size. Verify readability afterward with sf-cli api get-image since image data uses blob v2 storage.

Can I publish bilingual articles with English content and Chinese summaries?▼

Yes, pass --content-en-file, --summary-zh-file, and --summary-en-file to write-article, where the two summary files must be provided together. You can also update an existing article later with db update-article-bilingual.

What should I do when write-article fails with Ambiguous merge inserts?▼

Stop retrying and stop mutating the affected tables immediately. Capture diagnostics with audit-storage and list-indexes --with-stats, preserve rollback state, and escalate to a stable-row-id rebuild workflow instead of running delete-rows or optimize as ad-hoc fixes.

When should I not use this publishing skill?▼

Do not use it for live-table repair or corruption recovery; it is a publish-and-verify workflow only. If storage maintenance or table repair is the main task, switch to a dedicated lancedb-optimize or explicit repair workflow.