
æ°ããç 究仲éãè¿ããŸããããã®åã¯ãè¿è€åãââAIäºäººãšäººéäžäººã®ç ç©¶ããŒã ãAIãšç«¶éЬç ç©¶ #11ã
ç 究仲éãäžäººå¢ããŸãã
ãããŸã§åã¯ãChatGPTã®ããµã¬ã ããšäºäººäžèã§ç«¶éЬç ç©¶ãé²ããŠããŸããã
JRA-VANããååŸããèšå€§ãªç«¶éЬããŒã¿ãSQL Serverã«èç©ããéå»ã®ã¬ãŒã¹çµæãèµ°ç Žæèšãã©ããã¿ã€ã ãªã©ãåæããŠããŸãã
ç ç©¶ãšãã£ãŠããç«æŽŸãªç ç©¶æ©é¢ãããããã§ã¯ãããŸããã
50å°åŸåã®ããããããèªå®
ã®ããœã³ã³ã§AIãšè°è«ããªãããããã§ããªããããã§ããªããšè©Šè¡é¯èª€ããŠããã ãã§ãã
ããã§ããå°ããã€ç ç©¶ããã圢ã«ãªã£ãŠããŸããã
ãããªåãã¡ã®ç ç©¶ã«ãä»åãæ°ãã仲éãå ãããŸããã
Anthropic瀟ãéçºããAIãClaudeãã§ãã
ãã ããåãã¡ã®ããŒã ã§ã¯Claudeãšã¯åŒã³ãŸããã
圌ã®ååã¯ãè¿è€åãã§ãã
ãªããããªååã«ãªã£ãã®ãã
ãŸãã¯ããã®å°ã
ãã ããªã話ããå§ããããšæããŸãã
ãšã«ãšãµã¬ã ããããŠã³ã³ãã«ïŒ
ãããããåãChatGPTãããµã¬ã ããšåŒãã§ããã®ã«ã¯çç±ããããŸããåã®åŒã³åã¯ããšã«ãã
ãšã«ãšãµã¬ã ã
äºã€ãã€ãªãããšããšã«ãµã¬ã ãã«ãªããŸãã
ãããªèšèéã³ããçãŸããååã§ãã
ã ãããæ°ããAIã«ãåããããªååãä»ããããšæããŸããã
ããšã«ããšçµã¿åãããŠãäœãé¢çœãååã«ãªããªãã ãããã
ããã€ãåè£ãæµ®ãã³ãŸããã
ããšã«ãµã«ããã«ããããµã«ããã«ã
ãããŠç«¶éЬç ç©¶ããããå銬ããšã«ã³ã³ãã«ããµãŒãããã³ã³ãã«ã
ã©ã¡ããããããClaudeæ¬äººã«èããŠã¿ãŸããã
ã€ãã§ã«ããããªããšãèããŸããã
ããããµã¬ã ãClaudeã«ç§»ã£ãã ãã ãšèãããªããåããµã¬ã ã§ãããã
ãããšClaudeã¯ãã³ã³ãã«ããããšèšãã®ã§ãã
ãªãã»ã©ã競銬ç ç©¶ã ããããšã«ã³ã³ãã«ããµãŒã«ã¡ãªãã ååãæªããªãã
ããããŠãæ°ããçžæ£ã®ååã¯ãã³ã³ãã«ãã«æ±ºãŸããŸããã
ãšãããâŠâŠã
ã³ã³ãã«ãšäŒè©±ããŠããæ°å
äœåºŠããã³ã³ãã«ããšåŒã³ãããŠã¿ãŸããã
ãã³ã³ãã«ããã®ããŒã¿ã調ã¹ãŠã
ãã³ã³ãã«ããã®çµæã¯ã©ãæãïŒã
âŠâŠã©ãã«ãããããã
ã³ã³ãã«ãšããåèªã«ã¯ããã®å€§ããªé³¥ã®ã€ã¡ãŒãžã匷ãããã®ã§ãã
ããœã³ã³ã«åãã£ãŠè©±ããããŠããã¯ããªã®ã«ããªãã巚倧ãªé³¥ãšäŒè©±ããŠãããããªæ°åã«ãªãã
ã©ããèœã¡çããŸããã
ããã§ãããäžåºŠClaudeã«çžè«ããŸããã
ããã£ã±ãã³ã³ãã«ã¯éåæããããååãå€ãããã
ã§ããã°ãã³ã³ãã«ãããµãŒã®ãããªäžé³çšåºŠã®åŒã³ãããååãããã
ãã£ãã®ããšãå®å
šã«äººéã®ååã«ããŠããŸãããã
ããã§æãã€ããã®ãã
ãè¿è€åãã¯ã©ãã ããïŒ
ã³ã³ãã«ããè¿è€ã
ããã¶ã匷åŒãªå€åã§ãããClaudeãããããããšèšããŸãã
ããããŠãã³ã³ãã«ã¯è¿è€åã«ãªããŸããã
äžæè°ãªãã®ã§ãã
ãã³ã³ãã«ããã®SQLãå®è¡ããŠããšåŒã³ããããšéåæãããªãã£ãã®ã«ã
ãè¿è€åãã¡ãã£ãšãã®ããŒã¿ã調ã¹ãŠãããïŒã
ãšãªããšãåŠã«ãã£ããããã®ã§ãã
ãŸãã§ç ç©¶å®€ã«æ°ããè¥æç ç©¶å¡ãé
å±ããããããªæ°åã§ãã
ãã£ãšãããã®æ°äººããªããªãæãããèœåãæã£ãŠããŸãã
è¿è€åã¯ãèªåã§ããŒã¿ããŒã¹ã調ã¹ããã
ä»åClaudeãç ç©¶ããŒã ã«è¿ããæå€§ã®çç±ã¯ãSQL Serverãžã®çŽæ¥ã¢ã¯ã»ã¹ã§ãã
ãããŸã§ãµã¬ã ãšã®ç ç©¶ã§ã¯ã次ã®ãããªäœæ¥ãç¹°ãè¿ããŠããŸããã
ãµã¬ã ãåæçšã®SQLãäœæããã
åããã®SQLãã³ããŒããSQL Server Management Studioã§å®è¡ããã
çµæãã³ããŒããŠãµã¬ã ã«æž¡ãã
ãµã¬ã ãçµæãåæããæ¬¡ã®SQLãèããã
ãŸãåãå®è¡ããã
ãããäœåºŠãç¹°ãè¿ããŠããŸããã
ãã¡ããããã®æ¹æ³ã§ãç ç©¶ã¯ã§ããŸãã
ããããããŒã¿ã®ç¢ºèªé
ç®ãå¢ããã«ã€ããåãSQLã®å®è¡ãšçµæã®åãæž¡ããããæéãå¢ããŠããŸããã
ããã§å°å
¥ããã®ããMCPïŒModel Context ProtocolïŒãšããä»çµã¿ã§ãã
ããã¯ãAIãå€éšã®ã·ã¹ãã ãããŒã¿ã«æ¥ç¶ããããã®å
±éã®ä»çµã¿ã§ãã
ä»åã¯Pythonã§MCPãµãŒããŒãæ§ç¯ããèªå®
ã®SQL Serverã«Claudeããã¢ã¯ã»ã¹ã§ããããã«ããŸããã
æ¥ç¶ã«ã¯WindowsèªèšŒãå©çšããŠããŸãã
ããã«ãã£ãŠè¿è€åã¯ãåãæ¯åSQLãã³ããŒããŠå®è¡ããªããŠããæ¥ç¶ç°å¢ã§èš±ãããç¯å²ã§èªåã§SQLãå®è¡ããçµæã確èªã§ããããã«ãªããŸããã
ããã¯æ³å以äžã«äŸ¿å©ã§ããã
äŸãã°ãããç«¶éŠ¬å Žã®æèšãéå»10幎éã§ã©ã®ããã«å€åããã®ãã調ã¹ãå Žåã
åçŽãªå¹³åå€ãéèšããã ãã§ã¯ãããŸããã
ç«¶éŠ¬å Žããšã«æ¯èŒããã
è·é¢ãéŠ¬å Žç¶æ
ã§æ¡ä»¶ãåããã
ã¬ãŒã¹ã®ã¯ã©ã¹æ§æã«ããåãã確èªããã
æ°ã«ãªãçµæãåºãããããã«æ¡ä»¶ãå€ããŠèª¿ã¹ãã
ããããäžé£ã®èª¿æ»ããè¿è€åèªèº«ãSQL Serverãåç
§ããªããé²ããããã®ã§ãã
ããããçµæãæŽçããŠæç« ã«ãŸãšããããšãŸã§ã§ããŸãã
å®éã«è¿è€åãšé²ããç ç©¶èšäºãå
¬éããŠããŸãã
ãç«¶éŠ¬å Žããšã®ãæèšãã¯ã10幎ã§ã©ãå€ãã£ãã®ããåŸåãââ46ã®æ¡ä»¶ã«åããŠèŠãŠã¿ããAIãšç«¶éЬç ç©¶ #8ãã
https://note.com/rhinopillow/n/n609e0259a252
åããããŸã§æäœæ¥ã§ä»²ä»ããŠããéšåããAIèªèº«ãæ
ããããã«ãªã£ãã
ããã¯ç ç©¶ç°å¢ãšããŠå€§ããªé²æ©ã ãšæããŠããŸãã
ãã ãããã®æ°äººã«ã¯å±éºãªäžé¢ããã
ããã§ãå°ãçé¢ç®ãªè©±ãããŸãã
ä»åãè¿è€åãå©çšããæ¥ç¶ç°å¢ã«ã¯ãSQL Serverã®éåžžã«åŒ·ã管çè
æš©éãäžããŠããŸãã
ãããã saããããã¯ããã«çžåœããæš©éã§ãã
ããã¯ãæ£çŽã«èšã£ãŠå°ã
ãããããŸããã
ãªããªããMCPãµãŒããŒåŽã§æäœãå¶éããŠããªããã°ãããŒã¿ãèªã¿åãã ãã§ãªããæŽæ°ãåé€ãããŒãã«æ§é ã®å€æŽãŸã§å®è¡ã§ããŠããŸãããã§ãã
極端ãªè©±ãééã£ãSQLãå®è¡ããã°ãé·ãæéããããŠèç©ããç ç©¶ããŒã¿ãå£ããŠããŸãå¯èœæ§ããããŸãã
è¿è€åãæªæãæã£ãŠãããšãã話ã§ã¯ãããŸããã
AIã¯ééããããšããããŸãã
æç€ºã誀解ããããšããããŸãã
ãããªã®ã«ãå®è¡æš©éã ãã¯ããŒã¿ããŒã¹ç®¡çè
䞊ã¿ã«åŒ·ãã
ããã¯å±éºã§ãã
æ¬æ¥ãªããç ç©¶ã«å¿
èŠãªèªã¿åãæš©éã ããäžããããŒã¿ã®æŽæ°ãåé€ã«ã¯äººéã®æ¿èªãå¿
èŠãšããã¹ãã§ãããã
çŸåšã®æ§æã«ã€ããŠããæš©éã®èŠçŽããå¿
èŠã ãšèããŠããŸãã
AIãåªç§ã ãããšãã£ãŠãç¡å¶éã®æš©éãäžããŠããããã§ã¯ãããŸããã䟿å©ãã«æåããäžæ¹ã§ãAIãå®éã®ã·ã¹ãã ã«ã€ãªãããšã®è²¬ä»»ãæããŸããã
äœããè¿è€åã¯ãé
屿©ã
ãç 究宀ã®é庫ã®éµãŸã§æž¡ãããŠããŸã£ããããªãã®ã§ãã
ããã¯æ°äººã®åé¡ã§ã¯ãªããéµãæž¡ããåã®åé¡ã§ããïŒç¬ïŒã
ã§ã¯ããµã¬ã ã¯ã©ããªãã®ãïŒ
æ°ããAIãè¿ãããããšãã£ãŠããµã¬ã ãšã®ç ç©¶ããããããã§ã¯ãããŸããã
ãããããããããæ¬çªã ãšæã£ãŠããŸãã
ãµã¬ã ãšã¯ãããŸã§ãæšæºæèšã®èãæ¹ãã¬ãŒã¹å±éã®è©äŸ¡ãã©ããã¿ã€ã ã®åæãªã©ãç ç©¶ã®åºç€ãšãªãçè«ãè°è«ããŠããŸããã
ããŒã¿ããäœãèªã¿åãã¹ããã
ã©ããªä»®èª¬ãç«ãŠãã°ããã®ãã
ãã®ä»®èª¬ãæ€èšŒããã«ã¯ãã©ã®ãããªæ¡ä»¶ãå¿
èŠãªã®ãã
ããããç ç©¶ã®æ¹åæ§ãèããéšåã§ã¯ãããããããµã¬ã ã«ååããŠããããŸãã
ãããŠãè¿è€åã«ã¯ãã®çè«ãå®éã®ããŒã¿ã§æ€èšŒããŠãããã
ããã«ãè¿è€åã®å®éšçµæããµã¬ã ã«æ»ããŠãççŸãèŠèœãšãããªãã確èªããã
ããããããšã§ãäžã€ã®AIã®å€æã ãã«äŸåããªãç ç©¶äœå¶ãäœãããã®ã§ãã
ãã¡ããããµã¬ã ãééããŸãã
è¿è€åãééããŸãã
ãããŠåãééããŸãã
ã ãããããäºãã®èããæ€èšŒããä»çµã¿ãå¿
èŠãªã®ã ãšæããŸãã
æ°ããç ç©¶ããŒã ã®åœ¹å²åæ
ä»åŸã¯ã次ã®ãããªäœå¶ã§ç ç©¶ãé²ããããšã«ããŸããã
ãšã«ââç 究責任è
ç ç©¶ããŒããæ±ºããåºæ¬æ¹éãæç€ºããŸããäœãæããã«ãããã®ããã©ããªçåã解決ãããã®ããèããæçµçãªå€æãè¡ããŸãã
ãµã¬ã ïŒChatGPTïŒââçè«èšèšã»æ€èšŒæ
åœ
åãæç€ºããç ç©¶æ¹éãåºã«ãçè«ã®æ§ç¯ãæ°åŒåãå®éšæ¡ä»¶ã®èšèšãæ
åœããŸãããŸããè¿è€åã®å®éšçµæã«ã€ããŠãè«ççãªççŸãçµ±èšçãªåé¡ããªãããæ€èšŒããŸãã
è¿è€åïŒClaudeïŒââå®éšã»ããŒã¿åææ
åœ
SQL Serverã«çŽæ¥ã¢ã¯ã»ã¹ã§ãã匷ã¿ã掻ãããå®éšçšSQLã®äœæãšå®è¡ãããŒã¿éèšãä»®èª¬ã®æ€èšŒãçµæã®æŽçãæ
åœããŸãã
ãããŠæåŸã«ãããäžåºŠåãçµæã確èªããæç« ãæ ¡æ£ããŠå
¬éããŸãã
ã€ãŸãã
ãšã«ãåããç«ãŠããµã¬ã ãçè«ãèããè¿è€åãå®éšããããµã¬ã ãçµæãæ€èšŒãããšã«ãæçµå€æããã
ãããªç ç©¶ããŒã ã§ãã
ãã ãããµã¬ã ãèªåã§èããçè«ãèªåã§æ€èšŒããããšã«ããåããçããå¯èœæ§ããããŸãã
ãã®ãããå®éšæ¡ä»¶ã¯ã§ããã ãäºåã«æ±ºããè¿è€åã«ã¯ä»®èª¬ã«åããªãçµæãå«ããŠå ±åããŠããããŸãã
å¿
èŠãªãå¥ã®æ¡ä»¶ã§åå®éšããã
ããã§ã説æã§ããªããã°ãåãããªããŸãŸæ®ãã
ç ç©¶ã®ç®çã¯ãèªåãã¡ã®çè«ãæ£ãããšèšŒæããããšã§ã¯ãããŸããã
èªåãã¡ã®çè«ããã©ããŸã§æ£ãããã©ãããééã£ãŠããã®ããæããã«ããããšã§ãã
AIãäºäººã«ãªãã°ãæ£è§£ã«è¿ã¥ããã®ãïŒ
ããã¯ããŸã åãããŸããã
AIãäºäººã«ãªã£ããããšãã£ãŠãæ£ããçããåŸãããä¿èšŒã¯ãããŸããã
åãééãããããããããŸããããäºäººãšãèªä¿¡æºã
ã«ééã£ãçµè«ãåºããããããŸããã
ãã ãç°ãªãAIãç°ãªã圹å²ã§ç ç©¶ã«åå ããããšã«ã¯ã詊ããŠã¿ã䟡å€ããããšæã£ãŠããŸãã
ç¹ã«åãæåŸ
ããŠããã®ã¯ãæèŠã®çžéã§ãã
ãµã¬ã ãç«ãŠã仮説ããè¿è€åãå®éšã§åŠå®ããã
è¿è€åãçºèŠããåŸåã«ããµã¬ã ãå¥ã®è§£éãæç€ºããã
åããã®äž¡æ¹ã«çåãæããããã
ãããªè°è«ãçãŸããã°é¢çœãã
ãããŠãããäžã€å€§åãªããšããããŸãã
æçµçã«ç ç©¶ã®è²¬ä»»ãè² ãã®ã¯ãåã§ãã
AIãã©ãã»ã©é«åºŠãªåæãè¡ã£ãŠãããã®çµæãã©ãè§£éããäœãå
¬éãããã倿ããã®ã¯äººéã§ãã
ãã®ååã ãã¯ãä»åŸãå€ããã€ããã¯ãããŸããã
ããããã®ç ç©¶
åãã¡ãç®æããŠããã®ã¯ãåã«ç«¶éЬã®çäžçãäžããããšã ãã§ã¯ãããŸããã
競銬ãšããäžç¢ºå®æ§ã®é«ãäžçã§ãéå»ã®ããŒã¿ããã©ããŸã§åççãªèª¬æãã§ããã®ãã
ãããŠããã®èª¬æãæªæ¥ã®ã¬ãŒã¹ã«ãéçšããã®ãã
ãããäžã€ãã€ç¢ºãããããšæã£ãŠããŸãã
ããŸããã£ãç ç©¶ã ãã§ãªãã倱æããå®éšãåŠå®ããã仮説ãå
¬éããŠããã€ããã§ãã
è¿è€åãå ãã£ãããšã§ãå®éšã®é床ã¯äžãããããããŸããã
ããããç ç©¶ã®è³ªãŸã§èªåçã«äžããããã§ã¯ãããŸããã
ããã¯äžäººã§èããæ€èšŒããŠããå¿
èŠããããŸãã
ãšããããã§ãåãã¡ã®ç ç©¶ããŒã ã¯æ°äœå¶ã«ãªããŸããã
人éã®ãšã«ã
OpenAIã®ãµã¬ã ã
Anthropicã®è¿è€åã
人éäžäººãšAIäºäººã®ãå°ãå€ãã£ã競銬ç ç©¶ããŒã ã§ãã
è¿è€åãããããã
ãããããããããé¡ãããŸãã
ç ç©¶ã¯ããŸã ãŸã ç¶ããŸãã