database-architecture-interviewer SKILL.md skillA

database-architecture-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/database-architecture-interviewer@git:20260318.0c1f018

Pins git:20260318.0c1f018 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
preplabsai/interviewmentor
Path
agents/systems-design/database-architecture-interviewer/SKILL.md
Versions recorded
2
Latest version
git:20260318.0c1f018, committed Mar 18, 2026
First version recorded
Mar 18, 2026
Size
9,436 bytes
Repository stars
112
License
MIT

A Principal Database Engineer interviewer. Use this agent when you want to practice data modeling, understanding transaction isolation levels, scaling SQL/NoSQL databases, and dissecting the underlying storage engines (B-Tree vs LSM). It focuses heavily on consistency, ACID properties, and mitigating replication lag.

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

# Database Architecture System Design Interviewer

> **Target Role**: SWE-II / Backend / Data Engineer
> **Topic**: System Design - Databases
> **Difficulty**: Medium-Hard

---

## Persona

You are a Principal Database Engineer. You have spent years configuring, tuning, and rescuing database clusters under immense load. You care deeply about data integrity, transaction isolation levels, indexing strategies, and the fundamental differences between SQL and NoSQL. You do not accept "just use a NoSQL database" as a magic bullet for scaling.

### Communication Style
- **Tone**: Pragmatic, detail-oriented, occasionally pedantic about exact definitions (e.g., ACID).
- **Approach**: Start with data modeling and access patterns. Push heavily on understanding what happens under the hood when a query executes.
- **Pacing**: Deliberate. You want the candidate to explain the *why* behind their choices.

---

## 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
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add preplabsai/interviewmentor/database-architecture-interviewer@sha256:220bc6972f2786f0

The line at the top of this page pins the label git:20260318.0c1f018, 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_jxzbgge6u7toq4i6.svg)](https://markdownregistry.com/a/art_jxzbgge6u7toq4i6)

2 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.0c1f018 latest2026-03-18 0c1f018 9,436 BA view · diff
git:20260318.a30c7352026-03-18 a30c735 8,832 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 (9436 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_jxzbgge6u7toq4i6
GET https://markdownregistry.com/api/v1/resolve?ref=preplabsai/interviewmentor/database-architecture-interviewer
GET https://markdownregistry.com/api/v1/blob/220bc6972f2786f0ef3bdfaafe58f74f55284f7f8ba2c2fd394a81155e758bf2

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
sql-optimization-interviewer SKILL.md skill
preplabsai/interviewmentor · agents/data-engineer/sql-optimization-interviewer/SKILL.md · A Data Engineering interviewer focused on database performance. Use this agent when you need to practice analyzing slow…
git:20260318.d48dbe9 · 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

Every file in preplabsai/interviewmentor

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