slow-database-interviewer

Official

Seasoned DBA interview for slow query debugging.

AuthorPrepLabsAI
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill provides a realistic DBA interviewer persona to help learners practice diagnosing and debugging slow database performance, focusing on query plans, indexing, statistics, and lock contention.

Core Features & Use Cases

  • Simulated interview scenarios covering phase-based debugging from symptom to prevention.
  • Emphasizes diagnostic rigor, root-cause analysis, and prevention strategies for production-grade systems.
  • Use cases include analyzing EXPLAIN ANALYZE outputs, detecting stale statistics, identifying missing indexes post-migration, and handling lock contention scenarios.

Quick Start

Begin a mock interview by presenting the initial slow query symptom and walk the candidate through Phase 1.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: slow-database-interviewer
Download link: https://github.com/PrepLabsAI/InterviewMentor/archive/main.zip#slow-database-interviewer

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.