ãã¬ãŒã³è±èªã§ããŒã¿ããŒã¹ãã¯ãšãªãã管çãã
SQL ããŒã¿ããŒã¹ãæ±ãå Žåãéåžžã¯ããŒã¿ããŒã¹ã¯ã©ã€ã¢ã³ããåãæ¿ããæäœæ¥ã§ã¯ãšãªãæžããæ§æãæ£ããããšãç¥ãå¿ èŠããããŸãããšã³ã¿ãŒãã©ã€ãºå¯Ÿå¿ã® SQL MCP ãæèŒãã Eigent ã® SQL Agent ã䜿ãã°ãèªç¶èšèªã§ããŒã¿ããŒã¹ãæäœã§ããŸãããã®ã¯ãŒã¯ãããŒã§ã¯ãEigent ãæ¥ç¶å ã®ããŒã¿ããŒã¹ãç¹å®ããã¢ãã¯ããŒã¿ããŒãã«ãäœæãã1è¡ãæŽæ°ããããã« GROUP BY ã¯ãšãªãå®è¡ããŸãããã¹ãŠã 1 ã€ã®äŒè©±åããã³ããããè¡ããŸãã
SQL MCP ã«æ¥ç¶ãã
ãã®ã¯ãŒã¯ãããŒãå®è¡ããåã«ãEigent ã®èšå®ã§ SQL MCP ãæ§æãããŠããããšã確èªããŠãã ãããSettings â Connectors â SQL ã«ç§»åããããŒã¿ããŒã¹æ¥ç¶æ å ±ïŒhostãportãdatabase nameãcredentialsïŒãå ¥åããŸããEigent 㯠PostgreSQLãMySQLãSQLiteããã®ä»ã®äžè¬çãªããŒã¿ããŒã¹ããµããŒãããŠããŸãã
æ¥ç¶ãããšãSQL Agent ããªã¯ãšã¹ããè§£éããã©ã€ãããŒã¿ããŒã¹ã«å¯ŸããŠé©åãªã¯ãšãªãå®è¡ã§ããããã«ãªããŸãã
SQL ã¿ã¹ã¯ã®ããã³ãããæžã
SQL ãæžãå¿ èŠã¯ãããŸãããããããããšããã®ãŸãŸèª¬æããã ãã§ãã
SQL Agent ã«æ¬¡ã®ããã«å°ããŠãã ãããã©ã® SQL ããŒã¿ããŒã¹ã«æ¥ç¶ããŠããŸããïŒ åŠçããŒã¿çšã« 10 è¡ã»10 åã®ã¢ãã¯ããŒãã«ã 1 ã€äœæãããã®åŸ 2 è¡ç®ãæŽæ°ããŠãSQL ã§ããŒã¿ãã°ã«ãŒãåããŠãã ããã
Eigent ã¯ãããã®æäœãé çªã«åŠçããŸããæ¥ç¶ã¡ã¿ããŒã¿ã®ååŸãããŒãã«äœæãã¢ãã¯ããŒã¿ã®æ¿å ¥ãæŽæ°ã®å®è¡ããããŠã°ã«ãŒãåã§ãã
Eigent ãããŒã¿ããŒã¹ãç¹å®ãã
SQL Agent ã¯ãŸãããŒã¿ããŒã¹ã®ã¡ã¿ããŒã¿ãã¯ãšãªããã©ã®ããŒã¿ããŒã¹ã«æ¥ç¶ãããŠããããã©ã®ã¹ããŒããå©çšå¯èœãã確èªããŸããããŒã¿ããŒã¹ã®çš®é¡ãããŒãžã§ã³ãçŸåšã®ã¹ããŒããè¿ããããããæäœãå®è¡ããåã«æç¢ºãªåºæºãææ¡ã§ããŸãã
ã¢ãã¯ããŒãã«ã®äœæ
Eigent ã¯ãstudent_idãnameãageãgradeãenrollment_dateãmajorãgpaãemailãadvisorãstatus ãªã©ã®é
ç®ãå«ã 10 åã®åŠçããŒã¿çšæ°èŠããŒãã«ãäœæããçŸå®çãªã¢ãã¯ããŒã¿ã 10 è¡æ¿å
¥ããŸããããã¯ãã¯ãšãªã®ãã¹ãããã¢ã®äœæããããã¯ã©ã€ãããŒã¿ã«è§Šããã« SQL æäœãåŠã¶ã®ã«åœ¹ç«ã¡ãŸãã
è¡ã®æŽæ°ãšããŒã¿ã®ã°ã«ãŒãå
ã¢ãã¯ããŒã¿ã®äœæåŸãEigent 㯠2 è¡ç®ãæ°ããå€ã§æŽæ°ãããã®åŸ GROUP BY ã¯ãšãªãå®è¡ããŠããŒã¿ãéèšããŸããããšãã°ãåŠçãå°æ»å¥ãåŠå¹Žå¥ã«ã°ã«ãŒãåã§ããŸããçµæã¯èªã¿ããã圢åŒã§è¿ããããããéèšçµæãããã«ç¢ºèªã§ããŸãã
ãããéèŠãªçç±
ãã®ã¯ãŒã¯ãããŒã¯ãããŒã¿ããŒã¹æäœã«æäœæ¥ã SQL ã®å°éç¥èãå¿ é ã§ã¯ãªãããšã瀺ããŠããŸããæ°ããã¹ããŒãããã¹ãããŠããéçºè ãæ¬çªããŒã¿ãã¯ãšãªããŠããã¢ããªã¹ãããããã¯ããŒã¿ããŒã¹ããçŽ æ©ãã¬ããŒããå¿ èŠãªããŒã ãªãŒãã§ãã£ãŠããEigent ã® SQL Agent ãæ§æã®å£ãå®å šã«åãé€ããŸããå¿ èŠãªå 容ãå¹³æãªèšèã§äŒããã ãã§ãEigent ããããæ£ç¢ºãª SQL ã¯ãšãªã«å€æããå®éã®ããŒã¿ããŒã¹ã«å¯ŸããŠå®è¡ããŸãã
次ã«è©Šãããš
ãã®ããŒãã«ãã GPA ã®é«ãåŠçäžäœ 10 åã衚瀺ããŠãã ããã
åŠçããŒãã«ã« "scholarship_status" ãšããæ°ããåã远å ããGPA ã 3.5 ãè¶ ããåŠçã«ã¯ "eligible" ãèšå®ããŠãã ããã
ãã®ããŒãã«ããã¹ã¯ãããäžã® CSV ãã¡ã€ã«ã«ãšã¯ã¹ããŒãããŠãã ããã
æ¬çªããŒã¿ããŒã¹ã«æ¥ç¶ããŠã仿ã®åé±ã«äœäººã®ãŠãŒã¶ãŒãç»é²ãããã®ãµããªãŒãçæããŠãã ããã
ããè¯ãçµæãåŸãããã®ãã³ã
-
åžæãããå Žåã¯ããŒãã«åãæå®ããŠãã ããã Eigent ã¯ããã©ã«ãã§é©åãªååãçæããŸãããæç€ºçã«ååãä»ããïŒäŸ: ãããŒãã«åã 'student_records' ã«ãããïŒãšãããŒã¿ããŒã¹ãæŽçãããããªããŸãã
-
ããŒã¿ãçŸå®çã«èª¬æããŠãã ããã ãç±³åœã®å€§åŠåãã®ã¢ãã¯ããŒã¿ã§ãçŸå®çãªå°æ»ãGPAãå ¥åŠæ¥ãå«ããããšæå®ãããšãäžè¬çãªãªã¯ãšã¹ããããæçšãªãã¹ãããŒã¿ãçæãããŸãã
-
å®è¡ããã SQL ã確èªããŠãã ããã ããã³ããã«ã䜿çšãã SQL ã¯ãšãªã衚瀺ããŠãã ããããšè¿œå ãããšãã¬ãã¥ãŒãããã¥ã¡ã³ãåããŸãã¯ä»ã®ããŒã«ã§ã®åå©çšã®ããã«å®éã®ã¹ããŒãã¡ã³ãã確èªã§ããŸãã



