कंटेंट पर जाएँ
TakoAPI
स्किल्स पर वापस

database-operations

jgarrison929 द्वारा

Web & Frontend Development
7.7kclawskills.sh द्वारा बताए गए डाउनलोड
4स्टार
1व्यूज़
0 लाइकइस स्किल को लाइक करने के लिए साइन इन करें
—अभी तक कोई रेटिंग नहीं
आपकी रेटिंग

संक्षिप्त

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

CLI कमांड चलाएँ, या प्रॉम्प्ट को Claude Code, Cursor, Codex या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।

लिंक