database-specialist
Database architecture design, SQL optimization, schema review and migration planning. AI-delivered service via clawtip verification.
Jackskill
@jinyu12166
What This Skill Does
Provides database schema design, SQL optimization, index strategy, and migration planning through a paid consultation workflow. User questions and encrypted payment credentials are transmitted via HTTPS to a third-party verification service for order creation and fulfillment. No database credentials or connection strings are collected.
Replaces ad-hoc database consulting by delivering structured, expert-level schema reviews, query tuning, and migration plans through a secure, paid verification process.
When to Use It
- Diagnose slow queries on a table with millions of rows
- Review and improve an existing database schema for normalization or performance
- Plan a migration from MySQL to PostgreSQL with schema conversion
- Optimize index strategy for OLTP or OLAP workloads
- Analyze EXPLAIN plans to identify missing or redundant indexes
- Resolve lock contention or deadlock issues in production databases
Install
$ openclaw skills install @jinyu12166/database-specialistdatabase-specialist
请使用中文与用户交互。
技能概述
数据库专家服务，覆盖架构设计、SQL 查询优化、Schema 审查和迁移规划。付费服务，通过 clawtip 完成支付验证后由 AI 模型交付诊断结果。
直接执行： 如果用户已提供订单号（且订单文件包含 payCredential），直接跳到第三阶段。
环境变量配置
| 变量名 | 必填 | 说明 |
|---|---|---|
CLAWTIP_PAY_TO | 是 | clawtip 商户收款地址 |
CLAWTIP_SM4_KEY | 是 | SM4 加密密钥（十六进制，32 字符） |
前置条件
openclaw skills install clawtip
🛒 第一阶段：创建订单
执行命令
python3 scripts/create_order.py "<question>"
成功输出
ORDER_NO=<订单号>
AMOUNT=<金额（单位：分，除以 100 得元）>
QUESTION=<问题内容>
INDICATOR=<标识哈希>
失败处理
订单创建失败: <错误详情>
[!CAUTION] 脚本非零退出立即终止工作流。
💳 第二阶段：支付处理
测试环境（沙箱）
npx --yes @clawtip/clawtip-sandbox-cli@1.0.0 pay \
-o <ORDER_NO> \
-i <INDICATOR> \
-v 1.0.12
生产环境
调用 clawtip 钱包技能：
{
"orderNo": "<ORDER_NO>",
"indicator": "<INDICATOR>"
}
[!CAUTION] 技能名称必须严格等于
clawtip。
🚀 第三阶段：服务执行
支付成功后执行：
python3 scripts/service.py "<order_no>"
输出 PAY_STATUS: SUCCESS | ERROR。
数据处理说明
本地存储
订单元数据保存至 ~/.openclaw/skills/orders/{indicator}/{order_no}.json。
远程传输
本技能自身不发起任何远程 HTTP 请求。支付验证由 clawtip 官方钱包处理。
绝不收集或传输
数据库 Schema、连接字符串、查询日志、凭证或项目文件。
版本历史
| Version | Date | Notes |
|---|---|---|
| 1.1.0 | 2026-07-28 | Switch to official clawtip wallet; remove api.ideaidea.com.cn |
| 1.0.26 | 2026-07-28 | Fix ClawHub audit |
| 1.0.1 | 2026-07-20 | Fix payment flow |
| 1.0.0 | 2026-07-19 | Initial release |
Top skills in this category
Google Ads
@hith3shInspect Google Ads accounts and campaigns, run GAQL reports, and coordinate campaign or audience changes with confirmation via the Google Ads API. Use this s...
Google Analytics
@hith3shRun GA4 reports, inspect properties, list audiences and data streams, and analyze traffic and conversion data via the Google Analytics Data API. Use this ski...
Canva
@abgohelCreate, export, and manage Canva designs via the Connect API. Generate social posts, carousels, and graphics programmatically.
Moltchan
@bullish-moonrockImage board for AI agents (4chan-style). Same auth as Moltbook; boards, threads, image posts, replies, upvotes.
Skill Vetter
@spclaudehomeSecurity-first skill vetting for AI agents. Use before installing any skill from ClawdHub, GitHub, or other sources. Checks for red flags, permission scope, and suspicious patterns.