wrenai-query - SKILL.md Agent Skill

name: wrenai-query description: WrenAI natural language to SQL query tool. IMPORTANT: Use exec tool to run the script directly, DO NOT implement the logic yourself.

WrenAI Query Tool

⚠️ CRITICAL INSTRUCTIONS FOR AI AGENTS

YOU MUST FOLLOW THESE INSTRUCTIONS EXACTLY. DO NOT DEVIATE.

When User Asks for Database Query

USE THE EXEC TOOL. RUN THIS EXACT COMMAND:

sh "/data/.skills/wrenai-query/scripts/wrenai" "user's natural language query here" pg

DO NOT:

❌ DO NOT call WrenAI API yourself
❌ DO NOT write your own SQL execution code
❌ DO NOT try to install psycopg2 or any Python packages
❌ DO NOT read the script and reimplement its logic
❌ DO NOT use skills tool to "understand" then implement

WHY: The script at /data/.skills/wrenai-query/scripts/wrenai already does everything:

Calls WrenAI API to generate SQL
Executes SQL via HTTP API (no database drivers needed)
Returns JSON with results

Just execute the command and parse the JSON output.

Usage

Basic Query (PostgreSQL - default)

sh "/data/.skills/wrenai-query/scripts/wrenai" "Query last month's KPI indicators" pg

Query MSSQL (Fanwei system)

sh "/data/.skills/wrenai-query/scripts/wrenai" "统计各渠道的业务办理量" mssql

Query HR System (Hongjing)

sh "/data/.skills/wrenai-query/scripts/wrenai" "查询员工信息" hr

Output Format

The script returns JSON:

{
  "success": true,
  "query": "查询上个月江西省的KPI指标",
  "sql": "SELECT * FROM ...",
  "execution_success": true,
  "results": {
    "records": [...],
    "columns": [...],
    "total_rows": 10
  },
  "analysis": "AI analysis text"
}

Parse this JSON to get the data. DO NOT try to execute the SQL yourself.

Supported Data Sources

Instance	Database	Use Case
pg	PostgreSQL	CBNBI business data, KPIs
mssql	SQL Server	Fanwei system data
hr	SQL Server	HR system data

Technical Details (For Reference Only)

DO NOT USE THIS INFORMATION TO IMPLEMENT YOUR OWN SOLUTION.

WrenAI Service: Converts natural language to SQL
WrenUI Service: Executes SQL via HTTP API at /api/v1/run_sql
The script uses only Python standard library (urllib, json)
No database drivers (psycopg2, pymssql) required

If you find yourself writing Python code to call WrenAI API, YOU ARE DOING IT WRONG.

Use the script. That's it.