القائمة
Database schema and business logic for inventory tracking including products, warehouses, and stock levels.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
Sample skill fixture for classpath registry enhancement tests.
商品文案写作助手。根据商品信息生成吸引人的营销文案。当用户提到"写文案"、"商品描述"、"营销文案"时使用此技能。
选品分析助手。根据市场趋势和用户需求，分析并推荐适合的商品品类。当用户提到"选品"、"商品推荐"、"品类分析"时使用此技能。
Database schema and business logic for sales data analysis including customers, orders, and revenue.
Test skill for groupedTools. When executing this skill, use the record_result tool to record the result value.
Extract text, tables, and form data from PDF documents for analysis and processing. Use when user asks to extract, parse, or analyze PDF files.
| name | inventory_management |
| description | Database schema and business logic for inventory tracking including products, warehouses, and stock levels. |
Available stock: quantity_on_hand from inventory where quantity_on_hand > 0
Products needing reorder: total quantity_on_hand across warehouses <= product's reorder_point
Active products only: Exclude discontinued = true unless analyzing discontinued items
-- Find products below reorder point
SELECT p.product_id, p.product_name, p.reorder_point, SUM(i.quantity_on_hand) as total_stock
FROM products p
JOIN inventory i ON p.product_id = i.product_id
WHERE p.discontinued = false
GROUP BY p.product_id, p.product_name, p.reorder_point
HAVING SUM(i.quantity_on_hand) <= p.reorder_point;