bosskuai-database-engineering SKILL.md skillA

bosskuai-database-engineering from wankimmy/bossku-superpowers is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add wankimmy/bossku-superpowers/bosskuai-database-engineering@git:20261012.17c6803

Pins git:20261012.17c6803 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
wankimmy/bossku-superpowers
Path
skills/bosskuai-database-engineering/SKILL.md
Versions recorded
5
Latest version
git:20261012.17c6803, committed Oct 12, 2026
First version recorded
Sep 2, 2026
Size
3,153 bytes
Repository stars
22
License
MIT

Use when SQL or NoSQL database design affects correctness or scale (MariaDB, MySQL, PostgreSQL, SQLite, MongoDB): indexing, query plans, transactions and locking, safe online migrations, constraints, multi-tenant schemas, connection pooling, backups.

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 engineering

Use when schema, indexes, query plans, locking, or a migration affects correctness or scale.

1. **Orient before changing anything**: engine and version — confirm tests run on the *same* engine, not SQLite standing in for MySQL/PostgreSQL — the live schema and migration history, existing indexes and their usage stats, and the top queries by total time.
2. **Name the invariant you're protecting** and encode it in the database as a unique or check constraint, not only in application code.
3. **Get the plan before touching an index.** `EXPLAIN`/`EXPLAIN ANALYZE` first; a query is not "fast" or "slow" without one, before or after.
4. **Design composite indexes equality columns first, then the range column, then `ORDER BY`**; lead every tenant-scoped index with `tenant_id`; check selectivity before adding; remove unused and duplicate indexes.
5. **Never run a whole-table `UPDATE` or a locking DDL directly against a production-sized table.** Use expand → chunked backfill → non-locking constraint → switch reads → contract, and state each step's lock impact and rollback.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add wankimmy/bossku-superpowers/bosskuai-database-engineering@sha256:f2d38b1da254911b

The line at the top of this page pins the label git:20261012.17c6803, 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_x64wrhthi2zylgwu.svg)](https://markdownregistry.com/a/art_x64wrhthi2zylgwu)

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

Versions

The registry has recorded 5 versions of this file, between Sep 2, 2026 and Oct 12, 2026, about one every 10 days.

versioncommittedcommitsizeaudit
git:20261012.17c6803 latest2026-10-12 17c6803 3,153 BA view · diff
git:20261010.cd731692026-10-10 cd73169 2,049 BA view · diff
git:20261001.cc31a372026-10-01 cc31a37 2,067 BA view · diff
git:20260926.9bc2d602026-09-26 9bc2d60 8,484 BA view · diff
git:20260902.8ca5fc42026-09-02 8ca5fc4 8,301 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 (3153 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

wankimmy/bossku-superpowers · 22 stars · license MIT · pushed 2026-10-21 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_x64wrhthi2zylgwu
GET https://markdownregistry.com/api/v1/resolve?ref=wankimmy/bossku-superpowers/bosskuai-database-engineering
GET https://markdownregistry.com/api/v1/blob/f2d38b1da254911b8a1b4f505b660e1fac0414dfb12252c53a05079d45fb5900

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 wankimmy/bossku-superpowers

bosskuai Cursor rule
wankimmy/bossku-superpowers · .cursor/rules/bosskuai.mdc · BosskuAI co-founder contract — indicator, routing, ponytail, anti-slop, loop engineering, grounding.
git:20261009.037c4b1 · audit A · 22 stars
AGENTS.md@.omp AGENTS.md file
wankimmy/bossku-superpowers · .omp/AGENTS.md
git:20260802.2f685b9 · audit B · 22 stars
AGENTS.md AGENTS.md file
wankimmy/bossku-superpowers · AGENTS.md
git:20261009.037c4b1 · audit A · 22 stars
CLAUDE.md CLAUDE.md file
wankimmy/bossku-superpowers · CLAUDE.md
git:20260716.6355db6 · audit B · 22 stars
ab-testing SKILL.md skill
wankimmy/bossku-superpowers · skills/ab-testing/SKILL.md · When the user wants to plan, design, or implement an A/B test or experiment, or build a growth experimentation program…
v2.0.0 · audit A · 22 stars
accessibility SKILL.md skill
wankimmy/bossku-superpowers · skills/accessibility/SKILL.md · Design, implement, and audit inclusive digital products using WCAG 2.2 Level AA. Use when building or auditing UI that…
git:20260907.6a40a93 · audit A · 22 stars
ad-creative SKILL.md skill
wankimmy/bossku-superpowers · skills/ad-creative/SKILL.md · When the user wants to generate, iterate, or scale ad creative — headlines, descriptions, primary text, or full ad…
v2.8.0 · audit A · 22 stars
ads SKILL.md skill
wankimmy/bossku-superpowers · skills/ads/SKILL.md · When the user wants help with paid advertising campaigns on Google Ads, Meta (Facebook/Instagram), LinkedIn, Twitter/X…
v2.2.0 · audit A · 22 stars
ai-seo SKILL.md skill
wankimmy/bossku-superpowers · skills/ai-seo/SKILL.md · When the user wants to optimize content for AI search engines, get cited by LLMs, or appear in AI-generated answers…
v2.2.0 · audit A · 22 stars
analytics SKILL.md skill
wankimmy/bossku-superpowers · skills/analytics/SKILL.md · When the user wants to set up, improve, or audit analytics tracking and measurement. Also use when the user mentions…
v2.0.0 · audit A · 22 stars
animate-expo SKILL.md skill
wankimmy/bossku-superpowers · skills/animate-expo/SKILL.md · Build animations in React Native and Expo, making the decisions in the order that determines whether they feel right —…
git:20260907.6a40a93 · audit A · 22 stars
animate SKILL.md skill
wankimmy/bossku-superpowers · skills/animate/SKILL.md · Build an animation from scratch, making the decisions in the order that determines whether it feels right — should it…
git:20260907.6a40a93 · audit A · 22 stars

Every file in wankimmy/bossku-superpowers

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