Skills database-fundamentals
📦

database-fundamentals

Content revision r1 Safe ⚙️ External commands

Review Database Design Safely

Database changes can create slow queries, data loss, and unsafe migrations. This skill guides Claude, Codex, and Claude Code through schema, query, index, ORM, and migration reviews.

Supports: Claude Codex Code(CC)
🥉 78 Bronze

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "database-fundamentals" from https://skillstore.io/skills/danielpodolsky-database-fundamentals.md and its manifest at https://skillstore.io/api/skills/danielpodolsky-database-fundamentals/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/danielpodolsky-database-fundamentals.md Signed manifest GET /api/skills/danielpodolsky-database-fundamentals/manifest Signed lockfile GET /api/skills/danielpodolsky-database-fundamentals/lockfile

Test it

Using "database-fundamentals". Review a pull request that adds an orders table and several order lookup queries.

Expected outcome:

  • Schema review notes covering keys, foreign key behavior, and data types.
  • Index recommendations for user and status lookup patterns.
  • Questions about rollback plans and expected row counts.

Using "database-fundamentals". Assess an ORM endpoint that fetches users and then loads related records per user.

Expected outcome:

  • N+1 risk explanation written for the reviewer.
  • Suggested eager-loading or batched query approach.
  • Checks for selected fields, pagination, and query limits.

Using "database-fundamentals". Review a migration that removes a column after introducing a replacement column.

Expected outcome:

  • Migration safety checklist for staged rollout.
  • Rollback and verification questions.
  • Warnings about data copying, backfills, and delayed deletion.

Security Audit

Safe
v8 • 7/6/2026 Open versioned report

I found no executable behavior in the skill. All static command and reconnaissance alerts are false positives caused by Markdown code fences, inline SQL examples, and educational ORM snippets; no prompt injection or data exfiltration intent was found.

1
Files scanned
224
Lines analyzed
0
Review items
0
False positives ignored

Risk Factors

⚙️ External commands (16)
SKILL.md:42 SKILL.md:58-74 SKILL.md:74-77 SKILL.md:77-84 SKILL.md:84-87 SKILL.md:87-91 SKILL.md:91-94 SKILL.md:94-95 SKILL.md:95-98 SKILL.md:98-101 SKILL.md:101-113 SKILL.md:113-133 SKILL.md:133-147 SKILL.md:147-160 SKILL.md:160-201 SKILL.md:201-223
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/danielpodolsky-database-fundamentals/audits/8?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/danielpodolsky-database-fundamentals/security.svg)](https://skillstore.io/skills/danielpodolsky-database-fundamentals?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/danielpodolsky-database-fundamentals?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/danielpodolsky-database-fundamentals/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/danielpodolsky-database-fundamentals.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

DanielPodolsky. (2026). database-fundamentals security audit report (audit version 8) [Author version unspecified]. Skillstore. https://skillstore.io/skills/danielpodolsky-database-fundamentals/audits/8

BibTeX citation

@techreport{danielpodolsky-danielpodolsky-database-fundamentals-2026, author = {DanielPodolsky}, title = {database-fundamentals security audit report (audit version 8)}, institution = {Skillstore}, year = {2026}, number = {8}, url = {https://skillstore.io/skills/danielpodolsky-database-fundamentals/audits/8}, note = {Author version unspecified} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "database-fundamentals security audit report (audit version 8)" version: "unspecified" type: report authors: - name: "DanielPodolsky" date-released: "2026-07-06" url: "https://skillstore.io/skills/danielpodolsky-database-fundamentals/audits/8" identifiers: - type: other value: "skillstore:danielpodolsky-database-fundamentals:audit:8" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
85
Maintainability
87
Content
71
Community
83
Spec Compliance

What You Can Build

Review a migration plan

Check whether schema changes are reversible, incremental, tested, and safe for existing data.

Mentor a junior developer

Use focused questions to teach database tradeoffs without simply giving answers.

Audit ORM query patterns

Find N+1 access, broad field selection, missing pagination, and unsafe raw query construction.

Try These Prompts

Check my schema basics 
Review this database schema for primary keys, foreign keys, data types, normalization, and obvious missing constraints.
Review this query change 
Review this query or ORM change for N+1 access, SELECT *, missing pagination, parameterization, and index needs.
Plan a safer migration 
Evaluate this migration plan for rollback safety, data preservation, incremental rollout, test coverage, and deployment risk.
Evaluate a database-heavy pull request 
Review this pull request using database fundamentals. Prioritize correctness, performance, migration safety, and questions I should ask the author.

Best Practices

  • Provide the schema, query intent, expected data size, and database engine when asking for review.
  • Ask for risks and reviewer questions before asking for a final recommendation.
  • Pair this skill with real query plans and production metrics for performance decisions.

Avoid

  • Do not ask it to approve destructive migrations without rollback and data verification details.
  • Do not treat general index advice as a substitute for measuring real query plans.
  • Do not paste secrets, production credentials, or private customer data into review prompts.

Frequently Asked Questions

Does this skill run database commands?
No. It provides review guidance and examples. It does not connect to databases or execute queries by itself.
Can it review both SQL and ORM code?
Yes. The guidance covers SQL query patterns, ORM model usage, eager loading, field selection, and pagination.
Is it specific to one database engine?
No. It focuses on general relational database fundamentals, so engine-specific tuning still needs local expertise.
Can it help with NoSQL design?
It can help with general data modeling questions, but most examples and checks are relational database oriented.
How should I use it during code review?
Share the relevant schema, migration plan, query intent, and expected access patterns. Ask for risks and reviewer questions.
Does it replace performance testing?
No. Use it to identify likely issues, then validate important choices with query plans, load tests, and monitoring data.

Developer Details

License

MIT

Skillstore revision

r1

Version notice

The author did not declare a version.

Repository

https://github.com/DanielPodolsky/mentor-spec/tree/main/.claude/skills/fundamentals/database

Ref

34f316ba14ef36c7a620fc09f2676d2429997a77

Maintenance freshness

7/18/2026

Usage

5 downloads · 251 views

File structure

📄 SKILL.md