newsletter-events-write

This skill provides an automated workflow for content creators and local media managers to transform raw event data into polished, reader-ready markdown newsletters. By integrating with a local SQLite database that stores scraped data from sources like Instagram, Facebook, and various web aggregators, it streamlines the shift from data collection to final publication. Users can provide natural language instructions to define their formatting preferences, such as specific emoji usage, organizational patterns by date or venue, and custom headers. The tool offloads the technical complexities of database querying and data sanitization to a robust CLI layer, allowing the LLM to focus entirely on the creative task of content curation and stylistic adaptation. It is ideal for individuals or small businesses aiming to build hyper-local event guides without the overhead of manual data entry or complex template maintenance.

• Automatically queries event databases based on configurable date ranges or specific time windows.

• Interprets plain-English user preferences to apply specific styles, themes, and emoji logic to the final output.

• Outputs clean, standard markdown files ready for immediate use in static site generators, email platforms, or social media posts.

• Decouples raw event management from content generation, ensuring consistent data handling and reliable SQLite interactions.

• Gracefully handles missing information like null times or undefined categories to maintain document quality.

• Use this skill when you need to convert a collection of scraped events into a consistent, reader-friendly format without manually typing out details.

• The tool requires that your local environment has the necessary plugin dependencies installed, particularly the CLI components located in the local-media-tools repository.

• Ensure your events are populated via research commands before running this skill to avoid 'no events' errors.

• The tool is designed to work with standard ISO date formats and expects a local SQLite storage architecture.

• Generated newsletters are saved locally with a YYYY-MM-DD timestamp, facilitating easy file management and historical tracking.