What problem does it solve? Interviewers and mock-interview systems need structured, scenario-based database questions that test real production experience rather than memorized concepts, and this Skill provides a complete question-generation playbook for database roles. ## Core Features & Use Cases - Topic Ladders: Covers B+ trees and InnoDB storage, transactions and MVCC, locking and deadlocks, redo/undo/binlog, SQL optimization, replication, high availability, backup and recovery, online DDL and sharding, distributed databases, LSM engines, and NoSQL selection. - Role-Specific Tracks: Separates question sets for database kernel developers, DBAs, and backend engineers, with distinct expectations for source-code depth versus operational incident handling. - Resume Hooks: Maps resume keywords like MySQL, Redis, TiDB, or sharding experience to targeted follow-up probes about real troubleshooting and design trade-offs. - Use Case: When a candidate's resume mentions MySQL read-write splitting, generate a mock interview that probes replication lag diagnosis, semi-sync degradation, and failover data-loss handling. ## Quick Start Generate a database mock interview for a candidate whose resume mentions MySQL indexing and transaction experience, focusing on slow query diagnosis and deadlock troubleshooting.
