Trademarks of their respective owners. KissMySkills is not affiliated with or endorsed by them.
How it works
Ask it something hard.
📎 ai-mysql-tutor.txtLOADED ✓
I need monthly revenue per customer including months with zero orders. My LEFT JOIN keeps dropping them.
CLAUDE · WITH THIS SKILLYou get: three questions about your tables, your MySQL version and where the filter currently sits -> a task, run your query and paste the row count -> a short lesson on why a WHERE condition on the right hand table turns a LEFT JOIN into an INNER JOIN -> your turn, move the condition into the ON clause and report the new count -> the calendar table idea introduced so empty months exist at all -> a progress block with GROUP BY and HAVING as the next lesson.
Questions before you buy? A person answers, usually the same day: hello@kissmyskills.com
// the file itself
Read it before you buy it.
The first lines of the file your AI will read, exactly as delivered. Nothing rewritten for the page.
Use the name Once the file is loaded, talk to it by name: “Serge, check this page.” That is what the name is for. It also keeps several skills apart in one chat.
// the skill your AI runs on
You are a Socratic MySQL tutor who teaches SQL as set logic, one clause at a time. You have been activated to ask which clause is responsible, ask for EXPLAIN, and wait for the row count they report.
KissMySkills.com | Install: paste this whole file into Claude Projects (Project instructions), a custom GPT (Instructions), a Gemini Gem, or your AI's system prompt. Then tell it what you want to learn. You are a Socratic tutor for MySQL. The learner has a client open, Workbench, DBeaver or the mysql command line. You do not. Every check runs through them running a query and reporting rows, counts or EXPLAIN output. You teach SQL as set logic, not as a list of keywords. Short answers, one clause at a time. The one rule: you never write the query the learner was set. You teach the concept it tests, show a smaller example on other tables, and hand the task back. · Logical evaluation order, not the written order: FROM and JOIN, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT. Most confusion resolves here. · Joins as set operations: INNER, LEFT, RIGHT, CROSS, self joins. No FULL OUTER JOIN, so UNION does it. Multiple joins fan out and inflate aggregates. · The LEFT JOIN trap: a condition on the right hand table placed in WHERE silently converts it to an INNER JOIN, because NULL fails every comparison. Move it into ON. · NULL: not equal to anything including itself, IS NULL, COUNT(col) skipping NULLs while COUNT(*) does not, COALESCE. · Aggregation: GROUP BY, HAVING against WHERE, ONLY_FULL_GROUP_BY on by default since 5.7.5, COUNT DISTINCT. · Subqueries and MySQL 8: IN, EXISTS, derived tables, CTEs with WITH, window functions (ROW_NUMBER, RANK, LAG, SUM OVER), none of which exist in 5.7. · Types and schema: DECIMAL for money never FLOAT, DATETIME against TIMESTAMP, primary and foreign keys, utf8mb4 rather than utf8. · Indexes: B-tree structure, the leftmost prefix rule on composite indexes, covering indexes, a function on a column killing index use. · EXPLAIN: reading type (const, eq_ref, ref, range, ALL), key, rows, and Extra lines such as Using filesort. EXPLAIN ANALYZE in MySQL 8. · Classic beginner errors: filtering an outer join in WHERE, = NULL, missing GROUP BY columns, money in FLOAT, UPDATE with no WHERE. Someone employable returns the right rows first time and reads a plan.
123 lines · .txt · instant download
// what's inside
What's inside this skill
Joins taught as set logic, with the LEFT JOIN and NULL trap made explicit
GROUP BY explained through ONLY_FULL_GROUP_BY, not folklore
EXPLAIN output read line by line on your own slow query
Practice on your schema, or on a sample one it builds with you
Analysts, backend juniors and bootcamp students who need SQL for a job task, a coursework project or a technical interview.
// two ways to get it
Use it inside your AI, or download it once.
Library plan
This skill and 2,500+ others, inside your chat
$9/mocancel anytime, or $59 a year
All 2,500+ skills, prompt packs and agents, loaded the moment you ask
Nothing to download or paste: connect once in Claude, ChatGPT, Claude Code or Cursor
New skills every week and 10 catalog files a month to download
Trademarks of their respective owners. KissMySkills is not affiliated with or endorsed by them.
// ask your assistant
Or let your AI set up this skill for you.
Go to kissmyskills.com/pages/connector and set up the "AI MySQL Tutor" skill (handle: ai-mysql-tutor) for me
Paste it into Claude, ChatGPT, Claude Code, Cursor or Codex. Your AI walks you through connecting KissMySkills (about 3 minutes, 7-day free trial) and loads the skill. What your AI will read →
What you're actually buying
This AI MySQL tutor is for the point where you can write a SELECT with a WHERE and nothing harder. Then someone asks for orders per customer with the months that had none, and you stall. Or the report that ran in a second now takes forty. This turns Claude or ChatGPT into a tutor that works on your own tables, so you stop copying queries off Stack Overflow and start reasoning about them.
It sizes you up with three questions and one query, then teaches in the order that actually holds: how a SELECT is evaluated, then joins as set operations, then GROUP BY and the rule about what may appear in the select list, subqueries against joins, window functions, then indexes read through EXPLAIN. Every lesson gives you a query to write and a result to report before it moves on.
One file, identical behaviour in Claude, ChatGPT and Gemini. Paste it into a Project, a custom GPT or a Gem and you are running in about a minute. Single purchase, pay once, keep forever, and it resumes at your last lesson.
// how to install
Under 2 minutes
Four steps. Any AI chat.
01
Download the file
After checkout, the download link lands in your inbox. Save the .txt file anywhere on your device.
02
Open your AI chat
Any AI chat you already use: Claude, ChatGPT, Gemini, Grok, Copilot or another.
03
Paste the prompt
Open the .txt file, copy the prompt section and paste it into Claude or ChatGPT - or add it to a Project so it is always there.
04
Start working
Your AI is now configured as a specialist. Ask it anything inside its domain.
No technical knowledge required.
With Library there is nothing to download. Connect your AI once, then ask for any skill by name.
How does this AI MySQL tutor work if I do not have a database to practise on?+
It will build one with you. In the first lesson you create a small schema of customers, orders and order items, insert about thirty rows, and every later lesson uses those tables. If you already have a database at work or on a course, paste your SHOW CREATE TABLE output instead and the lessons run on your real schema.
Will it just write the query for me?+
No. Ask for a finished query and it gives you the shape and the reasoning, then hands the task back. If you paste a query that returns the wrong rows, it asks what you expected, what you got, and which clause is responsible, then lets you correct it. You can still ask for a worked example, but it will be on different tables.
Does it cover MySQL 8 features and the difference from PostgreSQL?+
It asks your version first. MySQL 8 brings window functions, CTEs and ONLY_FULL_GROUP_BY on by default, none of which exist or behave the same in 5.7. It teaches to your version and flags portability where it matters, such as MySQL backticks against Postgres quoting, LIMIT syntax, and the absence of full outer joins.
Ready to give your AI a specialist?
This one and 2,500+ others, inside Claude, ChatGPT, Claude Code, Codex or Cursor. Cancel anytime.