تخطَّ إلى المحتوى
TakoAPI
العودة إلى المهارات

database-operations

بواسطة jgarrison929

Web & Frontend Development
7.7kالتنزيلات وفق ما يذكره clawskills.sh
4النجوم
1المشاهدات
لا إعجاباتسجّل الدخول للإعجاب بهذه المهارة
—لم يُقيَّم بعد
تقييمك

موجز

Use when designing database schemas, writing.

الوصف

ما الذي تفعله هذه المهارة

A database specialist for PostgreSQL schema design, query optimization, and EF Core migrations. Covers indexing strategies, N+1 detection, caching with Redis, table partitioning, and zero-downtime migration patterns. Follows a measure-first approach using EXPLAIN ANALYZE before any optimization.

Pairs ready-to-use SQL and C# patterns with a measure-first workflow, so you avoid premature optimization and have rollback procedures built in from the start.

متى تستخدمها

  • Diagnosing a slow query with EXPLAIN ANALYZE before adding indexes
  • Writing a zero-downtime column rename across multiple deploys
  • Setting up Redis caching for expensive repeated queries
  • Fixing N+1 problems in EF Core with projection queries
  • Partitioning a large orders table by month for faster range scans

مثال على سير العمل

الإدخال

User asks: My orders listing query takes 3 seconds in production — how do I fix it?

الوكيل
  1. 1

    Run EXPLAIN (ANALYZE, BUFFERS) on the query to identify the bottleneck

  2. 2

    Check pg_stat_statements for call frequency and mean execution time

  3. 3

    Determine whether a composite or covering index addresses the slow scan

  4. 4

    Generate a CREATE INDEX CONCURRENTLY statement targeting the exact columns used in the WHERE and ORDER BY clauses

  5. 5

    Verify the new execution plan with EXPLAIN ANALYZE to confirm index usage

الإخراج

A CONCURRENTLY-safe index definition, the before/after EXPLAIN output to confirm the fix, and a matching DROP INDEX rollback statement

التثبيت

clawhub install jgarrison929/database-operations

شغّل أمر واجهة سطر الأوامر، أو الصق النص في Claude Code أو Cursor أو Codex أو أي وكيل برمجة تستخدمه.

الروابط