ttpos-agent

通过 ttpos-agent API 查询 TTPOS 餐饮系统营业数据，生成报表。使用前必须访问 GET /api/v1/query/guide 获取数据查询指南。Use when: 今日营业额、订单统计、支付方式、菜品排行、会员分析、班次汇总、时段分析等。NOT for: 与 TTPOS 数据无关的问题。

3,891 stars

byopenclaw

View on GitHub Installation ↓

Best use case

ttpos-agent is best used when you need a repeatable AI agent workflow instead of a one-off prompt.

Teams using ttpos-agent should expect a more consistent output, faster repeated execution, less prompt rewriting.

When to use this skill

You want a reusable workflow that can be run more than once with consistent structure.

When not to use this skill

You only need a quick one-off answer and do not need a reusable workflow.
You cannot install or maintain the underlying files, dependencies, or repository context.

Installation

Claude Code / Cursor / Codex

$curl -o ~/.claude/skills/ttpos-agent/SKILL.md --create-dirs "https://raw.githubusercontent.com/openclaw/skills/main/skills/bendaye/ttpos-agent/SKILL.md"

Manual Installation

Download SKILL.md from GitHub
Place it in .claude/skills/ttpos-agent/SKILL.md inside your project
Restart your AI agent — it will auto-discover the skill

How ttpos-agent Compares

Feature / Agent	ttpos-agent	Standard Approach
Platform Support	Not specified	Limited / Varies
Context Awareness	High	Baseline
Installation Complexity	Unknown	N/A

Frequently Asked Questions

What does this skill do?

Where can I find the source code?

You can find the source code on GitHub using the link provided at the top of the page.

Related Guides

Best AI Skills for Claude

Explore the best AI skills for Claude and Claude Code across coding, research, workflow automation, documentation, and agent operations.

AI Agents for Marketing

Discover AI agents for marketing workflows, from SEO and content production to campaign research, outreach, and analytics.

AI Agents for Startups

Explore AI agent skills for startup validation, product research, growth experiments, documentation, and fast execution with small teams.

SKILL.md Source

# ttpos-agent 数据查询技能

通过 ttpos-agent HTTP API 查询 TTPOS 餐饮系统数据，生成营业报表、订单统计、支付分析等。

## ⚠️ 必须首先执行

**在构造任何 SQL 或调用 API 之前，必须先访问接口获取数据查询指南：**

```
GET {LIGHT_BRIDGE_URL}/api/v1/query/guide
```

请求头需带 `Authorization: Bearer $LIGHT_BRIDGE_API_KEY`。返回的 Markdown 包含：多租户架构、订单/商品/桌台/会员/班次/统计表结构、时间与金额约定、常用查询模式、常见陷阱。**不获取此指南会导致表名错误、字段误用、统计重复。**

---

## Config（必须输入）

| 配置项 | 必填 | 说明 |
|--------|------|------|
| **LIGHT_BRIDGE_API_KEY** | ✅ | 在 [ttpos-agent Web 面板](https://claw.doge6.com/web/dashboard) 创建，在技能面板保存 |

---

## 工作流程

1. **获取指南**：`GET {LIGHT_BRIDGE_URL}/api/v1/query/guide`，理解数据模型与查询规范
2. **获取商户列表**：`GET {LIGHT_BRIDGE_URL}/api/v1/query/companies`，确认可用的 `company_uuid`
3. **构造 SQL**：根据用户问题，按指南中的表结构、统计表、时间筛选规则编写 SQL
4. **执行查询**：`POST {LIGHT_BRIDGE_URL}/api/v1/query/execute`，Body: `{"company_uuid": xxx, "sql": "SELECT ..."}`
5. **呈现结果**：用简洁语言总结，金额使用 ROUND 和当地货币符号；**不展示字段名**，枚举值翻译为中文（如 platform→平台、order_state→订单状态、DELIVERED→已送达）

---

## API 调用示例

### 获取数据查询指南（必须首先调用）

```bash
curl -s -H "Authorization: Bearer $LIGHT_BRIDGE_API_KEY" \
 "$LIGHT_BRIDGE_URL/api/v1/query/guide"
```

### 获取可访问商户

```bash
curl -s -H "Authorization: Bearer $LIGHT_BRIDGE_API_KEY" \
 "$LIGHT_BRIDGE_URL/api/v1/query/companies"
```

### 执行 SQL 查询

```bash
curl -s -X POST "$LIGHT_BRIDGE_URL/api/v1/query/execute" \
 -H "Authorization: Bearer $LIGHT_BRIDGE_API_KEY" \
 -H "Content-Type: application/json" \
 -d '{"company_uuid": 8267304538112000, "sql": "SELECT ..."}'
```

### 获取表结构（可选）

```bash
curl -s -H "Authorization: Bearer $LIGHT_BRIDGE_API_KEY" \
 "$LIGHT_BRIDGE_URL/api/v1/query/schema?company_uuid=8267304538112000"
```

---

## 重要规则

- **只输出最终结论**：工具执行后，仅呈现整理后的表格或总结，不要逐字复述 API 原始返回
- **不展示原始字段名**：禁止直接输出 `platform`、`order_state`、`eater_payment`、`accepted_time` 等数据库字段名；改用「平台」「订单状态」「订单金额」「接单时间」等中文表述
- **枚举值需翻译**：`order_state`(0/10/20/30/40/50/60)、`platform_order_state`(DELIVERED/CANCELLED 等) 必须译为中文（如：已完成、已取消、已送达、骑手已到店）；`platform` 的 grab/lineman 等译为 Grab、LINE MAN
- **先访问 GET /api/v1/query/guide 获取指南**，再写 SQL
- **始终加 `WHERE delete_time = 0`**
- **优先使用 ttpos_statistics_* 统计表**
- **时间用 complete_time 或 finish_time**，不用 create_time
- **金额展示用 ROUND(x, 2)**，指出货币单位
- **单次查询时间范围不宜超过 3 个月**，大数据加 LIMIT

---

## 认证失败时

若 API 返回 401 或缺少 LIGHT_BRIDGE_API_KEY：

**只回复**：「请在技能面板的 API key 输入框中保存你的 ttpos-agent API Key。API Key 在 [ttpos-agent Web 面板](https://claw.doge6.com/web/dashboard)（登录后）创建。」

配置完成后 使用 "/clear" 新建会话 再立即继续用户原来的请求。

Related Skills

---

3891

from openclaw/skills

name: article-factory-wechat

Content & Documentation

humanizer

3891

from openclaw/skills

Remove signs of AI-generated writing from text. Use when editing or reviewing text to make it sound more natural and human-written. Based on Wikipedia's comprehensive "Signs of AI writing" guide. Detects and fixes patterns including: inflated symbolism, promotional language, superficial -ing analyses, vague attributions, em dash overuse, rule of three, AI vocabulary words, negative parallelisms, and excessive conjunctive phrases.

Content & Documentation

find-skills

3891

from openclaw/skills

Helps users discover and install agent skills when they ask questions like "how do I do X", "find a skill for X", "is there a skill that can...", or express interest in extending capabilities. This skill should be used when the user is looking for functionality that might exist as an installable skill.

General Utilities

tavily-search

3891

from openclaw/skills

Use Tavily API for real-time web search and content extraction. Use when: user needs real-time web search results, research, or current information from the web. Requires Tavily API key.

Data & Research

baidu-search

3891

from openclaw/skills

Search the web using Baidu AI Search Engine (BDSE). Use for live information, documentation, or research topics.

Data & Research

agent-autonomy-kit

3891

from openclaw/skills

Stop waiting for prompts. Keep working.

Workflow & Productivity

Meeting Prep

3891

from openclaw/skills

Never walk into a meeting unprepared again. Your agent researches all attendees before calendar events—pulling LinkedIn profiles, recent company news, mutual connections, and conversation starters. Generates a briefing doc with talking points, icebreakers, and context so you show up informed and confident. Triggered automatically before meetings or on-demand. Configure research depth, advance timing, and output format. Walking into meetings blind is amateur hour—missed connections, generic small talk, zero leverage. Use when setting up meeting intelligence, researching specific attendees, generating pre-meeting briefs, or automating your prep workflow.

Workflow & Productivity

self-improvement

3891

from openclaw/skills

Captures learnings, errors, and corrections to enable continuous improvement. Use when: (1) A command or operation fails unexpectedly, (2) User corrects Claude ('No, that's wrong...', 'Actually...'), (3) User requests a capability that doesn't exist, (4) An external API or tool fails, (5) Claude realizes its knowledge is outdated or incorrect, (6) A better approach is discovered for a recurring task. Also review learnings before major tasks.

Agent Intelligence & Learning

botlearn-healthcheck

3891

from openclaw/skills

botlearn-healthcheck — BotLearn autonomous health inspector for OpenClaw instances across 5 domains (hardware, config, security, skills, autonomy); triggers on system check, health report, diagnostics, or scheduled heartbeat inspection.

DevOps & Infrastructure