Important — use your own judgment
AI-generated SQL and analysis are provided as a helpful starting point only. Large language models can produce plausible but incorrect queries — they may hallucinate column names, misinterpret your question, or return wrong numbers with high confidence.
Always review generated SQL and validate results against known data before making business decisions. There is no guarantee of correctness. Human oversight required. Generated output must not be used as the sole basis for decisions that have legal or similarly significant effects on individuals. There is no guarantee of correctness.
Download
This skill teaches your AI coding assistant how to query the Magicline Enterprise Data Warehouse. It includes a complete schema map (85 tables), query recipes for common questions, and rules that prevent the most common SQL mistakes.
It follows the open Agent Skills standard, supported by 30+ AI tools including Claude Code, OpenCode, Cursor, GitHub Copilot, and more.
Download Skill (.zip)
How to use
Download the zip and extract it into your tool's skills directory:
| Tool | Instructions |
|---|---|
| claude.ai | Upload the zip file in Settings → Features → Skills |
| Claude Code | Unzip to ~/.claude/skills/ (personal) or .claude/skills/ (project) |
| OpenCode | Unzip to .opencode/skills/ in your project |
| Cursor | Unzip to .cursor/skills/ in your project |
| GitHub Copilot / VS Code | Unzip to .github/skills/ in your project |
| Gemini CLI | Unzip to .gemini/skills/ in your project |
| Other tools | Most AI coding tools support the Agent Skills standard. Unzip into your tool's skills directory — see agentskills.io/clients for the full list. |
Example questions you can ask
- "How many active members do I have?"
- "What's my monthly revenue trend for the last year?"
- "Which classes are most popular?"
- "How many members cancelled last month, and why?"
- "What are my busiest hours?"
- "Which members haven't visited in 30 days?"
- "How many day passes did I sell this quarter?"
- "What's the age and gender breakdown of my members?"