Skills db-handler
📦

db-handler

Content revision r1 Medium Risk ⚙️ External commands

Manage Drizzle Database Changes

Database schema changes can create data loss, slow queries, or inconsistent Drizzle definitions. This skill guides Claude, Codex, and Claude Code through structured schema design, relations, indexes, and review steps.

Supports: Claude Codex Code(CC)
📊 70 Adequate

Install with my Agent

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

Agent request
Review the Skillstore skill "db-handler" from https://skillstore.io/skills/aayushbaniya2006-db-handler.md and its manifest at https://skillstore.io/api/skills/aayushbaniya2006-db-handler/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/aayushbaniya2006-db-handler.md Signed manifest GET /api/skills/aayushbaniya2006-db-handler/manifest Signed lockfile GET /api/skills/aayushbaniya2006-db-handler/lockfile

Test it

Using "db-handler". Create a subscriptions table linked to users and plans.

Expected outcome:

A proposed table design with key fields, user and plan relations, index recommendations, and a confirmation question before applying changes.

Using "db-handler". Our dashboard loads users and their posts slowly.

Expected outcome:

A performance review that identifies likely N+1 access, recommends relation loading or joins, and lists indexes for common filters.

Using "db-handler". Add settings to each organization record.

Expected outcome:

A safe column plan that recommends JSONB validation, nullable rollout options, and checks for production migration risk.

Security Audit

Medium Risk
v9 • 7/5/2026 Open versioned report

Most static detections are false positives caused by Markdown code spans for file paths, identifiers, and examples. One finding is confirmed because the skill instructs agents to run npx drizzle-kit push, and a semantic concern is direct schema synchronization without migration review. No prompt injection or data exfiltration intent was found.

2
Files scanned
116
Lines analyzed
1
Review items
0
False positives ignored

Confirmed security concerns (1)

Medium
SKILL.md:19-20
Direct Database Schema Push Without Migration Review
The skill instructs agents to avoid generated migrations and use npx drizzle-kit push to sync schema changes directly. This can alter database structure without an auditable migration file or production review.
The workflow is stated directly in adjacent instructions. It is not evidence of malicious intent, but it is a concrete database integrity risk.
Capability review items (1)

These are real local capabilities that may be expected for this skill, so they require review but are not counted as confirmed malicious behavior.

Medium
SKILL.md:20
Ruby/shell backtick execution
- **DO** use `npx drizzle-kit push` to sync schema changes directly to the database.
The instruction tells the agent to run npx drizzle-kit push, which executes project tooling and can mutate the connected database. This creates integrity and availability risk without explicit safeguards.

Risk Factors

⚙️ External commands (9)
SKILL.md:13 SKILL.md:16 SKILL.md:19 SKILL.md:20 SKILL.md:24 SKILL.md:25 SKILL.md:26 SKILL.md:29 SKILL.md:36
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/aayushbaniya2006-db-handler/audits/9?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/aayushbaniya2006-db-handler/security.svg)](https://skillstore.io/skills/aayushbaniya2006-db-handler?utm_source=security_passport_badge)

HTML badge

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

Embed card

<iframe src="https://skillstore.io/embed/skills/aayushbaniya2006-db-handler.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

AayushBaniya2006. (2026). db-handler security audit report (audit version 9) [Author version unspecified]. Skillstore. https://skillstore.io/skills/aayushbaniya2006-db-handler/audits/9

BibTeX citation

@techreport{aayushbaniya2006-aayushbaniya2006-db-handler-2026, author = {AayushBaniya2006}, title = {db-handler security audit report (audit version 9)}, institution = {Skillstore}, year = {2026}, number = {9}, url = {https://skillstore.io/skills/aayushbaniya2006-db-handler/audits/9}, 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: "db-handler security audit report (audit version 9)" version: "unspecified" type: report authors: - name: "AayushBaniya2006" date-released: "2026-07-05" url: "https://skillstore.io/skills/aayushbaniya2006-db-handler/audits/9" identifiers: - type: other value: "skillstore:aayushbaniya2006-db-handler:audit:9" 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

Create a new domain table

Plan a Drizzle table with fields, relations, indexes, and review questions before implementation.

Review schema change safety

Check a planned column or relation change for migration risk, compatibility, and confirmation needs.

Improve relational query performance

Identify missing indexes and N+1 query patterns when related data loads slowly.

Try These Prompts

Draft a Table 
Use db-handler to draft a Drizzle table for [entity]. Include UUID IDs, timestamps, relations, and indexes. Ask before any database push.
Modify Columns Safely 
Use db-handler to update [table] with [new fields]. Prefer nullable fields or defaults, and identify any breaking change risks.
Optimize Related Data Loading 
Use db-handler to review [query flow]. Find N+1 patterns, missing indexes, and better relation loading options.
Plan Production Migration Review 
Use db-handler to evaluate this schema change for production. List data risks, rollback concerns, confirmation steps, and migration review needs.

Best Practices

  • Confirm the target environment before syncing or migrating schema changes.
  • Index foreign keys, frequent filters, and common sort fields when designing tables.
  • Define JSONB validation with Zod before storing structured settings.

Avoid

  • Running schema push commands before the user confirms the table design.
  • Adding JSONB fields for unrelated data that should be normalized.
  • Fetching related records inside loops instead of loading them in one query.

Frequently Asked Questions

Can this skill change my database automatically?
It can suggest schema commands, but changes should require explicit user confirmation and project access.
Does it support Drizzle ORM?
Yes. The instructions focus on Drizzle ORM tables, relations, indexes, and relational query patterns.
Can Claude Code use this skill?
Yes. It is described for Claude, Codex, and Claude Code workflows.
Does it create migration files?
The skill discourages generated migrations, so production users should add their own migration review process.
Does it handle JSONB columns?
Yes. It requires Zod schema guidance for JSONB columns before storing structured data.
When should I use it?
Use it when planning tables, relations, indexes, schema updates, or Drizzle query performance improvements.

Developer Details

License

MIT

Skillstore revision

r1

Version notice

The author did not declare a version.

Repository

https://github.com/AayushBaniya2006/blinkfund/tree/main/.claude/skills/db-handler

Ref

a29db30e42179ff8ed4d95c9dfba3704c22643d0

Maintenance freshness

7/18/2026

Usage

12 downloads · 290 views

File structure

📄 reference.md

📄 SKILL.md