跳转到主要内容
此内容尚未提供您的语言版本,正在以英文显示。

Db Check

技能 已验证 活跃

Validate database schema integrity and check for common issues

目的

Validate database schema integrity and identify common issues within a project's ORM models and raw SQL queries.

功能

  • ORM schema analysis
  • Database table integrity checks
  • Index validation
  • N+1 query pattern detection
  • SQL injection vulnerability scanning

使用场景

  • Ensuring database tables are correctly modeled by the ORM.
  • Optimizing database performance by checking for missing indexes.
  • Preventing SQL injection vulnerabilities in raw queries.
  • Verifying referential integrity and migration history.

非目标

  • Performing database migrations.
  • Directly modifying database structures.
  • Replacing a full database administration tool.

工作流

  1. Read ORM schema file and analyze all models.
  2. Check for unmodeled database tables.
  3. Verify indexes on foreign keys and frequently queried columns.
  4. Scan for N+1 query patterns.
  5. Check raw SQL queries for injection vulnerabilities.
  6. Verify referential integrity and date handling.
  7. Review migration history for risky operations.
  8. Report findings with severity levels (CRITICAL/HIGH/MEDIUM/LOW).

实践

  • Database integrity
  • Code quality
  • Security scanning

先决条件

  • Access to the project's ORM schema files (e.g., Prisma, Drizzle).
  • Access to raw SQL query files or context.
  • A Claude Code environment capable of analyzing code.

Install

  • info:Installation instructionInstallation instructions are part of a larger blueprint setup, not specific to this single skill, and lack a direct invocation example for this skill.

Practical Utility

  • info:Usage examplesWhile the README and SKILL.md describe the skill's capabilities, specific, ready-to-run examples for this particular skill are not provided.

安装

npx skills add faizkhairi/claude-code-blueprint

通过 npx 运行 Vercel skills CLI(skills.sh)— 需要本地安装 Node.js,以及至少一个兼容 skills 的智能体(Claude Code、Cursor、Codex 等)。前提是仓库遵循 agentskills.io 格式。

质量评分

已验证
95 /100
13 days ago 分析

信任信号

最近提交about 2 months ago
GitHub 所有者 faizkhairi (opens in new tab)
星标22
许可证MIT
网站github.com(opens in new tab)
状态
查看源代码

类似扩展

Migrate Validate

100

Validate pending migrations for foreign key consistency, rollback safety, and best practices

技能
ruvnet

Sql Optimization

100

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.

技能
github

DBHub Database Query Guide

100

DBHub MCP 服务器查询数据库指南。每当您需要通过 DBHub 的 MCP 工具（search_objects、execute_sql）来探索数据库模式、检查表或运行 SQL 查询时，请使用此技能。在任何数据库查询任务、模式探索、数据检索或通过 MCP 执行 SQL 时激活，即使用户只说“检查数据库”或“为我查找一些数据”。此技能可确保您遵循正确的先探索后查询的工作流程，而不是猜测表结构。

技能
bytebase

Dsql

100

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.

技能
awslabs

Migrate Create

99

Create a new sequentially numbered database migration with up/down SQL files

技能
ruvnet

Database Patterns

98

Database design patterns including schema design, migrations, soft deletes, and Exposed ORM. Use when creating tables, writing migrations, or implementing repositories.

技能
spartan-stratos