Skip to main content
skill CX Codex

core-viva — Claude Code skill: what it does, how to install

The core-viva Claude Code skill quizzes developers on CS fundamentals and SQL. It starts for interview revision and adjusts question difficulty based on answers.

MIT ★ 345 updated 2026-11-14

Install into Claude Code · Plugin marketplace All methods and platforms ↓
/plugin marketplace add nishant-Tiwari24/cracked
/plugin install cracked@cracked
Open on GitHub

What core-viva does

core-viva asks one question at a time about operating systems, databases, networking, OOP, and SQL. It grades each answer, gives a model response, and follows a wrong answer with an easier probe. Two correct answers in a row raise the difficulty.

For SQL practice, the skill creates a temporary SQLite database, runs the submitted query, then compares its output with a reference query. Execution needs the sqlite3 command or Python’s sqlite3 module; SQLite version affects window functions and some JOIN types. The skill can call cracked-profile for the final scorecard and company-intel when a company is named.

What it helps with

  • revise CS fundamentals before an interview
  • test knowledge of a chosen subject with questions
  • run an SQL query and compare its output with a reference
  • identify topics answered incorrectly

Example prompts for the agent

  • Quiz me on operating systems and databases.
  • Test my knowledge of normalization with 10 questions.
  • Run an SQL quiz and execute the queries in SQLite.

How to install core-viva

1Plugin marketplace

/plugin marketplace add nishant-Tiwari24/cracked
/plugin install cracked@cracked

This installs the whole cracked plugin with all its skills

2Skills CLI (Vercel)

npx skills add nishant-Tiwari24/cracked --skill core-viva -a claude-code

3Manually: put the files in place

~/.claude/skills/core-viva/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/core-viva/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about core-viva

How do I install core-viva in Claude Code?

Run these commands in order: /plugin marketplace add nishant-Tiwari24/cracked, then /plugin install cracked@cracked.

What does core-viva do?

It runs an adaptive quiz on CS fundamentals and SQL, grades responses, and lists topics to revisit.

What does core-viva need to work?

SQL execution needs the sqlite3 command or Python’s sqlite3 module. The cracked-profile and company-intel calls need the Skill tool; without it, the skill directs the agent to open the relevant SKILL.md files.

Source text

SKILL.md · MIT
---
name: core-viva
description: Rapid-fire CS fundamentals viva covering Operating Systems, DBMS, Computer Networks, OOP, and SQL (with real query execution), the core-subject questions asked in technical placement rounds. Adaptive difficulty, instant feedback per answer, and a per-subject score. Use when the user wants to revise or be quizzed on OS, DBMS, CN, OOPs, SQL, CS fundamentals, core subjects, or theory questions for interviews.
---

# Core viva

Fast, adaptive, interview-style questioning on CS fundamentals. The format is the one used in placement technical rounds: short questions, short answers, the interviewer probing deeper whenever an answer is shaky.

## 0. Setup

1. Call the Skill tool with "cracked-profile".
2. Settle the scope in one line, with defaults: **subjects** (default: all five, OS · DBMS · CN · OOP · SQL), **number of questions** (default 15), **level** (default: adaptive). If the user names a subject or a topic ("only deadlocks", "normalization"), run just that.
3. **Company mode**: if the user names a company, call the Skill tool with "company-intel". Weight subjects and topics by what its brief reports for technical rounds (service and mass-recruiter archetypes lean heavily on OS/DBMS/OOP/SQL theory; product companies on DBMS, SQL and OOP design; networking-heavy companies on CN). If the brief has web-sourced, reported core questions, include them, labelled "reported for <Company>". With no company, don't ask; use the default spread.
4. Use the syllabus in [SYLLABUS.md](SYLLABUS.md) to pick topics. Spread questions across topics. Never ask two questions from the same topic in a row unless you're probing.

## 1. The loop

Ask **one question at a time**. Number them (`Q4/15 · DBMS · medium`).

After each answer, give instant feedback in at most four lines:

```
✅ Correct  /  🟡 Partial  /  ❌ Incorrect
<the ideal 1–3 sentence interview answer>
<if partial or wrong: the specific thing they missed or got wrong>
```

Then move on. Adaptive rules:

- Two correct in a row → raise difficulty one step.
- Wrong → ask **one** follow-up probe on the same topic at an easier level, to tell a gap from a slip.
- "I don't know" is a valid answer. Treat it as incorrect but say it's the right thing to say in a real interview, rather than bluffing.
- Mix question types: definition, "difference between X and Y", "what happens when…", scenario ("Your query is slow. What do you check?"), and small numericals (page faults with FIFO/LRU, subnetting, CPU scheduling waiting time).

## 2. SQL questions run for real

For SQL questions, give a tiny schema with sample rows and ask for a query. Say the dialect up front: "I'll run this in SQLite; MySQL/PostgreSQL syntax is fine where it's equivalent." Check `sqlite3 --version` once (window functions need 3.25+, `FULL OUTER JOIN` and `RIGHT JOIN` need 3.39+); if the installed version is older, use Python's `sqlite3` module or say which features you can't run. When they answer:

1. Create a temp SQLite database (`sqlite3` is preinstalled on macOS and most Linux systems; else use Python's `sqlite3` module), load the schema and rows, and **run their query**.
2. Also run your reference query, and compare the results.
3. Show both result sets if they differ. Accept any query that returns the correct result, including equivalent MySQL/PostgreSQL syntax you had to translate to run it (say what you translated: `TOP`→`LIMIT`, `ILIKE`, `::` casts…). Flag syntax that wouldn't run on MySQL or PostgreSQL, since interviews usually use one of those. Mention style issues separately.

Typical SQL targets: joins (inner/left, self join), GROUP BY + HAVING, Nth highest salary, duplicates, window functions (RANK, ROW_NUMBER), subqueries vs joins, NULL handling.

## 3. Results

After the last question:

1. A per-subject table: `Subject | Asked | Correct | Partial | Score/10`.
2. **Gap list**: the specific topics they got wrong, each with a one-line "revise this" pointer (e.g. "Deadlock: Coffman conditions and Banker's algorithm").
3. The scorecard, via the Skill tool with "cracked-profile", one dimension per subject asked. Weak-spot tags are the topic slugs (`os-deadlock`, `dbms-normalization`, `cn-tcp-handshake`, `sql-window-functions`).
4. Offer: "Run a deep-dive on <weakest topic>?" A deep-dive is 5 escalating questions on one topic.

## Tone and accuracy

- Keep the pace brisk. No lectures between questions.
- **Numericals are computed, not recalled.** For page faults, CPU scheduling, subnetting and similar, compute the reference answer with a short Python snippet before grading, and say "reference checked by execution".
- Be precise. Fundamentals have right answers, and an ambiguous "ideal answer" teaches the wrong thing. If a question has textbook-dependent variants (e.g. number of OSI layers vs the TCP/IP model), say so.

---

*Skill calls:* if your agent has no Skill tool, open the named skill's `SKILL.md` in the cracked skills folder (`core/`, `interview/`, `profile/`, `strategy/`) and follow it instead.

© Nishant Tiwari · MIT · nishant-Tiwari24/cracked

Similar skills

All skills for Data and databases →

From the same set20

The whole set →
rejection-review The rejection-review Claude Code skill analyzes a failed interview or OA and identifies likely causes. It turns the findings into three focused drills and a revised prep plan. CX Codex +1 ★ 345repo stars hr-round The hr-round Claude Code skill coaches candidates through HR and behavioral interview questions. It reviews each answer and turns real experience into reusable stories. CX Codex +1 ★ 345repo stars jd-match The jd-match Claude Code skill compares a resume with a job description and scores the match. It activates when tailoring an application or preparing for an interview for a specific role. CX Codex +1 ★ 345repo stars prep-plan The prep-plan Claude Code skill builds a week-by-week plan for job and interview preparation. It uses the candidate’s timeline, available hours, target companies, and weak areas from past sessions. CX Codex +1 ★ 345repo stars offer-decode The offer-decode Claude Code skill breaks down a job offer and estimates take-home pay. It runs on an offer letter, a CTC breakdown, or a request to compare terms and draft a negotiation reply. CX Codex +1 ★ 345repo stars system-design-mock The system-design-mock Claude Code skill runs practice interviews for system design, from fresher to SDE-2 level. It starts when someone asks to rehearse HLD or LLD, including a design prompt for a specific system. CX Codex +1 ★ 345repo stars referral-dm The referral-dm Claude Code skill drafts tailored messages for referral requests and job outreach. It can respond to hiring posts, contact recruiters or alumni, and write follow-ups. CX Codex +1 ★ 345repo stars github-glowup The github-glowup Claude Code skill audits a GitHub profile from a recruiter’s perspective and drafts improvements. Run it to revise a profile, select pinned repositories, or write a profile README. CX Codex +1 ★ 345repo stars

Project sponsors

Companies that keep this analytics open