![\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260212143319-698de4af0efae.png\")
<\/p>\n\u672c\u6587langchain\u7248\u672c\u4e3a1.2.9<\/p>\n
\u5728 \u6280\u80fd（Skills）\u67b6\u6784 \u4e2d，\u7279\u5b9a\u80fd\u529b\u88ab\u5c01\u88c5\u4e3a\u53ef\u8c03\u7528\u7684\u201c\u6280\u80fd\u201d，\u7528\u4e8e\u589e\u5f3a \u667a\u80fd\u4f53（agent） \u7684\u884c\u4e3a\u3002\u8fd9\u4e9b\u6280\u80fd\u672c\u8d28\u4e0a\u662f\u7531\u4e13\u7528\u63d0\u793a\u8bcd（prompt）\u9a71\u52a8\u7684\u4e13\u9879\u80fd\u529b，\u667a\u80fd\u4f53\u53ef\u6839\u636e\u9700\u8981\u968f\u65f6\u8c03\u7528\u3002<\/p>\n
\u5982\u9700\u5185\u7f6e\u6280\u80fd\u652f\u6301，\u8bf7\u53c2\u9605 \u6df1\u5ea6\u667a\u80fd\u4f53（Deep Agents）\u3002<\/p>\n
💡 \u8fd9\u4e00\u6a21\u5f0f\u5728\u6982\u5ff5\u4e0a\u4e0e Agent Skills \u548c Jeremy Howard \u63d0\u51fa\u7684 llms.txt \u9ad8\u5ea6\u4e00\u81f4\u2014\u2014\u540e\u8005\u901a\u8fc7\u5de5\u5177\u8c03\u7528（tool calling）\u5b9e\u73b0\u6587\u6863\u7684\u6e10\u8fdb\u5f0f\u62ab\u9732（progressive disclosure）\u3002\u800c\u6280\u80fd\u6a21\u5f0f\u5219\u5c06\u8fd9\u79cd\u201c\u6e10\u8fdb\u5f0f\u62ab\u9732\u201d\u5e94\u7528\u4e8e\u4e13\u7528\u63d0\u793a\u8bcd\u548c\u9886\u57df\u77e5\u8bc6，\u800c\u4e0d\u4ec5\u9650\u4e8e\u6587\u6863\u9875\u9762\u3002<\/p>\n
<\/p>\n
\u5f53\u60a8\u5e0c\u671b\u6784\u5efa\u4e00\u4e2a\u5177\u5907\u591a\u79cd\u4e13\u9879\u80fd\u529b\u7684\u5355\u4e00 \u667a\u80fd\u4f53，\u4e14\u6ee1\u8db3\u4ee5\u4e0b\u4efb\u4e00\u6761\u4ef6\u65f6，\u63a8\u8350\u4f7f\u7528\u6280\u80fd\u6a21\u5f0f：<\/p>\n
\u5178\u578b\u5e94\u7528\u573a\u666f\u5305\u62ec：<\/p>\n
from<\/span> langchain.<\/span>tools import<\/span> tool @tool<\/span> \u53ef\u7528\u6280\u80fd\u5305\u62ec： \u8fd4\u56de\u8be5\u6280\u80fd\u5bf9\u5e94\u7684\u63d0\u793a\u8bcd\u53ca\u4e0a\u4e0b\u6587\u4fe1\u606f\u3002 agent =<\/span> create_agent(<\/span> \u5728\u81ea\u5b9a\u4e49\u5b9e\u73b0\u4e2d，\u60a8\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u65b9\u5f0f\u5bf9\u57fa\u7840\u6280\u80fd\u6a21\u5f0f\u8fdb\u884c\u589e\u5f3a：<\/p>\n \u5f53\u76f8\u5173\u8d44\u4ea7\u53d8\u5f97\u5fc5\u8981\u65f6，\u667a\u80fd\u4f53\u4f1a\u610f\u8bc6\u5230\u5b83\u4eec\u7684\u5b58\u5728，\u5e76\u6309\u9700\u5c06\u5176\u8bfb\u5165\u5185\u5b58\u4ee5\u5b8c\u6210\u4efb\u52a1\u3002\u8fd9\u4e5f\u9075\u5faa\u4e86\u6e10\u8fdb\u5f0f\u62ab\u9732\u539f\u5219，\u6709\u6548\u63a7\u5236\u4e0a\u4e0b\u6587\u7a97\u53e3\u4e2d\u7684\u4fe1\u606f\u91cf\u3002<\/p>\n \u672c\u6559\u7a0b\u5c06\u6f14\u793a\u5982\u4f55\u4f7f\u7528 \u6e10\u8fdb\u5f0f\u62ab\u9732（progressive disclosure） \u2014\u2014\u4e00\u79cd\u4e0a\u4e0b\u6587\u7ba1\u7406\u6280\u672f，\u8ba9\u667a\u80fd\u4f53\u4ec5\u5728\u9700\u8981\u65f6\u624d\u52a0\u8f7d\u4fe1\u606f，\u800c\u975e\u4e00\u6b21\u6027\u5168\u90e8\u8f7d\u5165\u2014\u2014\u6765\u5b9e\u73b0 \u6280\u80fd（skills）（\u5373\u57fa\u4e8e\u4e13\u7528\u63d0\u793a\u8bcd\u7684\u4e13\u9879\u6307\u4ee4）\u3002\u667a\u80fd\u4f53\u901a\u8fc7\u5de5\u5177\u8c03\u7528（tool calls）\u6765\u52a0\u8f7d\u6280\u80fd，\u800c\u4e0d\u662f\u52a8\u6001\u4fee\u6539\u7cfb\u7edf\u63d0\u793a\u8bcd（system prompt），\u4ece\u800c\u53ea\u4e3a\u5f53\u524d\u4efb\u52a1\u53d1\u73b0\u5e76\u52a0\u8f7d\u6240\u9700\u7684\u6280\u80fd\u3002<\/p>\n 📝 \u82e5\u60f3\u4e86\u89e3\u4e00\u4e2a\u529f\u80fd\u66f4\u5b8c\u6574\u7684 SQL \u667a\u80fd\u4f53（\u5305\u542b\u67e5\u8be2\u6267\u884c\u3001\u9519\u8bef\u4fee\u6b63\u548c\u9a8c\u8bc1），\u8bf7\u53c2\u9605\u5b98\u7f51\u7684 SQL \u667a\u80fd\u4f53\u6559\u7a0b\u3002\u672c\u6559\u7a0b\u805a\u7126\u4e8e \u6e10\u8fdb\u5f0f\u62ab\u9732\u6a21\u5f0f，\u8be5\u6a21\u5f0f\u53ef\u5e94\u7528\u4e8e\u4efb\u4f55\u9886\u57df\u3002<\/p>\n 💡 \u6e10\u8fdb\u5f0f\u62ab\u9732\u7531 Anthropic \u63a8\u5e7f，\u4f5c\u4e3a\u6784\u5efa\u53ef\u6269\u5c55\u667a\u80fd\u4f53\u6280\u80fd\u7cfb\u7edf\u7684\u4e00\u79cd\u6280\u672f\u3002\u8be5\u65b9\u6cd5\u91c7\u7528\u4e09\u5c42\u67b6\u6784（\u5143\u6570\u636e \u2192 \u6838\u5fc3\u5185\u5bb9 \u2192 \u8be6\u7ec6\u8d44\u6e90），\u667a\u80fd\u4f53\u4ec5\u5728\u9700\u8981\u65f6\u624d\u52a0\u8f7d\u4fe1\u606f\u3002\u66f4\u591a\u8be6\u60c5，\u8bf7\u53c2\u9605 \u300a\u4e3a\u73b0\u5b9e\u4e16\u754c\u8d4b\u80fd\u667a\u80fd\u4f53：Agent Skills\u300b\u3002<\/p>\n \u5f53\u7528\u6237\u8bf7\u6c42\u751f\u6210 SQL \u67e5\u8be2\u65f6，\u6d41\u7a0b\u5982\u4e0b：<\/p>\n \u6280\u80fd\u6982\u5ff5\u7531 Claude Code \u63a8\u5e7f，\u672c\u8d28\u4e0a\u662f\u57fa\u4e8e\u63d0\u793a\u8bcd\u7684：\u5373\u9488\u5bf9\u7279\u5b9a\u4e1a\u52a1\u4efb\u52a1\u7684\u81ea\u5305\u542b\u4e13\u7528\u6307\u4ee4\u5355\u5143\u3002\u5728 Claude Code \u4e2d，\u6280\u80fd\u4ee5\u6587\u4ef6\u7cfb\u7edf\u4e2d\u7684\u76ee\u5f55\u5f62\u5f0f\u5b58\u5728，\u901a\u8fc7\u6587\u4ef6\u64cd\u4f5c\u88ab\u53d1\u73b0\u3002\u6280\u80fd\u901a\u8fc7\u63d0\u793a\u8bcd\u5f15\u5bfc\u884c\u4e3a，\u5e76\u53ef\u63d0\u4f9b\u5de5\u5177\u4f7f\u7528\u8bf4\u660e，\u6216\u5305\u542b\u4f9b\u7f16\u7801\u667a\u80fd\u4f53\u6267\u884c\u7684\u793a\u4f8b\u4ee3\u7801\u3002<\/p>\n 💡 \u5e26\u6709\u6e10\u8fdb\u5f0f\u62ab\u9732\u7684\u6280\u80fd\u53ef\u89c6\u4e3a\u4e00\u79cd RAG（\u68c0\u7d22\u589e\u5f3a\u751f\u6210） \u5f62\u5f0f，\u5176\u4e2d\u6bcf\u9879\u6280\u80fd\u90fd\u662f\u4e00\u4e2a\u68c0\u7d22\u5355\u5143\u2014\u2014\u5c3d\u7ba1\u4e0d\u4e00\u5b9a\u4f9d\u8d56\u5d4c\u5165（embeddings）\u6216\u5173\u952e\u8bcd\u641c\u7d22，\u800c\u662f\u901a\u8fc7\u6d4f\u89c8\u5185\u5bb9\u7684\u5de5\u5177（\u5982\u6587\u4ef6\u64cd\u4f5c，\u6216\u672c\u6559\u7a0b\u4e2d\u7684\u76f4\u63a5\u67e5\u627e）\u6765\u5b9e\u73b0\u3002<\/p>\n 💡 \u6784\u5efa\u60a8\u81ea\u5df1\u7684\u6280\u80fd\u7cfb\u7edf \u5728\u81ea\u884c\u5b9e\u73b0\u6280\u80fd\u7cfb\u7edf\u65f6（\u5982\u672c\u6559\u7a0b\u6240\u793a），\u6838\u5fc3\u7406\u5ff5\u662f\u6e10\u8fdb\u5f0f\u62ab\u9732\u2014\u2014\u6309\u9700\u52a0\u8f7d\u4fe1\u606f\u3002\u5728\u6b64\u57fa\u7840\u4e0a，\u60a8\u62e5\u6709\u5b8c\u5168\u7684\u5b9e\u73b0\u7075\u6d3b\u6027：<\/p>\n \u672c\u6559\u7a0b\u9700\u8981 langchain \u5305：<\/p>\n pip install langchain<\/p>\n \u6216\u7528uv<\/p>\n uv add langchain<\/p>\n \u6216\u7528conda<\/p>\n conda install langchain -c conda-forge<\/p>\n \u66f4\u591a\u8be6\u60c5，\u8bf7\u53c2\u9605\u5b98\u7f51\u7684 \u5b89\u88c5\u6307\u5357\u3002<\/p>\n \u8bbe\u7f6e LangSmith \u4ee5\u68c0\u67e5\u667a\u80fd\u4f53\u5185\u90e8\u8fd0\u884c\u60c5\u51b5\u3002\u7136\u540e\u8bbe\u7f6e\u4ee5\u4e0b\u73af\u5883\u53d8\u91cf：<\/p>\n import<\/span> getpass os.<\/span>environ[<\/span>"LANGSMITH_TRACING"<\/span>]<\/span> =<\/span> "true"<\/span> \u4ece LangChain \u652f\u6301\u7684\u6a21\u578b\u4e2d\u9009\u62e9\u4e00\u4e2a\u804a\u5929\u6a21\u578b：<\/p>\n # pip install -U "langchain[openai]"<\/span> os.<\/span>environ[<\/span>"OPENAI_API_KEY"<\/span>]<\/span> =<\/span> "sk-…"<\/span><\/p>\n model =<\/span> ChatOpenAI(<\/span>model=<\/span>"gpt-4.1"<\/span>)<\/span><\/p>\n \u9996\u5148，\u5b9a\u4e49\u6280\u80fd\u7684\u7ed3\u6784\u3002\u6bcf\u9879\u6280\u80fd\u5305\u542b\u540d\u79f0\u3001\u7b80\u77ed\u63cf\u8ff0（\u663e\u793a\u5728\u7cfb\u7edf\u63d0\u793a\u8bcd\u4e2d）\u548c\u5b8c\u6574\u5185\u5bb9（\u6309\u9700\u52a0\u8f7d）：<\/p>\n from<\/span> typing import<\/span> TypedDict<\/p>\n class<\/span> Skill<\/span>(<\/span>TypedDict)<\/span>:<\/span> # [!code highlight]<\/span> \u73b0\u5728\u4e3a SQL \u67e5\u8be2\u52a9\u624b\u5b9a\u4e49\u793a\u4f8b\u6280\u80fd\u3002\u8fd9\u4e9b\u6280\u80fd\u8bbe\u8ba1\u4e3a：\u63cf\u8ff0\u8f7b\u91cf（\u63d0\u524d\u5c55\u793a\u7ed9\u667a\u80fd\u4f53），\u4f46\u5185\u5bb9\u8be6\u5c3d（\u4ec5\u5728\u9700\u8981\u65f6\u52a0\u8f7d）：<\/p>\n SKILLS:<\/span> list<\/span>[<\/span>Skill]<\/span> =<\/span> [<\/span> ## \u8868\u7ed3\u6784<\/p>\n ### customers（\u5ba2\u6237\u8868） ### orders（\u8ba2\u5355\u8868） ### order_items（\u8ba2\u5355\u660e\u7ec6\u8868） ## \u4e1a\u52a1\u903b\u8f91<\/p>\n **\u6d3b\u8dc3\u5ba2\u6237**：status = 'active' \u4e14 signup_date <= \u5f53\u524d\u65e5\u671f – 90\u5929<\/p>\n **\u6536\u5165\u8ba1\u7b97**：\u4ec5\u7edf\u8ba1 status = 'completed' \u7684\u8ba2\u5355\u3002orders \u8868\u4e2d\u7684 total_amount \u5b57\u6bb5\u5df2\u5305\u542b\u6298\u6263\u540e\u7684\u91d1\u989d\u3002<\/p>\n **\u5ba2\u6237\u751f\u547d\u5468\u671f\u4ef7\u503c（CLV）**：\u67d0\u5ba2\u6237\u6240\u6709\u5df2\u5b8c\u6210\u8ba2\u5355\u91d1\u989d\u7684\u603b\u548c\u3002<\/p>\n **\u9ad8\u4ef7\u503c\u8ba2\u5355**：total_amount > 1000 \u7684\u8ba2\u5355<\/p>\n ## \u793a\u4f8b\u67e5\u8be2<\/p>\n — \u83b7\u53d6\u6700\u8fd1\u4e00\u4e2a\u5b63\u5ea6\u6536\u5165\u6392\u540d\u524d10\u7684\u5ba2\u6237 ## \u8868\u7ed3\u6784<\/p>\n ### products（\u4ea7\u54c1\u8868） ### warehouses（\u4ed3\u5e93\u8868） ### inventory（\u5e93\u5b58\u8868） ### stock_movements（\u5e93\u5b58\u53d8\u52a8\u8bb0\u5f55\u8868） ## \u4e1a\u52a1\u903b\u8f91<\/p>\n **\u53ef\u7528\u5e93\u5b58**：inventory \u8868\u4e2d quantity_on_hand > 0 \u7684\u8bb0\u5f55<\/p>\n **\u9700\u8981\u8865\u8d27\u7684\u4ea7\u54c1**：\u6240\u6709\u4ed3\u5e93\u4e2d\u8be5\u4ea7\u54c1\u7684\u603b\u5e93\u5b58\u91cf \u2264 \u8be5\u4ea7\u54c1\u7684 reorder_point<\/p>\n **\u4ec5\u8003\u8651\u5728\u552e\u4ea7\u54c1**：\u9664\u975e\u7279\u522b\u5206\u6790\u505c\u4ea7\u5546\u54c1，\u5426\u5219\u5e94\u6392\u9664 discontinued = true \u7684\u4ea7\u54c1<\/p>\n **\u5e93\u5b58\u4f30\u503c**：\u6bcf\u4e2a\u4ea7\u54c1\u7684 quantity_on_hand \u00d7 unit_cost<\/p>\n ## \u793a\u4f8b\u67e5\u8be2<\/p>\n — \u67e5\u627e\u6240\u6709\u4ed3\u5e93\u4e2d\u5e93\u5b58\u4f4e\u4e8e\u518d\u8ba2\u8d27\u70b9\u7684\u4ea7\u54c1 \u521b\u5efa\u4e00\u4e2a\u5de5\u5177，\u7528\u4e8e\u6309\u9700\u52a0\u8f7d\u5b8c\u6574\u6280\u80fd\u5185\u5bb9：<\/p>\n from<\/span> langchain.<\/span>tools import<\/span> tool<\/p>\n @tool<\/span> # [!code highlight]<\/span> \u5f53\u60a8\u9700\u8981\u8be6\u7ec6\u4e86\u89e3\u5982\u4f55\u5904\u7406\u67d0\u7c7b\u8bf7\u6c42\u65f6，\u8bf7\u4f7f\u7528\u6b64\u5de5\u5177\u3002 \u53c2\u6570: # \u6280\u80fd\u672a\u627e\u5230<\/span> load_skill \u5de5\u5177\u4ee5\u5b57\u7b26\u4e32\u5f62\u5f0f\u8fd4\u56de\u5b8c\u6574\u6280\u80fd\u5185\u5bb9，\u8be5\u5185\u5bb9\u4f1a\u4f5c\u4e3a ToolMessage \u52a0\u5165\u5bf9\u8bdd\u3002\u6709\u5173\u521b\u5efa\u548c\u4f7f\u7528\u5de5\u5177\u7684\u66f4\u591a\u8be6\u60c5，\u8bf7\u53c2\u9605\u5b98\u7f51 \u5de5\u5177\u6307\u5357\u3002<\/p>\n \u521b\u5efa\u81ea\u5b9a\u4e49\u4e2d\u95f4\u4ef6（middleware），\u5c06\u6280\u80fd\u63cf\u8ff0\u6ce8\u5165\u7cfb\u7edf\u63d0\u793a\u8bcd\u3002\u8be5\u4e2d\u95f4\u4ef6\u4f7f\u6280\u80fd\u53ef\u88ab\u53d1\u73b0，\u800c\u65e0\u9700\u63d0\u524d\u52a0\u8f7d\u5176\u5b8c\u6574\u5185\u5bb9\u3002<\/p>\n 📝 \u672c\u6307\u5357\u6f14\u793a\u4e86\u5982\u4f55\u521b\u5efa\u81ea\u5b9a\u4e49\u4e2d\u95f4\u4ef6\u3002\u5982\u9700\u5168\u9762\u4e86\u89e3\u4e2d\u95f4\u4ef6\u7684\u6982\u5ff5\u4e0e\u6a21\u5f0f，\u8bf7\u53c2\u9605\u5b98\u7f51 \u81ea\u5b9a\u4e49\u4e2d\u95f4\u4ef6\u6587\u6863\u3002<\/p>\n from<\/span> langchain.<\/span>agents.<\/span>middleware import<\/span> ModelRequest,<\/span> ModelResponse,<\/span> AgentMiddleware class<\/span> SkillMiddleware<\/span>(<\/span>AgentMiddleware)<\/span>:<\/span> # [!code highlight]<\/span> # \u5c06 load_skill \u5de5\u5177\u6ce8\u518c\u4e3a\u7c7b\u53d8\u91cf<\/span> def<\/span> __init__<\/span>(<\/span>self)<\/span>
\nfrom<\/span> langchain.<\/span>agents import<\/span> create_agent<\/p>\n
\ndef<\/span> load_skill<\/span>(<\/span>skill_name:<\/span> str<\/span>)<\/span> –<\/span>><\/span> str<\/span>:<\/span>
\n """\u52a0\u8f7d\u4e00\u4e2a\u4e13\u7528\u6280\u80fd\u7684\u63d0\u793a\u8bcd\u3002<\/p>\n
\n – write_sql：SQL \u67e5\u8be2\u7f16\u5199\u4e13\u5bb6
\n – review_legal_doc：\u6cd5\u5f8b\u6587\u6863\u5ba1\u9605\u5458<\/p>\n
\n """<\/span>
\n # \u4ece\u6587\u4ef6\u6216\u6570\u636e\u5e93\u4e2d\u52a0\u8f7d\u6280\u80fd\u5185\u5bb9<\/span>
\n .<\/span>.<\/span>.<\/span><\/p>\n
\n model=<\/span>"gpt-4.1"<\/span>,<\/span>
\n tools=<\/span>[<\/span>load_skill]<\/span>,<\/span>
\n system_prompt=<\/span>(<\/span>
\n "\u4f60\u662f\u4e00\u4e2a\u4e50\u4e8e\u52a9\u4eba\u7684\u52a9\u624b\u3002"<\/span>
\n "\u4f60\u62e5\u6709\u4e24\u9879\u6280\u80fd：write_sql \u548c review_legal_doc\u3002"<\/span>
\n "\u8bf7\u901a\u8fc7 load_skill \u5de5\u5177\u6765\u8c03\u7528\u5b83\u4eec\u3002"<\/span>
\n )<\/span>,<\/span>
\n)<\/span><\/p>\n\u6a21\u5f0f\u7684\u6269\u5c55\u65b9\u5f0f<\/h3>\n
\n
\u6784\u5efa\u4e00\u4e2a\u652f\u6301\u6309\u9700\u52a0\u8f7d\u6280\u80fd\u7684 SQL \u52a9\u624b<\/h3>\n
\u5de5\u4f5c\u539f\u7406<\/h4>\n
![\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/02\/20260212143319-698de4afa83f0.png\")
<\/p>\n\u4e3a\u4f55\u91c7\u7528\u6e10\u8fdb\u5f0f\u62ab\u9732：<\/h5>\n
\n
\u4ec0\u4e48\u662f\u6280\u80fd（Skills）：<\/h5>\n
\u6743\u8861\u53d6\u820d：<\/h5>\n
\n
\n
\u73af\u5883\u51c6\u5907<\/h4>\n
\u5b89\u88c5<\/h5>\n
LangSmith<\/h5>\n
\nimport<\/span> os<\/p>\n
\nos.<\/span>environ[<\/span>"LANGSMITH_API_KEY"<\/span>]<\/span> =<\/span> getpass.<\/span>getpass(<\/span>)<\/span><\/p>\n\u9009\u62e9 LLM<\/h5>\n
\nimport<\/span> os
\nfrom<\/span> langchain_openai import<\/span> ChatOpenAI<\/p>\n1. \u5b9a\u4e49\u6280\u80fd<\/h6>\n
\n """\u53ef\u5411\u667a\u80fd\u4f53\u6e10\u8fdb\u5f0f\u62ab\u9732\u7684\u6280\u80fd\u3002"""<\/span>
\n name:<\/span> str<\/span> # \u6280\u80fd\u7684\u552f\u4e00\u6807\u8bc6\u7b26<\/span>
\n description:<\/span> str<\/span> # 1\u20132 \u53e5\u63cf\u8ff0，\u7528\u4e8e\u7cfb\u7edf\u63d0\u793a\u8bcd<\/span>
\n content:<\/span> str<\/span> # \u5305\u542b\u8be6\u7ec6\u6307\u4ee4\u7684\u5b8c\u6574\u6280\u80fd\u5185\u5bb9<\/span><\/p>\n
\n {<\/span>
\n "name"<\/span>:<\/span> "sales_analytics"<\/span>,<\/span>
\n "description"<\/span>:<\/span> "\u7528\u4e8e\u9500\u552e\u6570\u636e\u5206\u6790\u7684\u6570\u636e\u5e93\u7ed3\u6784\u548c\u4e1a\u52a1\u903b\u8f91，\u5305\u62ec\u5ba2\u6237\u3001\u8ba2\u5355\u548c\u6536\u5165\u3002"<\/span>,<\/span>
\n "content"<\/span>:<\/span> """# \u9500\u552e\u5206\u6790\u6570\u636e\u7ed3\u6784<\/p>\n
\n– customer_id（\u4e3b\u952e）
\n– name（\u59d3\u540d）
\n– email（\u90ae\u7bb1）
\n– signup_date（\u6ce8\u518c\u65e5\u671f）
\n– status（\u72b6\u6001：active\/active \u8868\u793a\u6d3b\u8dc3，inactive \u8868\u793a\u975e\u6d3b\u8dc3）
\n– customer_tier（\u5ba2\u6237\u7b49\u7ea7：bronze\/\u94f6\u724c\/silver\/\u91d1\u724c\/gold\/\u767d\u91d1\/platinum）<\/p>\n
\n– order_id（\u4e3b\u952e）
\n– customer_id（\u5916\u952e \u2192 customers）
\n– order_date（\u4e0b\u5355\u65e5\u671f）
\n– status（\u8ba2\u5355\u72b6\u6001：pending\/\u5f85\u5904\u7406\u3001completed\/\u5df2\u5b8c\u6210\u3001cancelled\/\u5df2\u53d6\u6d88\u3001refunded\/\u5df2\u9000\u6b3e）
\n– total_amount（\u8ba2\u5355\u603b\u91d1\u989d）
\n– sales_region（\u9500\u552e\u533a\u57df：north\/\u5317\u533a\u3001south\/\u5357\u533a\u3001east\/\u4e1c\u533a\u3001west\/\u897f\u533a）<\/p>\n
\n– item_id（\u4e3b\u952e）
\n– order_id（\u5916\u952e \u2192 orders）
\n– product_id（\u4ea7\u54c1ID）
\n– quantity（\u6570\u91cf）
\n– unit_price（\u5355\u4ef7）
\n– discount_percent（\u6298\u6263\u767e\u5206\u6bd4）<\/p>\n
\nSELECT
\n c.customer_id,
\n c.name,
\n c.customer_tier,
\n SUM(o.total_amount) as total_revenue
\nFROM customers c
\nJOIN orders o ON c.customer_id = o.customer_id
\nWHERE o.status = 'completed'
\n AND o.order_date >= CURRENT_DATE – INTERVAL '3 months'
\nGROUP BY c.customer_id, c.name, c.customer_tier
\nORDER BY total_revenue DESC
\nLIMIT 10;
\n"""<\/span>,<\/span>
\n }<\/span>,<\/span>
\n {<\/span>
\n "name"<\/span>:<\/span> "inventory_management"<\/span>,<\/span>
\n "description"<\/span>:<\/span> "\u7528\u4e8e\u5e93\u5b58\u8ddf\u8e2a\u7684\u6570\u636e\u5e93\u7ed3\u6784\u548c\u4e1a\u52a1\u903b\u8f91，\u5305\u62ec\u4ea7\u54c1\u3001\u4ed3\u5e93\u548c\u5e93\u5b58\u6c34\u5e73\u3002"<\/span>,<\/span>
\n "content"<\/span>:<\/span> """# \u5e93\u5b58\u7ba1\u7406\u6570\u636e\u7ed3\u6784<\/p>\n
\n– product_id（\u4e3b\u952e）
\n– product_name（\u4ea7\u54c1\u540d\u79f0）
\n– sku（\u5e93\u5b58\u5355\u4f4d\u7f16\u7801）
\n– category（\u7c7b\u522b）
\n– unit_cost（\u5355\u4f4d\u6210\u672c）
\n– reorder_point（\u518d\u8ba2\u8d27\u70b9：\u5e93\u5b58\u4f4e\u4e8e\u6b64\u503c\u65f6\u9700\u8865\u8d27）
\n– discontinued（\u662f\u5426\u505c\u4ea7：\u5e03\u5c14\u503c）<\/p>\n
\n– warehouse_id（\u4e3b\u952e）
\n– warehouse_name（\u4ed3\u5e93\u540d\u79f0）
\n– location（\u4f4d\u7f6e）
\n– capacity（\u5bb9\u91cf）<\/p>\n
\n– inventory_id（\u4e3b\u952e）
\n– product_id（\u5916\u952e \u2192 products）
\n– warehouse_id（\u5916\u952e \u2192 warehouses）
\n– quantity_on_hand（\u5f53\u524d\u5e93\u5b58\u6570\u91cf）
\n– last_updated（\u6700\u540e\u66f4\u65b0\u65f6\u95f4）<\/p>\n
\n– movement_id（\u4e3b\u952e）
\n– product_id（\u5916\u952e \u2192 products）
\n– warehouse_id（\u5916\u952e \u2192 warehouses）
\n– movement_type（\u53d8\u52a8\u7c7b\u578b：inbound\/\u5165\u5e93\u3001outbound\/\u51fa\u5e93\u3001transfer\/\u8c03\u62e8\u3001adjustment\/\u8c03\u6574）
\n– quantity（\u6570\u91cf：\u5165\u5e93\u4e3a\u6b63，\u51fa\u5e93\u4e3a\u8d1f）
\n– movement_date（\u53d8\u52a8\u65e5\u671f）
\n– reference_number（\u53c2\u8003\u7f16\u53f7）<\/p>\n
\nSELECT
\n p.product_id,
\n p.product_name,
\n p.reorder_point,
\n SUM(i.quantity_on_hand) as total_stock,
\n p.unit_cost,
\n (p.reorder_point – SUM(i.quantity_on_hand)) as units_to_reorder
\nFROM products p
\nJOIN inventory i ON p.product_id = i.product_id
\nWHERE p.discontinued = false
\nGROUP BY p.product_id, p.product_name, p.reorder_point, p.unit_cost
\nHAVING SUM(i.quantity_on_hand) <= p.reorder_point
\nORDER BY units_to_reorder DESC;
\n"""<\/span>,<\/span>
\n }<\/span>,<\/span>
\n]<\/span><\/p>\n2. \u521b\u5efa\u6280\u80fd\u52a0\u8f7d\u5de5\u5177<\/h6>\n
\ndef<\/span> load_skill<\/span>(<\/span>skill_name:<\/span> str<\/span>)<\/span> –<\/span>><\/span> str<\/span>:<\/span>
\n """\u5c06\u6280\u80fd\u7684\u5b8c\u6574\u5185\u5bb9\u52a0\u8f7d\u5230\u667a\u80fd\u4f53\u4e0a\u4e0b\u6587\u4e2d\u3002<\/p>\n
\n \u5b83\u5c06\u4e3a\u60a8\u63d0\u4f9b\u8be5\u6280\u80fd\u9886\u57df\u7684\u5b8c\u6574\u6307\u4ee4\u3001\u7b56\u7565\u548c\u6307\u5357\u3002<\/p>\n
\n skill_name: \u8981\u52a0\u8f7d\u7684\u6280\u80fd\u540d\u79f0（\u4f8b\u5982 "expense_reporting", "travel_booking"）
\n """<\/span>
\n # \u67e5\u627e\u5e76\u8fd4\u56de\u8bf7\u6c42\u7684\u6280\u80fd<\/span>
\n for<\/span> skill in<\/span> SKILLS:<\/span>
\n if<\/span> skill[<\/span>"name"<\/span>]<\/span> ==<\/span> skill_name:<\/span>
\n return<\/span> f"\u5df2\u52a0\u8f7d\u6280\u80fd: <\/span>{<\/span>skill_name}<\/span><\/span>\\\\n\\\\n<\/span>{<\/span>skill[<\/span>'content'<\/span>]<\/span>}<\/span><\/span>"<\/span><\/span> # [!code highlight]<\/span><\/p>\n
\n available =<\/span> ", "<\/span>.<\/span>join(<\/span>s[<\/span>"name"<\/span>]<\/span> for<\/span> s in<\/span> SKILLS)<\/span>
\n return<\/span> f"\u672a\u627e\u5230\u6280\u80fd '<\/span>{<\/span>skill_name}<\/span><\/span>'\u3002\u53ef\u7528\u6280\u80fd：<\/span>{<\/span>available}<\/span><\/span>"<\/span><\/span><\/p>\n3. \u6784\u5efa\u6280\u80fd\u4e2d\u95f4\u4ef6<\/h6>\n
\nfrom<\/span> langchain.<\/span>messages import<\/span> SystemMessage
\nfrom<\/span> typing import<\/span> Callable<\/p>\n
\n """\u5c06\u6280\u80fd\u63cf\u8ff0\u6ce8\u5165\u7cfb\u7edf\u63d0\u793a\u8bcd\u7684\u4e2d\u95f4\u4ef6\u3002"""<\/span><\/p>\n
\n tools =<\/span> [<\/span>load_skill]<\/span> # [!code highlight]<\/span><\/p>\n