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

by MasahiroKawahara

Slide 1

Slide 1 text

%VDL%#.$1αʔόʔΛ࢖ͬͯ "84ίετΛ෼ੳͤͯ͞Έͨ

Slide 2

Slide 2 text

DBUBMLT ࣗݾ঺հ ઒ݪ੐େ LBXBIBSBNBTBIJSP ˔ $MBTTNFUIPEΫϥ΢υࣄۀຊ෦ίϯαϧςΟϯά෦ ˔ "845PQ&OHJOFFST d ˔ ࠷ۙ΍͍ͬͯΔ͜ͱ ˓ "84ϚϧνΞΧ΢ϯτ؀ڥͷηΩϡϦςΟՄࢹԽ ˓ ίετ࠷దԽ͍Ζ͍Ζ ˓ φϨοδαΠτͷӡӦ ˔ ޷͖ͳ͜ͱ ˓ πʔϦϯάɺ&NBDTɺѪೣͱٔΕΔ IUUQTEFWDMBTTNFUIPEKQBVUIPSLBXBIBSBNBTBIJSP

Slide 3

Slide 3 text

DBUBMLT %VDL%#.$1αʔόʔʹ͍ͭͯ࿩͠·͢ ˔ %VDL%#ͱ͸ʁΛαϥοͱઆ໌ ˔ %VDL%#.$1αʔόʔ࢖ͬͯΈͨ ˔ "84ίετ $63 Λ෼ੳ͢ΔϢʔεέʔεΛ঺հ

Slide 4

Slide 4 text

%VDL%#ͱ͸ʁ

Slide 5

Slide 5 text

DBUBMLT %VDL%#͸ΦϯϥΠϯ෼ੳॲཧ 0-"1 ʹಛԽͨ͠ σʔλϕʔεγεςϜ 引用: IUUQTEVDLECPSH

Slide 6

Slide 6 text

DBUBMLT ਺ίϚϯυͰɺ͙࢝͢ΊΒΕ·͢ 参考: IUUQTEVDLECPSHEPDTJOTUBMMBUJPO ( Windowsの場合: winget install DuckDB.cli )

Slide 7

Slide 7 text

DBUBMLT ͪΐͬͱͨ͠ϩά෼ੳ͸%VDL%#͕ͱͯ΋ศར

Slide 8

Slide 8 text

DBUBMLT .PUIFS%VDLެࣜͷ.$1αʔόʔ͕͋Γ·͢ ˔ .PUIFS%VDL ͸ %VDL%#ΛΫϥ΢υ্Ͱѻ͑Δ σʔλ΢ΣΞϋ΢εαʔϏε ˔ NDQTFSWFSNPUIFSEVDL ͸ ҎԼ%#ʹରͯ͠42-ΫΤϦΛ࣮ߦ͢ΔػೳΛఏڙ ˓ Ϋϥ΢υ.PUIFS%VDL ˓ ϩʔΧϧ%VDL%#⭐ IUUQTHJUIVCDPNNPUIFSEVDLECNDQTFSWFSNPUIFSEVDL

Slide 9

Slide 9 text

%VDL%#.$1αʔόʔݐͯͯΈͨ

Slide 10

Slide 10 text

DBUBMLT ಋೖํ๏͸ҎԼϒϩά͝ཡ͍ͩ͘͞ IUUQTEFWDMBTTNFUIPEKQBSUJDMFTNPUIFSEVDLEVDLECNDQXJUIDMBVEFDPEF

Slide 11

Slide 11 text

DBUBMLT ࠓճͷߏ੒͸͜Μͳײ͡

Slide 12

Slide 12 text

DBUBMLT ࢼ͠ʹαϯϓϧ$47Λूܭͯ͠΋Β͏ ෼ੳΛґཔɻ͍͖ͳΓٻΊΑ͏ͱͨ͠ͷͰࣦഊɻ ˠϑΝΠϧΛಡΜͰߏ଄Λ೺Ѳͯ͘͠Εͨɻ

Slide 13

Slide 13 text

DBUBMLT ࢼ͠ʹαϯϓϧ$47Λूܭͯ͠΋Β͏ ूܭΫΤϦΛ࣮ࢪͯ͠ɺਖ਼͍͠ग़ྗ͕ฦ͖ͬͯͨ

Slide 14

Slide 14 text

DBUBMLT .$1αʔόʔ͕ແ͔ͬͨΒɺ͍͍ͩͨؒҧ͑Δ

Slide 15

Slide 15 text

DBUBMLT OPUFੜ੒"*͸ܭࢉ͕ۤख ը૾Ҿ༻$IBU(15͸ͳͥܭࢉ͕ۤखͳͷ͔ ື ਅҰ ژ౎େֶେֶӃ৘ใֶݚڀՊ ڭत IUUQTFEYOJJBDKQMFDUVSF ෆنଇͳτʔΫϯྻ͔Β ๬·͍͠ग़ྗΛग़͢ͷ͸ࠔ೉

Slide 16

Slide 16 text

DBUBMLT OPUFੜ੒"*͸ܭࢉ͕ۤख ը૾Ҿ༻$IBU(15͸ͳͥܭࢉ͕ۤखͳͷ͔ ື ਅҰ ژ౎େֶେֶӃ৘ใֶݚڀՊ ڭत IUUQTFEYOJJBDKQMFDUVSF %VDL%#.$1αʔόʔ͸ ੜ੒"*͕ۤखͳ෦෼Λิͬͯ ͘ΕΔྑ͍πʔϧʂ ෆنଇͳτʔΫϯྻ͔Β ๬·͍͠ग़ྗΛग़͢ͷ͸ࠔ೉

Slide 17

Slide 17 text

"84ίετΛ෼ੳͯ͠ΈΔ XJUI"84$63

Slide 18

Slide 18 text

DBUBMLT $63ͱ͸ʁ ˠ"84ίετͷ࠷΋ࡉ͔͍৘ใ ˔ "84$PTUBOE6TBHF3FQPSUT$63 ˔ 1BSRVFU PS$47 ܗࣜͰอ؅͞ΕΔ ˔ ʮ࠷΋ࡉ͔͍ʯͷͰϘϦϡʔϛʔ ˓ ਺(#ϲ݄ Λ௒͑Δ͜ͱ΋͋Δ ˓ ྻ਺͸Ҏ্ શͯͷྻ৘ใΛऔͬͨ৔߹ ˔ ˠࣗવݴޠͰ෼ੳͰ͖Δͱخ͍͠ʂ

Slide 19

Slide 19 text

DBUBMLT $63Λجʹ"84ͷίετΛ෼ੳͤͯ͞ΈΔ ґཔޙɺ.$1αʔόʔ࣮ߦͷঝೝը໘

Slide 20

Slide 20 text

DBUBMLT $63Λجʹ"84ͷίετΛ෼ੳͤͯ͞ΈΔ .$1αʔόʔʹΑΔ ΫΤϦ αϯϓϦϯά ࣮ߦ

Slide 21

Slide 21 text

DBUBMLT $63Λجʹ"84ͷίετΛ෼ੳͤͯ͞ΈΔ ΫΤϦ ೔͝ͱͷूܭ ࣮ߦɻ݁ՌΛग़ྗͯ͘͠Εͨ

Slide 22

Slide 22 text

΋͏গ͠࢖ͬͯΈΔ

Slide 23

Slide 23 text

DBUBMLT ࣗવݴޠͷΈͰίετϨϙʔτ࡞ͬͯΈͨ

Slide 24

Slide 24 text

DBUBMLT ࣗવݴޠͷΈͰίετϨϙʔτ࡞ͬͯΈͨ $-"6%&NEϓϩδΣΫτϝϞϦ $MJOF΍ $VSTPSͰ͍͏ DMJOFSVMFTɺ DVSTPSSVMFT

Slide 25

Slide 25 text

DBUBMLT ࣗવݴޠͷΈͰίετϨϙʔτ࡞ͬͯΈͨ RVFSZΫΤϦΛ࠶ར༻ͤ͞Δ RVFSZSFTVMUϨϙʔτͷݩωλʹ͢Δ

Slide 26

Slide 26 text

DBUBMLT ࣗવݴޠͷΈͰίετϨϙʔτ࡞ͬͯΈͨ <༨ஊ>"84%PDVNFOUBUJPO.$14FSWFS Λซ༻ͯ͠ਪ঑ࣄ߲΋ग़ͯ͠ΈΔ

Slide 27

Slide 27 text

·ͱΊ

Slide 28

Slide 28 text

DBUBMLT %VDL%#.$1αʔόʔɺศརͰ͢ ˔ NDQTFSWFSNPUIFSEVDL ͸ .PUIFS%VDL Ϋϥ΢υ ΍ %VDL%# ϩʔΧϧ ʹରͯ͠ΫΤϦΛ ࣮ߦͰ͖Δ.$1αʔόʔ ˔ lੜ੒"*͕ۤखͳܭࢉॲཧz Λྑ͍ײ͡ʹิͬͯ͘ΕΔྑ͍πʔϧ ˔ ͍ͪϢʔεέʔεͱͯ͠ "84$63Λ෼ੳͯ͠Έ·ͨ͠ ˓ ࣗવݴޠͰ෼ੳͰ͖ΔͷͰɺίετ෼ੳͷϋʔυϧ͕Լ͕Δʂ

Slide 29

Slide 29 text

DBUBMLT ࢀߟࢿྉ ˔ "VUIFOUJDBUJOHUP.PUIFS%VDL .PUIFS%VDL ˔ .$1TFSWFSGPS%VDL%#BOE.PUIFS%VDL (JU)VC ˔ $IBU(15͸ͳͥܭࢉ͕ۤखͳͷ͔ ື ਅҰ ژ౎େֶେֶӃ৘ใֶݚڀՊ ڭत ˔ .PUIFS%VDL %VDL%# ͷ.$1αʔόʔΛಋೖͯ͠෼ੳͤͯ͞Έͨ XJUI$MBVEF$PEFc%FWFMPQFST*0

Slide 30

Slide 30 text

No content