← Back to Skills Marketplace
chat-ai
by
LoveNerverMore
· GitHub ↗
· v1.0.0
· MIT-0
295
Downloads
0
Stars
2
Active Installs
1
Versions
Install in OpenClaw
/install chat-ai
Description
将自然语言问题转化为 SQL 查询并执行，支持多轮对话、意图识别、SQL 审计、可视化推荐等全流程。
README (SKILL.md)
\r \r
chat_ai（文本问数）\r
\r
功能\r
将自然语言问题转化为 SQL 查询并执行，支持多轮对话、意图识别、SQL 审计、可视化推荐等全流程。\r \r
触发方式\r
- “查一下上个月销售额最高的5个产品”\r
- “对比华东和华北的GMV”\r
- “用 text2sql 帮我分析用户留存”\r \r
输入参数\r
query: 用户自然语言问题（必填）\r \r
输出格式\r
{\r
"status": "success|error",\r
"sql": "SELECT ...",\r
"result": [{...}], // 表格数据\r
"summary": "简要结论",\r
"regions": ["recognize_intent", "sql_generator", ...]\r
}
Usage Guidance
Do not install or enable this skill without further review. The main.py file inserts a hard-coded local path (D:\javaworkspace\Winner-Ai) into sys.path and imports modules not included in the package; if that path exists on your machine the skill will execute code from it, which could access credentials, databases, or network resources. Ask the publisher to either (a) include all required modules in the skill bundle, (b) remove the sys.path injection and rely on standard packaging, or (c) provide a clear list of required environment variables and external services. If you must test it, run it in an isolated sandbox with no access to sensitive credentials, inspect the AIChatOrchestrator and related project code for networking/secret access, and verify what external endpoints and environment variables it uses.
Capability Assessment
Purpose & Capability
The SKILL.md describes a text-to-SQL assistant and requires only a 'query' input, but main.py modifies sys.path to include a hard-coded local Windows project root (D:\javaworkspace\Winner-Ai) and imports AIChatOrchestrator and other modules that are not part of the skill bundle. This mismatch (expecting a separate developer project on disk) is not justified by the stated purpose and is disproportionate.
Instruction Scope
SKILL.md instructions are scoped to converting queries to SQL, but main.py's runtime behavior goes beyond that: it injects an external project path, imports app.* modules (including a redis client and orchestrator), and will execute that external project's logic if present. The SKILL.md does not mention reading local code/config or contacting external systems that the imported orchestrator might use.
Install Mechanism
There is no install spec (instruction-only), which reduces direct install risk. However, the bundled main.py will attempt to import code from an external, hard-coded filesystem location rather than relying only on bundled code or declared dependencies — effectively making the skill depend on arbitrary host files at runtime.
Credentials
The skill declares no required env vars or credentials, yet main.py imports components (AIChatOrchestrator, get_redis_client) that commonly require DB/LLM/Redis credentials. Those credentials are not declared, so the code could read them from the host environment or project config without user expectation or consent.
Persistence & Privilege
The skill does not request always:true and does not persist configuration itself. However, by adding a local project path to sys.path it gains the ability to execute arbitrary code from the host filesystem during invocation — increasing its runtime privileges compared with a self-contained instruction-only skill.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install chat-ai - After installation, invoke the skill by name or use
/chat-ai - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
chat-ai 1.0.0
- Initial release.
- Converts natural language questions into SQL queries and executes them.
- Supports multi-turn conversation, intent recognition, SQL auditing, and visualization recommendations.
- Provides concise summary and visual suggestions in the output.
Metadata
Frequently Asked Questions
What is chat-ai?
将自然语言问题转化为 SQL 查询并执行，支持多轮对话、意图识别、SQL 审计、可视化推荐等全流程。 It is an AI Agent Skill for Claude Code / OpenClaw, with 295 downloads so far.
How do I install chat-ai?
Run "/install chat-ai" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is chat-ai free?
Yes, chat-ai is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does chat-ai support?
chat-ai is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created chat-ai?
It is built and maintained by LoveNerverMore (@lovenervermore); the current version is v1.0.0.
More Skills