Class: Profiler::MCP::Tools::AnalyzeQueries

Inherits:
Object
  • Object
show all
Defined in:
lib/profiler/mcp/tools/analyze_queries.rb

Class Method Summary collapse

Class Method Details

.analyze_and_format(queries, summary_only: false) ⇒ Object 



58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
 
# File 'lib/profiler/mcp/tools/analyze_queries.rb', line 58

def self.analyze_and_format(queries, summary_only: false)
  lines = []
  lines << "# SQL Query Analysis\n"

  slow_threshold = Profiler.configuration.slow_query_threshold
  slow_queries = queries.select { |q| q["duration"] > slow_threshold }
  query_counts = queries.group_by { |q| normalize_sql(q["sql"]) }
                       .transform_values { |qs| { count: qs.size, backtrace: qs.first["backtrace"] || [] } }
                       .select { |_, v| v[:count] >= 3 }

  unless summary_only
    # Detect slow queries
    if slow_queries.any?
      lines << "## ⚠️ Slow Queries (> #{slow_threshold}ms)"
      lines << "Found #{slow_queries.size} slow queries:\n"

      slow_queries.first(5).each_with_index do |query, index|
        lines << "### Query #{index + 1} - #{query['duration'].round(2)}ms"
        lines << "```sql"
        lines << query["sql"]
        lines << "```\n"
      end

      lines << "_... and #{slow_queries.size - 5} more slow queries_\n" if slow_queries.size > 5
    else
      lines << "## ✅ No Slow Queries"
      lines << "All queries executed in less than #{slow_threshold}ms\n"
    end

    # Detect duplicate queries (potential N+1, threshold: ≥ 3 occurrences)
    if query_counts.any?
      lines << "## ⚠️ Duplicate Queries (Potential N+1)"
      lines << "Found #{query_counts.size} query pattern(s) repeated 3+ times:\n"

      query_counts.sort_by { |_, v| -v[:count] }.first(5).each do |sql, v|
        lines << "### Executed #{v[:count]} times:"
        lines << "```sql"
        lines << sql
        lines << "```"
        if v[:backtrace].any?
          lines << "#### Called from:"
          v[:backtrace].first(3).each { |frame| lines << "  #{frame}" }
        end
        lines << ""
      end

      lines << "_... and #{query_counts.size - 5} more duplicate patterns_\n" if query_counts.size > 5
    else
      lines << "## ✅ No Duplicate Queries"
      lines << "No query pattern repeated 3+ times\n"
    end
  end

  # Summary statistics always included
  lines << "## Summary Statistics"
  lines << "- **Total Queries:** #{queries.size}"
  lines << "- **Total Duration:** #{queries.sum { |q| q['duration'] }.round(2)}ms"
  lines << "- **Average Duration:** #{(queries.sum { |q| q['duration'] } / queries.size).round(2)}ms"
  lines << "- **Slow Queries:** #{slow_queries.size}"
  lines << "- **N+1 Patterns (≥3×):** #{query_counts.size}"
  lines << "- **Cached Queries:** #{queries.count { |q| q['cached'] }}"

  lines.join("\n")
end

.call(params) ⇒ Object 



9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
 
# File 'lib/profiler/mcp/tools/analyze_queries.rb', line 9

def self.call(params)
  token = params["token"]
  unless token
    return [
      {
        type: "text",
        text: "Error: token parameter is required"
      }
    ]
  end

  storage = MCP::SlaveSupport.resolve_storage(params)
  profile = if token == "latest"
    storage.list(limit: 1).first
  else
    storage.load(token)
  end
  unless profile
    return [
      {
        type: "text",
        text: "Profile not found: #{token}"
      }
    ]
  end

  db_data = profile.collector_data("database")
  unless db_data && db_data["queries"]
    return [
      {
        type: "text",
        text: "No database queries found in this profile"
      }
    ]
  end

  summary_only = params["summary_only"] == true || params["summary_only"] == "true"
  text = analyze_and_format(db_data["queries"], summary_only: summary_only)

  [
    {
      type: "text",
      text: text
    }
  ]
end

.normalize_sql(sql) ⇒ Object 



123
124
125
126
127
128
129
 
# File 'lib/profiler/mcp/tools/analyze_queries.rb', line 123

def self.normalize_sql(sql)
  sql.gsub(/\$\d+/, "?")
     .gsub(/\b\d+\b/, "?")
     .gsub(/'[^']*'/, "?")
     .gsub(/"[^"]*"/, "?")
     .strip
end