DuffyCoder
- 19 skills
- 0 followers
- 3 hours ago last updated
- ▌ Feishu Sheets · duffycoder bundleFeishu Spreadsheet (电子表格/Sheets) cell-based operations like Excel/Google Sheets: create spreadsheets, manage worksheets (sheet tabs), read/write/append cell ranges using A1 notation. Activate for: 电子表格, spreadsheet, Excel, 工作表, 单元格, 行列, 表格数据, cell, range, row, column, /sheets/ URLs. This is a cell-grid spreadsheet (like Excel), NOT a structured database. Do NOT confuse with feishu-bitable (多维表格) which is record/field based like Airtable.
- ▌ Sophnet Stock · duffycoder bundleAnalyze stocks and cryptocurrencies using Yahoo Finance data. Supports portfolio management, watchlists with alerts, dividend analysis, 8-dimension stock scoring, viral trend detection (Hot Scanner), and rumor/early signal detection. Use for stock analysis, portfolio tracking, earnings reactions, crypto monitoring, trending stocks, or finding rumors before they hit mainstream.
- ▌ Feishu Bitable · duffycoder bundleFeishu Bitable (多维表格) CRUD operations: list/create/update/delete tables, records, fields, and views. Bitable is a structured database-like table with fields (columns with types) and records (rows), similar to Airtable/Notion database. Activate for: 多维表格, bitable, lark base, 数据表, 记录管理, 字段管理, database table, /base/ URLs, /wiki/ URLs with table= parameter. Do NOT confuse with feishu-sheets (电子表格/spreadsheet) which is cell-based like Excel.
- ▌ Social Content · duffycoder bundleCreate and manage social media content for Chinese platforms including WeChat Official Account (微信公众号), Xiaohongshu/RED (小红书), Sohu (搜狐号), and Baijiahao (百家号). Covers topic research (选题搜集), copywriting (文案生成), and cover image generation (配图生成). Integrates with SophNet RAG knowledge base and image generation. Use when user mentions 选题, 文案, 公众号, 小红书, 搜狐号, 百家号, 封面图, 攻略图, 内容策划, or 热点选题.
- ▌ Sophnet Dailynews · duffycoder bundleGenerate a daily, high-signal Markdown news report by scraping a preset source list, filtering and deduplicating items, and writing `NewsReport/YYYY-MM-DD-news-report.md`. Use when the user asks for “daily news”, “tech/news digest”, “today’s links”, “what should I read”, "what happens today", or requests an automated curated report driven by `sources.json` + `cache.json`.
- ▌ Sophnet Image Ocr · duffycoder bundleOCR text and table extraction from images and PDF using SophNet API. Supports local files and URLs; PDFs are converted page-by-page (low resource), results merged, temp images deleted.
- ▌ Sophnet Image Edit · duffycoder bundleUse when a user requests SophNet image editing (image-to-image), including multi-image editing tasks (composition, style transfer, region swap) where all uploaded image paths must be resolved from Media Understanding logs (usually media/inbound/images/*) and passed in order to model Qwen-Image-Edit-2509.
- ▌ Sophnet Face Search · duffycoder bundleSearch for similar faces in image directories using face detection and embedding comparison. Use when users want to find photos containing a specific person, search for similar faces across image collections, or identify matching faces in photo libraries. Supports automatic path extraction from logs (patterns like "Resolved relative path") and configurable similarity thresholds.
- ▌ Sophnet Image Generate · duffycoder bundleUse when a user requests Sophnet text-to-image generation, needs model selection across Z-Image-Turbo/Qwen-Image/Qwen-Image-Plus, or reports polling/output issues such as missing IMAGE_URL or PREVIEW_PATH.
- ▌ Sophnet Skill Installer · duffycoder bundleUse when a user asks to list or install Sophnet skills. First install from DuffyCoder/awesome-sophnet-skills, and if a skill is not found there, install from another GitHub repo/path.
- ▌ Sophnet PPTX · duffycoder bundleFor create/edit tasks, final reply must include a download URL and must not include local file paths (brief summary text is allowed). Use this skill any time a .pptx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates, layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx filename, regardless of what they plan to do with the content afterward. If a .pptx file needs to be opened, created, or touched, use this skill.
- ▌ Sophnet XLSX · duffycoder bundleUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
- ▌ Feishu Doc · duffycoder bundleFeishu document CONTENT read/write (读写文档内容). Only for reading, writing, and editing document text and blocks. Activate for: 读取文档, 写入文档, 编辑文档内容, 文档块, 云文档, read document, write document, edit content, append content, /docx/ URLs. For /wiki/ URLs: if user clearly mentions document/文档, you can use the wiki token directly as doc_token. Do NOT use for file-level operations (move/delete → feishu-drive), sharing (→ feishu-perm), or spreadsheets/bitables (→ feishu-sheets/feishu-bitable).
- ▌ Feishu Perm · duffycoderFeishu permission and sharing management (权限与分享). Activate when user wants to: 分享文件, 分享文档, 添加协作者, 移除协作者, 查看权限, share document, share file, add collaborator, remove collaborator, manage permissions, grant access, revoke access, 权限管理, 共享, 协作. This is the ONLY tool for sharing and permission operations.
- ▌ Feishu Wiki · duffycoderFeishu knowledge base (知识库) navigation and wiki node type resolver. Activate when: user mentions 知识库/知识空间/wiki, user provides a feishu.cn/wiki/ URL and you DON'T know the file type, or you need to list/create/move/rename wiki nodes. Key fact: wiki tokens can be passed directly to feishu_doc/feishu-sheets/feishu-bitable APIs without resolving first, BUT you must know the file type to pick the right skill.
- ▌ Sophnet Key · duffycoder bundleConfigure and manage SophNet API Key. Automatically reads from Moltbot config or guides users through setup. Use when SOPH_API_KEY environment variable is missing or when helping users configure their SophNet API credentials.
- ▌ Sophnet PDF · duffycoder bundleUse this skill for ALL PDF tasks — creating new PDFs from scratch (reports, whitepapers, invoices, certificates, resumes, charts, presentations), generating complex styled PDF documents with tables/charts/images/multi-page layouts, as well as reading/extracting text and tables, merging/splitting, rotating pages, adding watermarks, filling forms, encrypting/decrypting, extracting images, and OCR. This skill provides a managed Python environment (uv + reportlab/pypdf/pdfplumber) that handles dependencies automatically. Always use this skill whenever the user mentions PDF, .pdf, or asks to create, generate, produce, design, or build any PDF document. Do NOT write standalone Python scripts outside this skill — use the skill's uv environment instead. CRITICAL CJK RULE: When creating PDFs with Chinese/Japanese/Korean text via reportlab, you MUST register STSong-Light font AND call addMapping() — default Helvetica renders CJK as black boxes. See the 'reportlab - Create PDFs' section in this SKILL.md for the mandator
- ▌ Feishu Drive · duffycoderFeishu file-level management (文件管理): move, delete, copy, list files/folders, get file metadata. Activate for ANY file-level operation regardless of file type: 移动文件, 删除文件, 复制文件, 文件夹, 文件列表, 文件信息, move file, delete file, copy file, list files, create folder, 云空间, drive. This is the correct tool when user wants to move/delete/organize ANY Feishu file (documents, spreadsheets, bitables, etc). Do NOT use for reading/editing file content (use feishu-doc, feishu-sheets, or feishu-bitable instead).
- ▌ Sophnet DOCX · duffycoder bundleUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files). Triggers include: any mention of "Word doc", "word document", ".docx", or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a "report", "memo", "letter", "template", or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation.