Write Query
作者 anthropicsae1513ea94dc無授權條款27K 個星標收錄於 2026年10月8日更新於 2026年10月8日儲存庫今天更新
Write optimized SQL for your dialect with best practices. Use when translating a natural-language data need into SQL, building a multi-CTE query with joins and aggregations, optimizing a query against a large partitioned table, or getting dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.
僅公開檔案列表。將技能安裝到工作區後即可檢視檔案內容。
| 路徑 | 大小 | 類型 |
|---|---|---|
| SKILL.md | 4.6 KB | text/markdown |
來源與署名
來源：anthropics/knowledge-work-plugins位於data/skills/write-query提交ae1513e
授權條款： 無授權條款
內容歸原作者所有。SourceWeft 從公開儲存庫中收錄這些內容。
更多來自 anthropics/knowledge-work-plugins 的技能
Ticket Deflector
anthropics
Reads a forwarded customer email or ticket, pulls order and refund status from a payments connector (PayPal, Square, or Stripe) or Shopify, account history from the CRM, and open tickets from a support desk (Zoho Desk), drafts a tone-matched reply in the owner's writing voice, and can issue a refund through the payments connector with explicit owner approval. With Shopify connected it also runs a proactive order-triage mode that surfaces orders needing attention — unfulfilled past the promised window, payment problems, pending refunds, stuck shipments — and drafts the next action for each before the customer has to ask. Use when the user says "draft a response," "answer this customer," "where's my order," "I want a refund," "check my orders," or "anything about to blow up."
Tax Season Organizer
anthropics
Prepares tax-season materials for the owner's accountant, not tax advice. US federal tax; a non-US business gets its closed-books packet instead. Two modes: (1) quarterly estimated tax from YTD net income in the ledger (MYOB, NetSuite, QuickBooks, Xero, or Zoho Books); (2) year-end 1099 prep, scanning the ledger, PayPal, and Stripe for contractors paid over USD 600 into a 1099-NEC list with missing W-9 flags. Any tax request routes first to /tax-prep, which confirms the books are closed and reconciled before running this skill. Use this skill directly only when the owner says the period's books are already closed: "books are closed, now do the 1099s," "run the quarterly estimate off the closed numbers," or "just the contractor W-9 list."
Tax Prep
anthropics
根據已結帳的帳目準備稅務資料：季度預估繳稅明細，或年終 1099-NEC 清單與會計師資料包。
Smb Onboard
anthropics
引導小型企業主完成首次設定：連接工具、執行一次展現價值的配方、記錄業務背景並設定每週檢查節奏。
Smb Router
anthropics
將小型企業主的需求轉接到合適的外掛技能或指令，並說明可用功能。
Month End Prep
anthropics
Reconciles the accounting ledger (MYOB, NetSuite, QuickBooks, Xero, or Zoho Books) against PayPal, Shopify, Square, and Stripe settlements, flags transactions that need attention, suspicious duplicates, and missing receipts, then writes a plain-English P&L narrative and exports a close packet (xlsx + one-page PDF). This is the first link of the /close-month command; a request to close the month or the books routes there, and the command runs this skill before refreshing the forecast and distributing the packet. Use this skill directly only when the owner wants the reconciliation alone, with no forecast refresh and no distribution: "just reconcile, no packet," "what's missing from the books," "flag the duplicates and missing receipts," or "write the P&L narrative for this month."
更多Data & Analytics技能
Content Strategy
anthropics
把 PayPal、QuickBooks 或 Square 的銷售資料轉成排序過的 30 天內容簡報。
Cash Flow Snapshot
anthropics
依據帳簿、支付平台或 CSV 資料產出 30/60/90 天現金流預測，含信心區間與具名風險提示。
Pipeline Review
anthropics
依階段檢視 CRM 銷售管道健康狀況，標記老化、停滯與高風險商機並檢查覆蓋率。
Metrics Review
anthropics
檢視產品指標，分析趨勢並與目標對比，產出附建議行動的指標計分卡。
Performance Report
anthropics
產出營銷成效報告，包含關鍵指標、趨勢分析、成功與不足之處，以及依優先順序排列的優化建議。
People Report
anthropics
根據人力資料產出員額編制、流失率、多元性與組織健康度等人才分析報告。