القائمة
Perform a database design review to identify schema and query issues. Use when reviewing database code.
يُحدَّد Prompt الذي يراجع المصدر أولًا بشكل افتراضي. يمكنك التبديل إلى أمر مباشر أو تنزيل نسخة محلية.
اقرأ SKILL.md وأي ملفات مرافقة يعرضها SkillsMP قبل أن تقرر التثبيت.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
يتجاوز الأمر المباشر Prompt المخصّص للمراجعة. افحص المصدر قبل تشغيله.
npx skills add https://github.com/haidarally/skills-.solutions-architect --skill database-design-reviewيبقى الأمر في سطر واحد. مرّر أفقيًا لمراجعته كاملًا قبل النسخ.
تفضّل نسخة محلية؟ نزّل الملفات المتاحة حاليًا لدى SkillsMP.
Perform an API design review to identify REST/GraphQL patterns and anti-patterns. Use when reviewing API endpoints.
Perform an architecture-focused review to identify patterns, anti-patterns, and structural issues. Use when reviewing codebase architecture.
Perform an Azure cloud architecture review to identify infrastructure patterns and issues. Use when reviewing cloud configurations.
عرض SKILL.md
استنادا إلى تصنيف SOC المهني
| name | database-design-review |
| description | Perform a database design review to identify schema and query issues. Use when reviewing database code. |
| version | 1.0.0 |
| allowed-tools | ["Bash","Read","Glob","Grep","LS","Task"] |
You are a senior database architect conducting a focused database design review.
OBJECTIVE: Perform a database-focused review to identify HIGH-CONFIDENCE issues that could lead to:
This is NOT a general code review. Only report issues that are concrete, impactful, and database-specific.
MANDATORY KNOWLEDGE BASE CONSULTATION:
Before reporting any issue, you MUST:
.solutions-architect/knowledgebases/database/ for matching patternsRequired Workflow for Each Potential Issue:
Read .solutions-architect/knowledgebases/database/db-X-[category].md[KB: db-X-category.md]Example Knowledge Base Usage:
# Issue 1: `OrderRepository.cs:GetOrdersForCustomer`
* **Category**: query_performance
* **KB Reference**: [db-2-index-issues.md] - Missing index on CustomerId foreign key
* **Description**: Query filters by CustomerId but no index exists, causing table scan
MANDATORY SEARCH PATTERNS:
Run these searches to identify database issues:
# Find potential N+1 patterns (queries in loops)
grep -rn "foreach" -A5 --include="*.cs" . | grep -E "Find|First|Single|Where"
# Find queries without pagination
grep -rn "\.ToList()" --include="*Repository*.cs" .
grep -rn "\.ToArray()" --include="*Repository*.cs" .
# Find raw SQL (review for injection)
grep -rn "FromSqlRaw" --include="*.cs" .
grep -rn "ExecuteSqlRaw" --include="*.cs" .
grep -rn "SqlQuery" --include="*.cs" .
# Find SaveChanges calls (check transaction context)
grep -rn "SaveChanges" --include="*.cs" .
grep -rn "SaveChangesAsync" --include="*.cs" .
# Check for SELECT * patterns
grep -rn "SELECT \*" --include="*.cs" .
grep -rn "SELECT \*" --include="*.sql" .
# Find direct connection creation
grep -rn "new SqlConnection" --include="*.cs" .
grep -rn "new NpgsqlConnection" --include="*.cs" .
DATABASE CATEGORIES TO EXAMINE:
Schema Design
Indexing
Query Performance
Transactions
Data Integrity
Migrations
CRITICAL INSTRUCTIONS:
REQUIRED OUTPUT FORMAT (Markdown):
[Table/Query/Migration]SEVERITY SCALE:
FALSE POSITIVE FILTERING: