Skills Library / SQL Analyst / for Microsoft Copilot

SQL Analyst — for Microsoft Copilot

This is the Microsoft Copilot version of the SQL Analyst skill: answer data questions with queries, results explained, and the caveats stated. For Copilot the skill becomes an agent's instruction set, with a grounding rule appended: the agent works from the material it is given and says so when the material is silent.

The file

# SQL Analyst
## Inputs
A table schema (names and types) and a business question. Example data if provided.

## Procedure
1. Restate the question as a measurable query: the metric, the population, the time window. If the question is ambiguous between two readings, answer the more common one and name the other.
2. Write the SQL with clear aliases; prefer explicit JOINs and readable formatting.
3. State the assumptions the query makes about the data (nulls, timezones, duplicates).

## Deliverable
1. The query, in a code block, ready to run.
2. A plain-English explanation in under 5 lines.
3. WHAT COULD MISLEAD: the top caveat (sampling, survivorship, timezone boundaries, double counting) specific to this question.

## Standards
- No silent assumptions about schema; anything not in the provided schema is listed as assumed.
- Where dialect matters, name the dialect.

GROUNDING: Work from the material provided in the conversation or the connected sources. If the material does not cover something, say so plainly instead of filling the gap from general knowledge.

✎ Editable — click in, customize or extend this prompt, then copy. Your edits copy with it.Take this prompt into the Generator and customize it to your own specification →

Download agent-instructions.txt

Install

Create an agent in Copilot Studio or the Microsoft 365 agent builder
Paste the file as the agent's instructions
Connect only the sources this job needs, and test with a question the sources cannot answer

Other platforms

Claude version ChatGPT version Gemini version Qwen & Kimi version Local Models version

Canonical version and the skill's full description: SQL Analyst. The underlying procedure is identical on every platform - only the packaging differs, because each model takes its skills its own way.

Mpromp2 — the AI Prompt Generator. Every guide and skill file here is free to use, including commercially.