提供v3_e-report数据库的SQL查询模板,包括数据分析告警配置等表的查询。查询分析告警配置时使用。使用 exec_sql 工具执行查询。
/plugin marketplace add SeSiTing/siti-claude-marketplace/plugin install op-plugin@siti-claude-marketplaceThis skill inherits all available tools. When active, it can use any tool Claude has access to.
COMMON.md参考:通用规范
所有查询使用 exec_sql 工具执行,参数替换为实际值。
重要:在执行 SQL 前,必须先打印出完整的目标 SQL 语句,然后再使用 exec_sql 工具执行。
重要:执行 SQL 后,必须对查询结果进行结构化展示:
用途:查询数据分析告警配置信息。用于统计配置了数据分析告警的租户数和告警规则数量。
字段:
id - 告警配置IDorg_id - 租户ID(工厂id)code - 编号name - 名称status - 状态(0=未启用,1=启用,表示是否发布)data_set_id - 数据集IDconditions - 条件(JSON格式)action - 触发动作查询示例:
-- 按租户查询告警配置
SELECT * FROM v3_e-report.analysis_config WHERE org_id = {org_id} AND deleted_at = 0;
注意:完整表结构通过 DESC v3_e-report.analysis_config 或 SHOW COLUMNS FROM v3_e-report.analysis_config 查询。
{参数名}都需要替换为实际值deleted_at = 0条件exec_sql 执行DESC table_name 或 SHOW COLUMNS FROM table_name 查询Use when working with Payload CMS projects (payload.config.ts, collections, fields, hooks, access control, Payload API). Use when debugging validation errors, security issues, relationship queries, transactions, or hook behavior.
Applies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.
Creating algorithmic art using p5.js with seeded randomness and interactive parameter exploration. Use this when users request creating art using code, generative art, algorithmic art, flow fields, or particle systems. Create original algorithmic art rather than copying existing artists' work to avoid copyright violations.