sql-optimization-interviewer SKILL.md skillA

sql-optimization-interviewer from preplabsai/interviewmentor is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add preplabsai/interviewmentor/sql-optimization-interviewer@git:20260318.d48dbe9

Pins git:20260318.d48dbe9 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
preplabsai/interviewmentor
Path
agents/data-engineer/sql-optimization-interviewer/SKILL.md
Versions recorded
2
Latest version
git:20260318.d48dbe9, committed Mar 18, 2026
First version recorded
Mar 18, 2026
Size
8,518 bytes
Repository stars
112
License
MIT

A Data Engineering interviewer focused on database performance. Use this agent when you need to practice analyzing slow queries, designing optimal indexes, and understanding EXPLAIN plans. It pushes you to think beyond basic SQL syntax and dive deep into how database engines actually execute your code under the hood.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# SQL Optimization Interviewer

> **Target Role**: Data Engineer / Backend Engineer
> **Topic**: SQL Query Optimization & Database Design
> **Difficulty**: Medium to Hard

---

## Persona

You are a senior data engineer who has optimized queries at scale (billions of rows). You're methodical, practical, and focused on real-world performance. You believe good SQL is both an art and a science. You're patient with candidates learning these concepts but expect them to think about data volume and access patterns.

### Communication Style
- **Tone**: Professional, practical, data-driven
- **Approach**: Start with business context, dive into technical implementation
- **Pacing**: Methodical - good database design can't be rushed

---

## Activation

When invoked, immediately begin Phase 1. Do not explain the skill, list your capabilities, or ask if the user is ready. Start the interview with a warm greeting and your first question.

---

## Core Mission

Help candidates master SQL optimization and database design for data engineering interviews. Focus on:

1. **Query Optimization**: EXPLAIN plans, index usage, query rewriting
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add preplabsai/interviewmentor/sql-optimization-interviewer@sha256:4c8fa745f9c65d84

The line at the top of this page pins the label git:20260318.d48dbe9, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_xje5k3kbbfw5errp.svg)](https://markdownregistry.com/a/art_xje5k3kbbfw5errp)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 2 versions of this file, all committed on Mar 18, 2026.

versioncommittedcommitsizeaudit
git:20260318.d48dbe9 latest2026-03-18 d48dbe9 8,518 BA view · diff
git:20260318.a30c7352026-03-18 a30c735 8,541 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (8518 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

preplabsai/interviewmentor · 112 stars · license MIT · pushed 2026-10-19 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_xje5k3kbbfw5errp
GET https://markdownregistry.com/api/v1/resolve?ref=preplabsai/interviewmentor/sql-optimization-interviewer
GET https://markdownregistry.com/api/v1/blob/4c8fa745f9c65d843beafea818eda0f78f92604cae8ad7a881afffebd4c65e77

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from preplabsai/interviewmentor

ai-product-strategy-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/ai-pm/ai-product-strategy-interviewer/SKILL.md · A VP of Product interviewer that simulates a product strategy interview focused on AI-native products. Use this agent…
git:20260318.dbc45df · audit A · 112 stars
prompt-engineering-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/ai-pm/prompt-engineering-interviewer/SKILL.md · A Senior AI Engineer interviewer that simulates a technical interview focused on prompt engineering and LLM…
git:20260318.dbc45df · audit A · 112 stars
responsible-ai-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/ai-pm/responsible-ai-interviewer/SKILL.md · A Head of AI Ethics interviewer that simulates an interview focused on responsible AI, AI safety, and trust & safety…
git:20260318.dbc45df · audit A · 112 stars
conflict-collaboration-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/behavioral/conflict-collaboration-interviewer/SKILL.md · A Staff Engineer interviewer that simulates a behavioral interview focused on conflict, disagreement, and…
git:20260601.85810d8 · audit A · 112 stars
failure-learning-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/behavioral/failure-learning-interviewer/SKILL.md · A Senior Engineering Coach interviewer that simulates a behavioral interview focused on failure ownership, detection…
git:20260601.e585a3f · audit A · 112 stars
leadership-principles-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/behavioral/leadership-principles-interviewer/SKILL.md · A Senior Engineering Manager interviewer that simulates a behavioral interview focused on leadership principles. Use…
git:20260318.77253fb · audit A · 112 stars
ownership-impact-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/behavioral/ownership-impact-interviewer/SKILL.md · An Engineering Manager interviewer that simulates a behavioral interview focused on ownership beyond assigned scope…
git:20260601.060dfb5 · audit A · 112 stars
mysql-performance-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/data-engineer/mysql-performance-interviewer/SKILL.md · A battle-scarred MySQL DBA interviewer who has tuned InnoDB at scale. Use this agent when you want to practice…
git:20260408.aad6fd2 · audit A · 112 stars
pipeline-architect-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/data-engineer/pipeline-architect-interviewer/SKILL.md · A Data Engineering Pipeline Architect interviewer focused on end-to-end data pipeline design. Use this agent when you…
git:20260318.dbc45df · audit A · 112 stars
schema-design-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/data-engineer/schema-design-interviewer/SKILL.md · A Data Warehouse and Lakehouse Schema Design Expert interviewer focused on dimensional modeling, star/snowflake…
git:20260318.dbc45df · audit A · 112 stars
broken-api-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/debugging/broken-api-interviewer/SKILL.md · An on-call SRE interviewer who just got paged about a broken checkout API. Use this agent when you want to practice…
git:20260318.dbc45df · audit A · 112 stars
cascading-failure-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/debugging/cascading-failure-interviewer/SKILL.md · An incident commander interviewer running a P0 outage war room. Use this agent when you want to practice diagnosing and…
git:20260318.dbc45df · audit A · 112 stars

Every file in preplabsai/interviewmentor

Browse by kind, by grade A, or by owner.