wrenai-analyst

Convert natural language data questions into SQL, charts, and insights via WrenAI MCP.

5|2|Updated Mar 24, 2026
One-click install
npx skills add https://github.com/Canner/WrenAI-mcp --skill wrenai-analyst
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: wrenai-analyst
Source: https://github.com/Canner/WrenAI-mcp/tree/main/skills/wrenai-analyst
Command: npx skills add https://github.com/Canner/WrenAI-mcp --skill wrenai-analyst

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Data analysts spend hours translating questions into queries and building visuals. This Skill enables you to ask natural-language questions and get SQL, execution results, and charts via the WrenAI MCP, with auto schema understanding and proactive insights.

Core Features & Use Cases

  • Generate SQL and run queries against a connected data model.
  • Build charts/visualizations from questions.
  • Proactively provide business insights and recommendations based on query results.
  • Auto-read the schema to understand the data model without explaining every detail.
  • Use cases: ad hoc analytics, dashboards, metrics discovery, and data storytelling.

Quick Start

Connect MCP with /setup-wrenai-mcp and then ask a data question like show me top customers by revenue

Frequently Asked Questions about wrenai-analyst

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate SQL from natural language questions for business analytics?

You can generate SQL from natural language by asking your data question directly, which triggers the system to translate it into executable SQL, run the query, and return results. It reads your connected schema automatically to understand the data model.

Can I visualize SQL query results as charts without manual chart configuration?

Yes, you can visualize SQL query results as charts by simply asking to chart or visualize the data. The system generates Vega charts directly from your natural language request and the executed query results.

Do I need a WrenAI MCP connection to run natural language data queries?

Yes, you need a connected WrenAI MCP to run natural language data queries. You must set it up first using the /setup-wrenai-mcp command to load project metadata and enable SQL generation, execution, and charting.

What is the best way to get actionable business insights from ad hoc data analysis?

The best way to get actionable business insights from ad hoc data analysis is to ask natural language questions against your data model. The system executes queries and proactively generates summaries and recommendations based on the results.

How does schema auto-discovery work for natural language data queries?

Schema auto-discovery works by performing a get_project_metadata operation when you ask a question. It reads the connected data model structure automatically, so you do not need to manually explain table relationships or schema details before querying.

What are the limitations of natural language to SQL generation for complex BI queries?

Natural language to SQL generation for complex BI queries depends on the connected data model's structure and the WrenAI MCP's schema understanding. It does not support querying disconnected data sources or generating visuals outside the supported Vega chart format.