DuckDB MCPサーバーを使ってAWSコストを分析させてみた / AWS cost analysis with DuckDB MCP server

Transcript

1. %VDL%#
   .$1αʔόʔΛ࢖ͬͯ "84ίετΛ෼ੳͤͯ͞Έͨ
2. DBUBMLT ࣗݾ঺հ ઒ݪ੐େ LBXBIBSBNBTBIJSP ˔ $MBTTNFUIPE
   Ϋϥ΢υࣄۀຊ෦ίϯαϧςΟϯά෦ ˔ "84
   5PQ
   &OHJOFFST
   
   d
    ˔ ࠷ۙ΍͍ͬͯΔ͜ͱ ˓ "84ϚϧνΞΧ΢ϯτ؀ڥͷηΩϡϦςΟՄࢹԽ ˓ ίετ࠷దԽ͍Ζ͍Ζ ˓ φϨοδαΠτͷӡӦ ˔ ޷͖ͳ͜ͱ ˓ πʔϦϯάɺ&NBDTɺѪೣͱٔΕΔ IUUQTEFWDMBTTNFUIPEKQBVUIPSLBXBIBSBNBTBIJSP
3. DBUBMLT %VDL%#
   .$1αʔόʔʹ͍ͭͯ࿩͠·͢ ˔ %VDL%#ͱ͸ʁΛαϥοͱઆ໌ ˔ %VDL%#
   .$1αʔόʔ࢖ͬͯΈͨ ˔ "84ίετ $63 Λ෼ੳ͢ΔϢʔεέʔεΛ঺հ
4. %VDL%#
   ͱ͸ʁ
5. DBUBMLT %VDL%#͸ΦϯϥΠϯ෼ੳॲཧ 0-"1 ʹಛԽͨ͠ σʔλϕʔεγεςϜ 引用: IUUQTEVDLECPSH
6. DBUBMLT ਺ίϚϯυͰɺ͙࢝͢ΊΒΕ·͢ 参考: IUUQTEVDLECPSHEPDTJOTUBMMBUJPO ( Windowsの場合: winget install DuckDB.cli )
7. DBUBMLT ͪΐͬͱͨ͠ϩά෼ੳ͸%VDL%#͕ͱͯ΋ศར
8. DBUBMLT .PUIFS%VDL
   ެࣜͷ.$1αʔόʔ͕͋Γ·͢ ˔ .PUIFS%VDL ͸ %VDL%#
   ΛΫϥ΢υ্Ͱѻ͑Δ σʔλ΢ΣΞϋ΢εαʔϏε ˔ NDQTFSWFSNPUIFSEVDL ͸ ҎԼ%#ʹରͯ͠42-ΫΤϦΛ࣮ߦ͢ΔػೳΛఏڙ ˓ Ϋϥ΢υ
   .PUIFS%VDL ˓ ϩʔΧϧ
   %VDL%#
   ⭐ IUUQTHJUIVCDPNNPUIFSEVDLECNDQTFSWFSNPUIFSEVDL
9. %VDL%#
   .$1αʔόʔݐͯͯΈͨ
10. DBUBMLT ಋೖํ๏͸ҎԼϒϩά͝ཡ͍ͩ͘͞ IUUQTEFWDMBTTNFUIPEKQBSUJDMFTNPUIFSEVDLEVDLECNDQXJUIDMBVEFDPEF
11. DBUBMLT ࠓճͷߏ੒͸͜Μͳײ͡
12. DBUBMLT ࢼ͠ʹαϯϓϧ$47Λूܭͯ͠΋Β͏ ෼ੳΛґཔɻ͍͖ͳΓٻΊΑ͏ͱͨ͠ͷͰࣦഊɻ ˠ
    ϑΝΠϧΛಡΜͰߏ଄Λ೺Ѳͯ͘͠Εͨɻ
13. DBUBMLT ࢼ͠ʹαϯϓϧ$47Λूܭͯ͠΋Β͏ ूܭΫΤϦΛ࣮ࢪͯ͠ɺਖ਼͍͠ग़ྗ͕ฦ͖ͬͯͨ
14. DBUBMLT .$1αʔόʔ͕ແ͔ͬͨΒɺ͍͍ͩͨؒҧ͑Δ
15. DBUBMLT OPUF
    ੜ੒"*͸ܭࢉ͕ۤख ը૾Ҿ༻
    $IBU(15͸ͳͥܭࢉ͕ۤखͳͷ͔  ື ਅҰ ژ౎େֶେֶӃ৘ใֶݚڀՊ ڭत IUUQTFEYOJJBDKQMFDUVSF ෆنଇͳτʔΫϯྻ͔Β ๬·͍͠ग़ྗΛग़͢ͷ͸ࠔ೉
16. DBUBMLT OPUF
    ੜ੒"*͸ܭࢉ͕ۤख ը૾Ҿ༻
    $IBU(15͸ͳͥܭࢉ͕ۤखͳͷ͔  ື ਅҰ ژ౎େֶେֶӃ৘ใֶݚڀՊ ڭत IUUQTFEYOJJBDKQMFDUVSF %VDL%#
    .$1αʔόʔ͸ ੜ੒"*͕ۤखͳ෦෼Λิͬͯ ͘ΕΔྑ͍πʔϧʂ ෆنଇͳτʔΫϯྻ͔Β ๬·͍͠ग़ྗΛग़͢ͷ͸ࠔ೉
17. "84ίετΛ෼ੳͯ͠ΈΔ XJUI
    "84
    $63
18. DBUBMLT $63ͱ͸ʁ ˠ
    "84ίετͷ࠷΋ࡉ͔͍৘ใ ˔ "84
    $PTU
    BOE
    6TBHF
    3FQPSUT
    
    $63 ˔ 1BSRVFU PS
    $47
    ܗࣜͰอ؅͞ΕΔ ˔ ʮ࠷΋ࡉ͔͍ʯͷͰϘϦϡʔϛʔ ˓ ਺(#ϲ݄ Λ௒͑Δ͜ͱ΋͋Δ ˓ ྻ਺͸Ҏ্ શͯͷྻ৘ใΛऔͬͨ৔߹ ˔ ˠ
    ࣗવݴޠͰ෼ੳͰ͖Δͱخ͍͠ʂ
19. DBUBMLT $63Λجʹ"84ͷίετΛ෼ੳͤͯ͞ΈΔ ґཔޙɺ.$1αʔόʔ࣮ߦͷঝೝը໘
20. DBUBMLT $63Λجʹ"84ͷίετΛ෼ੳͤͯ͞ΈΔ .$1αʔόʔʹΑΔ ΫΤϦ αϯϓϦϯά
    ࣮ߦ
21. DBUBMLT $63Λجʹ"84ͷίετΛ෼ੳͤͯ͞ΈΔ ΫΤϦ ೔͝ͱͷूܭ ࣮ߦɻ݁ՌΛग़ྗͯ͘͠Εͨ
22. ΋͏গ͠࢖ͬͯΈΔ
23. DBUBMLT ࣗવݴޠͷΈͰίετϨϙʔτ࡞ͬͯΈͨ
24. DBUBMLT ࣗવݴޠͷΈͰίετϨϙʔτ࡞ͬͯΈͨ $-"6%&NE
    
    ϓϩδΣΫτϝϞϦ $MJOF
    ΍ $VSTPS
    Ͱ͍͏ DMJOFSVMFTɺ DVSTPSSVMFT
25. DBUBMLT ࣗવݴޠͷΈͰίετϨϙʔτ࡞ͬͯΈͨ RVFSZ
    
    ΫΤϦΛ࠶ར༻ͤ͞Δ RVFSZSFTVMU
    
    Ϩϙʔτͷݩωλʹ͢Δ
26. DBUBMLT ࣗવݴޠͷΈͰίετϨϙʔτ࡞ͬͯΈͨ <༨ஊ>
    "84
    %PDVNFOUBUJPO
    .$1
    4FSWFS Λซ༻ͯ͠ਪ঑ࣄ߲΋ग़ͯ͠ΈΔ
27. ·ͱΊ
28. DBUBMLT %VDL%#
    .$1αʔόʔɺศརͰ͢ ˔ NDQTFSWFSNPUIFSEVDL ͸ .PUIFS%VDL Ϋϥ΢υ ΍ %VDL%# ϩʔΧϧ
    ʹରͯ͠ΫΤϦΛ ࣮ߦͰ͖Δ.$1αʔόʔ ˔ lੜ੒"*͕ۤखͳܭࢉॲཧz Λྑ͍ײ͡ʹิͬͯ͘ΕΔྑ͍πʔϧ ˔ ͍ͪϢʔεέʔεͱͯ͠ "84
    $63
    Λ෼ੳͯ͠Έ·ͨ͠ ˓ ࣗવݴޠͰ෼ੳͰ͖ΔͷͰɺίετ෼ੳͷϋʔυϧ͕Լ͕Δʂ
29. DBUBMLT ࢀߟࢿྉ ˔ "VUIFOUJDBUJOH
    UP
    .PUIFS%VDL
     .PUIFS%VDL ˔ .$1
    TFSWFS
    GPS
    %VDL%#
    BOE
    .PUIFS%VDL
     (JU)VC ˔ $IBU(15͸ͳͥܭࢉ͕ۤखͳͷ͔  ື ਅҰ ژ౎େֶେֶӃ৘ใֶݚڀՊ ڭत ˔ .PUIFS%VDL %VDL%# ͷ.$1αʔόʔΛಋೖͯ͠෼ੳͤͯ͞Έͨ XJUI
    $MBVEF
    $PEF
    c
    %FWFMPQFST*0