MCPサーバーを活用したAWSコスト管理

20250807 Canly Tech Hub #1 発表資料

Transcript

1. MCP µüðü²ow AWS ³¹øûv j__»óúü ow 
2. ¯?}Ï ow  (Kaisei Arimura) j__»óúü SRE ñüð ¯wÿùóûó°, ²üð
3. oo~²¸·óð 1 AWS ³¹øV÷~ºÜ 2 V÷ÏÏ~}Ï 3 ~x±
4. AWS ³¹øV÷~ºÜ Cost Explorer {oo”tx~û}z³¹øV÷|ö÷ ³¹øxoöíüýüø(CUR) ¿¸ú²otV÷²¯v|\1Athena {wV ÷oöüöû²_ry»ß‰|r»2 ³ ëû~/u'߯³¹ø|{{»2 ³ MCP ôüû²svë~!
5. V÷ÏÏ~}Ï
6. oy»MCP ôüû MCP Server for DuckDB DuckDB ²{ow÷ü¿V÷ôüû ÷ü¿V÷´ÖŠ÷v{{W MCP Server for Vegalite ë°Wu¼÷ü¿²°ùõ{Yû
7. ÎÞßÿy»sx AWS {¹~¯u¼»³¹øxoöíüýüø(CUR) ²V÷w1ok³¹øüýüø²_rwt * CUR = CSV _wAWS ~º¯öí²û}{èw÷ü¿ Ï: [YYYYMMDD], [AWS ²»¶óø]], [AWS µüó¹]], [ {oo”], [ ~oý¯] ߉zïO~rÿ{²ory» ³¹øgùW~óh Ÿ›öåyÿ°ùõ
   
8. V÷d: ¯w¿ž{¹~÷ü¿ÿû 2025 ~6 o{ztv1AWS wg²{ou¼vt»NO3 µüó¹~ý¯Õ»x1û}z{oöí²CSV wû?wvOut2 ֊÷vMCP Server for DuckDB ²sv¯svput2
9. û?}ÿ 1-1 : NO3 µüó¹~³¹ø service,total_cost,usage_count AmazonCloudFront,5555.0,1111 AWSDataTransfer,4444.0,1111 AmazonRDS,3333.0,1111
10. û?}ÿ 1-2 : û}z{oo”tx~³¹ø Ï: CloudFront ~Ï item_description,total_cost data transfer out (Japan),4288.46 "HTTPS GET and HEAD requests in Japan",994.345 Tax for product code AmazonCloudFront,111.1111 data transfer out (United States),133.32 $0.xxx per GB - first 10 TB / month data transfer out,0.00001 "$0.xx per 10,000 Requests for HTTPS GET and HEAD requests in United States",0.000001
11. V÷eÿ³¹øgùWóh~¯×or V÷d wÿûw}ÿ²²x{1³¹øüýüø²_r y³zµüó¹wy~¸vz¿¼o²u¼vt»{1ys{³¹øZ_w|r»{²¯w¿žwV÷w}ÿ² û?wv€ut2
12. û?}ÿ 2-1 : ¯w¿ž{¸»³¹øüýüø # AWS ³¹øV÷üýüø ## V÷—: 2025 ~6 o1 o - 2025 ~6 o29 o ### µüó¹wû}V÷ #### 1. AmazonCloudFront ($5,555) ** z³¹ø‰ö:** - ÷ü¿î‘ý¯ÿoo
    : $4,288.46 (77.2%) - HTTPS ú¿¸¹øý¯: $994.345 (17.9%) - ÿ÷ü¿î‘: $133.32 (2.4%) ** gùWóh:** - ½óó·õ¯Û~gùW{¸º1ºú¸óµüðüx~ú¿¸¹øZ - ßö³óöóô~½óó·õ—þÿ - ß'×~w~'gùW #### 2. AWSDataTransfer ($4,444.00) ** z³¹ø‰ö:** - APN1 ÿ²¸²ñ·õ³ó¿
    ÷ü¿î‘: $2,693.06 (60.6%) - Àýüðûõúüö³²ÞV: $1,102.11 (24.8%) - wî³ðü¸û²î‘: $124.43 (2.8%) ** gùWóh:** - \/úü¸÷óÕw~÷ü¿î‘{Yö - ÷ü¿î‘ß~ZÿO‰z÷ü¿~Zö
    - w~âÛ~o ~~~~~~( ïOu)
13. V÷f: ÷ü¿~ÿŸW MCP Server for Vegalite ²otv1CloudFront ~³¹ø²ý¯Õ»tx{ú°ùõwû?wvput2
14. û?}ÿ3 CloudFront ~owý¯°ùõ
15. ~x±
16. ~x± | MCP µüð²oy»{ù }[wû÷ö ¯w¿žwV÷÷ü¿²_rw} »~w1¿¸ú²ƒxºV÷ÿ ö²ëûy»?—²Zw}» kúz÷ü¿ DuckDB {¸» ¿¸úùü¹~V÷wAI ~æ?z Šÿ÷v²kú{߯ Ÿ›öz÷ü¿_r ³¹ø·³~Ïý_r{²x» Àùõ²û?ÿý
17. Îß~] CSV ´JSON zy~_w³¹ø²ÿûw}¼p1w¿ù¶ùµüó¹w ²oÿý ¿ù¶ùµüó¹{{WwMCP µüðüx}\¿¹1³¹øgù Wóh~î|N|º}v
18. rº|xvtvt~w