ã¯ããã«
以åãã話é¡ã«ãªã£ãŠããMCPïŒModel Context ProtocolïŒã§ãããAnthropicã®ç¬èªèŠæ Œã®ç¯å²ã«çãŸãããOpenAIãå ¬åŒã«æ¡çšãçºè¡šããäºã§äžæ°ã«ç«ãã€ããæè¿ã¯è³ããšããã§MCPãšããåèªãèºãããã«ãªããŸããã
ä»åã¯MCPãå©çšããããŒã¿ããŒã¹ãšã®å¯Ÿè©±+è³æåãŸã§ã®ãã¢ã1ã€ã®ãŠãŒã¹ã±ãŒã¹ãšããŠæ®ããŠãããããšæããŸãã
â æ§æ
ã¯ã©ã€ã¢ã³ãïŒClaude Desktop
ããŒã¿ããŒã¹ïŒBigQuery
ããŒã¿ããŒã¹ãšã®å¯Ÿè©±+è³æåãã¢
BigQueryã®MCPãµãŒããŒã«ã€ããŠã¯ä»¥äž2ã€ãå ¬éãããŠããŸãã
æ©èœçã«ã¯ã»ãŒäžç·ãªã®ã§ãããåŸè
ã¯ããŒã¿ã»ããåãŸã§ãã©ã¡ãŒã¿ã§æž¡ããã®ã§ããã¡ãã䜿ã£ãŠãããŸãã
Claude Desktopã®æ§æã§ä»¥äžã®èšå®ãããã ãã§ãããã«äœ¿ããŸãã
"mcpServers": {
"bigquery": {
"command": "uvx",
"args": [
"--from",
"git+https://github.com/LucasHild/mcp-server-bigquery.git@main",
"mcp-server-bigquery",
"--project",
"{{GCP_PROJECT_ID}}",
"--location",
"{{GCP_LOCATION}}",
"--dataset",
"{{DATASET}}",
"--key-file",
"{{KEY_FILE_PATH}}"
],
}
ä»åãBigQueryã®ãµã³ãã«ããŒã¿ãšããŠä»¥äžã®ãããŒã®å£²äžããŒã¿ã䜿ããŸãã
1000ä»¶ã®ããŒã¿ã§ãåºèå¥ãååå¥ã®å£²äžæ
å ±ãæã£ãŠããŸãã
ãã®ããŒã¿ã«ã€ããŠã¯äœãæããã«(MCPãç¹ãã ã ãã®ç¶æ ã§)ãClaudeãããªã¯ãšã¹ããæããŠã¿ãŸãã
ãåºèå¥ãæå¥å£²äžãæç³»åã§è¡šç€ºããŠããšãªã¯ãšã¹ããããšãããŒã¿ã»ããå ã®ããŒãã«ãšããŒã¿æ§é ã確èªããå¿ èŠãªSQLã¯ãšãªãèªåã§çµã¿ç«ãŠãŠå®è¡ããŸããæŽã«ããã®çµæãå ã«ãªã¢ã«ã¿ã€ã ã§ã°ã©ãçæãŸã§è¡ã£ãŠãããŠããŸãã
èŠããã«ãããŒã¿ããŒã¹ããç¹ãã§ããŸãã°ããŠãŒã¶ãŒã®èŠæãšããŒã¿æ§é ãå ã«å¿ èŠãªSQLãèªåã§äœæã»å®è¡ããèœåãæã¡ãReactã®ã³ãŒããã¯ããã®ã§ã°ã©ãçæãŸã§èªåšã«ã§ãããšããäºã§ãã
åœç¶ã以äžã®ãããªåã°ã©ããæ£ã°ã©ããªã©ããæã®ãã®ã§ãã
åœç¶ãè£åŽã§ã³ãŒããæã£ãŠããã®ã§ãããã®è²ãå€ããŠãããã«ããŠã³éžæã远å ããŠããã°ã©ãã®çžŠè»žã䌞ã°ããŠããšèšã£ãæç€ºãå³åº§ã«å¯Ÿå¿ããŠãããŸãã
TextToSQLã®æã¯ãããŒãã«æ§é ãCSVã®ã¿ãCode Interpreterã®æã¯ç»åã®ã¿ãšãã£ãæãã§ããšäžæ©æããããŸããããMCP+ã¢ãŒãã£ãã¡ã¯ãã«ãããããŒã³ãŒãã§ãããŸã§æ¥ãããšãªããšãå°ã朮ç®ãå€ãã£ãŠããæèŠããããŸãã
BIãæ¥åã§æ§ç¯ããç«å ŽãšããŠã¯ãæšæºçãªBIã¬ããŒããšãã®ããã«éå®åãªåæããªã¢ã«ã¿ã€ã ã§ã§ããã¢ããªãšã®ãã©ã³ã¹ãèããŠããå¿ èŠããããªãšæããŸããã
ãããŸã§æ¥ããšã¬ããŒããåºããŠæ¬²ãããªãšæã£ãŠãã®ã§ããHTMLã§è³æåããŠããšæç€ºããŠã¿ããšãHTML圢åŒã§ã®è³æåãŸã§ãã®å Žã§ãã£ãŠãããŸãã
â çæãããè³æ
å®éã®HTMLã貌ã£ãŠãããŸãã®ã§ãèå³ããæ¹ã¯èªåã§è§Šã£ãŠã¿ãŠäžãã(ã¡ã¢åž³ã«åŒµãä»ããŠãæ¡åŒµåhtmlã§ä¿åããŠãã©ãŠã¶ã§éãã°ã°ã©ããè§ŠããŸã)ã
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>åºèå¥ã»ååå¥å£²äžåæã¬ããŒã</title>
<!-- ææ°ããŒãžã§ã³ã®ã©ã€ãã©ãªãäœ¿çš -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/react/18.2.0/umd/react.production.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/react-dom/18.2.0/umd/react-dom.production.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/recharts/2.10.3/Recharts.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/babel-standalone/7.23.5/babel.min.js"></script>
<link href="https://cdnjs.cloudflare.com/ajax/libs/tailwindcss/2.2.19/tailwind.min.css" rel="stylesheet">
<style>
body {
font-family: 'Helvetica Neue', Arial, sans-serif;
line-height: 1.6;
color: #333;
background-color: #f9f9f9;
}
.container {
max-width: 1200px;
margin: 0 auto;
padding: 20px;
}
.header {
background-color: #1a56db;
color: white;
padding: 20px;
border-radius: 8px;
margin-bottom: 30px;
box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
}
.section {
background-color: white;
border-radius: 8px;
padding: 25px;
margin-bottom: 30px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.05);
}
.chart-container {
height: 400px;
margin: 20px 0;
}
table {
width: 100%;
border-collapse: collapse;
margin: 20px 0;
}
th, td {
padding: 12px 15px;
border-bottom: 1px solid #ddd;
text-align: left;
}
th {
background-color: #f2f7ff;
font-weight: bold;
}
tr:hover {
background-color: #f5f5f5;
}
.insights {
background-color: #f0f9ff;
border-left: 4px solid #3b82f6;
padding: 15px;
margin: 20px 0;
border-radius: 0 8px 8px 0;
}
.footer {
text-align: center;
margin-top: 40px;
padding: 20px;
color: #666;
font-size: 14px;
}
@media (max-width: 768px) {
.grid-cols-2 {
grid-template-columns: 1fr;
}
}
</style>
</head>
<body>
<div class="container">
<header class="header">
<h1 class="text-3xl font-bold">åºèå¥ã»ååå¥å£²äžåæã¬ããŒã</h1>
<p class="mt-2">2024幎2æ ããã³ 2024幎1æã2025幎4æã®å£²äžããŒã¿åæ</p>
</header>
<section class="section">
<h2 class="text-2xl font-bold mb-4">æŠèŠ</h2>
<p>
ãã®ã¬ããŒãã§ã¯ãå
šåºèã®å£²äžããŒã¿ãåæããåºèå¥ããã³ååå¥ã®å£²äžåŸåãå¯èŠåããŠããŸãã
2024幎2æã®è©³çްåæãš2024幎1æãã2025幎4æãŸã§ã®æç³»åã§ã®å£²äžæšç§»ã確èªã§ããŸãã
</p>
<div class="insights">
<h3 class="font-bold">äž»ãªåæçµæ:</h3>
<ul class="list-disc ml-5 mt-2">
<li>2024幎2æã®ç·å£²äžé¡ã¯389,500å</li>
<li>åºèå¥å£²äžã§ã¯ãåºèBãæãé«ã92,700åïŒçŽ24%ïŒ</li>
<li>ååå¥å£²äžã§ã¯ãååJãæãé«ã104,000å</li>
<li>äžäœ3ååïŒJ, I, HïŒã§å
šäœã®çŽ60%ã®å£²äžãå ãã</li>
<li>åºèéã®å£²äžå·®ã¯æ¯èŒçå°ããããååéã®å£²äžå·®ã¯å€§ãã</li>
</ul>
</div>
</section>
<section class="section">
<h2 class="text-2xl font-bold mb-4">2024幎2æ: åºèå¥ã»ååå¥å£²äžåæ</h2>
<div class="grid grid-cols-1 lg:grid-cols-2 gap-6">
<div>
<h3 class="text-xl font-semibold mb-3">åºèå¥å£²äžïŒåã°ã©ãïŒ</h3>
<div id="shop-pie-chart" class="chart-container"></div>
<table>
<thead>
<tr>
<th>åºè</th>
<th>売äžé¡</th>
<th>æ§ææ¯</th>
</tr>
</thead>
<tbody>
<tr>
<td>åºèB</td>
<td>92,700å</td>
<td>23.8%</td>
</tr>
<tr>
<td>åºèA</td>
<td>87,700å</td>
<td>22.5%</td>
</tr>
<tr>
<td>åºèD</td>
<td>70,500å</td>
<td>18.1%</td>
</tr>
<tr>
<td>åºèC</td>
<td>70,000å</td>
<td>18.0%</td>
</tr>
<tr>
<td>åºèE</td>
<td>68,600å</td>
<td>17.6%</td>
</tr>
<tr class="font-bold">
<td>åèš</td>
<td>389,500å</td>
<td>100.0%</td>
</tr>
</tbody>
</table>
</div>
<div>
<h3 class="text-xl font-semibold mb-3">ååå¥å£²äžïŒæ£ã°ã©ãïŒ</h3>
<div id="item-bar-chart" class="chart-container"></div>
<table>
<thead>
<tr>
<th>åå</th>
<th>売äžé¡</th>
<th>æ§ææ¯</th>
</tr>
</thead>
<tbody>
<tr>
<td>ååJ</td>
<td>104,000å</td>
<td>26.7%</td>
</tr>
<tr>
<td>ååI</td>
<td>67,500å</td>
<td>17.3%</td>
</tr>
<tr>
<td>ååH</td>
<td>61,600å</td>
<td>15.8%</td>
</tr>
<tr>
<td>ååG</td>
<td>49,000å</td>
<td>12.6%</td>
</tr>
<tr>
<td>ååF</td>
<td>35,400å</td>
<td>9.1%</td>
</tr>
<tr>
<td>ååE</td>
<td>32,000å</td>
<td>8.2%</td>
</tr>
<tr>
<td>ååD</td>
<td>23,600å</td>
<td>6.1%</td>
</tr>
<tr>
<td>ååC</td>
<td>6,300å</td>
<td>1.6%</td>
</tr>
<tr>
<td>ååB</td>
<td>5,400å</td>
<td>1.4%</td>
</tr>
<tr>
<td>ååA</td>
<td>4,700å</td>
<td>1.2%</td>
</tr>
<tr class="font-bold">
<td>åèš</td>
<td>389,500å</td>
<td>100.0%</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="insights mt-6">
<h3 class="font-bold">åæãšèå¯:</h3>
<p class="mt-2">
2024幎2æã®å£²äžåæã§ã¯ãåºèå¥ã®å£²äžã¯ã»ãŒåçã«ååžããŠããŸãããååå¥ã§ã¯å€§ããªåããèŠãããŸãã
ç¹ã«ååJã¯å
šäœã®4åã®1以äžã®å£²äžãå ããŠããã売äžãžã®è²¢ç®åºŠãé«ãäž»åååãšãªã£ãŠããŸãã
äžæ¹ã§ååAãBãCã®å£²äžã¯éåžžã«äœãããããã®ååã®è²©å£²æŠç¥ã®èŠçŽããã
ãããã¯ååã©ã€ã³ãããããã®åé€ãæ€èšããå¿
èŠããããããããŸããã
</p>
</div>
</section>
<section class="section">
<h2 class="text-2xl font-bold mb-4">åºè奿å¥å£²äžæšç§» (2024幎1æã2025幎4æ)</h2>
<div id="monthly-sales-chart" class="chart-container" style="height: 500px"></div>
<div class="insights">
<h3 class="font-bold">ãã¬ã³ãåæ:</h3>
<p class="mt-2">
æç³»åããŒã¿ããã¯ãååºèã®å£²äžã«å£ç¯å€åãèŠãããŸããç¹ã«æ³šç®ãã¹ãç¹ãšããŠã
2025幎3æã«åºèBãšAã§å€§å¹
ãªå£²äžå¢å ãèŠãããŸããããã¯å£ç¯èŠå ãç¹å¥ãªããã¢ãŒã·ã§ã³ã
ãããã¯ç¹å®ååã®éèŠå¢å ãªã©ã圱é¿ããŠããå¯èœæ§ããããŸãã
äžæ¹ã§ãåºèCã¯2025幎3æãš4æã«å£²äžã倧ããèœã¡èŸŒãã§ãããåå 調æ»ãå¿
èŠãããããŸããã
</p>
</div>
</section>
<section class="section">
<h2 class="text-2xl font-bold mb-4">çµè«ãšæšå¥šäºé
</h2>
<ol class="list-decimal ml-5">
<li class="mb-2">
<strong>ååããŒããã©ãªãªã®æé©å:</strong>
売äžè²¢ç®åºŠãäœãååAãBãCã®è²©å£²æŠç¥ãèŠçŽããäž»åååãžã®ãªãœãŒã¹éäžãæ€èšããã
</li>
<li class="mb-2">
<strong>åºèéã®ç¥èŠå
±æ:</strong>
売äžã奜調ãªåºèã®è²©å£²ææ³ã顧客察å¿ãä»åºèãšå
±æããã°ã«ãŒãå
šäœã®å£²äžåäžãå³ãã
</li>
<li class="mb-2">
<strong>å£ç¯å€åãžã®å¯Ÿå¿:</strong>
売äžãèœã¡èŸŒãææã«åãã販ä¿ãã£ã³ããŒã³ã®èšç»ããç¹å¿æã«åããåšåº«ã»äººå¡é
çœ®ã®æé©åãè¡ãã
</li>
<li class="mb-2">
<strong>ããŒã¿åæã®ç¶ç¶:</strong>
ææ¬¡ã§ã®å£²äžåæãç¶ç¶ãããã¬ã³ãã®å€åã«çŽ æ©ã察å¿ã§ããäœå¶ãæŽããã
</li>
</ol>
</section>
<footer class="footer">
<p>© 2025 åºè売äžåæã¬ããŒã | äœææ¥: 2025幎4æ27æ¥</p>
</footer>
</div>
<!-- çŽç²ãªD3ãšJSã䜿çšããã°ã©ãæç» -->
<!-- ããŒã¿å®çŸ© -->
<script>
// åºèå¥å£²äžããŒã¿
const shopSalesData = [
{shop: 'åºèB', value: 92700},
{shop: 'åºèA', value: 87700},
{shop: 'åºèD', value: 70500},
{shop: 'åºèC', value: 70000},
{shop: 'åºèE', value: 68600}
];
// ååå¥å£²äžããŒã¿
const itemSalesData = [
{item: 'ååJ', value: 104000},
{item: 'ååI', value: 67500},
{item: 'ååH', value: 61600},
{item: 'ååG', value: 49000},
{item: 'ååF', value: 35400},
{item: 'ååE', value: 32000},
{item: 'ååD', value: 23600},
{item: 'ååC', value: 6300},
{item: 'ååB', value: 5400},
{item: 'ååA', value: 4700}
];
// ææ¬¡å£²äžããŒã¿
const monthlySalesData = [
{'month': '2024-01', 'åºèA': 39600, 'åºèB': 100000, 'åºèC': 94100, 'åºèD': 129700, 'åºèE': 52900},
{'month': '2024-02', 'åºèA': 87700, 'åºèB': 92700, 'åºèC': 70000, 'åºèD': 70500, 'åºèE': 68600},
{'month': '2024-03', 'åºèA': 76800, 'åºèB': 78900, 'åºèC': 50000, 'åºèD': 35500, 'åºèE': 77100},
{'month': '2024-04', 'åºèA': 95300, 'åºèB': 46500, 'åºèC': 59400, 'åºèD': 77700, 'åºèE': 52000},
{'month': '2024-05', 'åºèA': 63100, 'åºèB': 33400, 'åºèC': 80300, 'åºèD': 59900, 'åºèE': 97600},
{'month': '2024-06', 'åºèA': 89000, 'åºèB': 70800, 'åºèC': 54100, 'åºèD': 96300, 'åºèE': 48600},
{'month': '2024-07', 'åºèA': 58900, 'åºèB': 108500, 'åºèC': 40100, 'åºèD': 32800, 'åºèE': 72400},
{'month': '2024-08', 'åºèA': 73100, 'åºèB': 47900, 'åºèC': 78500, 'åºèD': 87100, 'åºèE': 104900},
{'month': '2024-09', 'åºèA': 47700, 'åºèB': 82300, 'åºèC': 92000, 'åºèD': 63000, 'åºèE': 41100},
{'month': '2024-10', 'åºèA': 68500, 'åºèB': 134800, 'åºèC': 65200, 'åºèD': 83300, 'åºèE': 97500},
{'month': '2024-11', 'åºèA': 73000, 'åºèB': 68800, 'åºèC': 106500, 'åºèD': 46800, 'åºèE': 64800},
{'month': '2024-12', 'åºèA': 83000, 'åºèB': 64300, 'åºèC': 42900, 'åºèD': 48100, 'åºèE': 71700},
{'month': '2025-01', 'åºèA': 67600, 'åºèB': 70500, 'åºèC': 54300, 'åºèD': 78600, 'åºèE': 59000},
{'month': '2025-02', 'åºèA': 80300, 'åºèB': 59400, 'åºèC': 87400, 'åºèD': 44900, 'åºèE': 38200},
{'month': '2025-03', 'åºèA': 132200, 'åºèB': 170800, 'åºèC': 31400, 'åºèD': 64900, 'åºèE': 109200},
{'month': '2025-04', 'åºèA': 64700, 'åºèB': 47700, 'åºèC': 19800, 'åºèD': 42000, 'åºèE': 64400}
];
</script>
<!-- Chart.jsã䜿çšããã°ã©ãæç» -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/4.4.0/chart.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/chartjs-plugin-datalabels/2.2.0/chartjs-plugin-datalabels.min.js"></script>
<script>
document.addEventListener('DOMContentLoaded', function() {
// Chart.jsã«DataLabelsãã©ã°ã€ã³ãç»é²
Chart.register(ChartDataLabels);
// åã°ã©ã
const shopPieCtx = document.createElement('canvas');
document.getElementById('shop-pie-chart').appendChild(shopPieCtx);
// æ£ã°ã©ã
const itemBarCtx = document.createElement('canvas');
document.getElementById('item-bar-chart').appendChild(itemBarCtx);
// æãç·ã°ã©ã
const monthlyLineCtx = document.createElement('canvas');
document.getElementById('monthly-sales-chart').appendChild(monthlyLineCtx);
// åã°ã©ãäœæ
new Chart(shopPieCtx, {
type: 'pie',
data: {
labels: shopSalesData.map(d => d.shop),
datasets: [{
data: shopSalesData.map(d => d.value),
backgroundColor: ['#0088FE', '#00C49F', '#FFBB28', '#FF8042', '#8884D8'],
}]
},
options: {
responsive: true,
maintainAspectRatio: false,
plugins: {
legend: {
position: 'bottom'
},
tooltip: {
callbacks: {
label: function(context) {
let label = context.label || '';
if (label) {
label += ': ';
}
if (context.parsed !== null) {
label += new Intl.NumberFormat('ja-JP').format(context.parsed) + 'å';
}
return label;
}
}
},
datalabels: {
color: '#fff',
font: {
weight: 'bold',
size: 14
},
formatter: function(value, context) {
return context.chart.data.labels[context.dataIndex] + '\n' +
new Intl.NumberFormat('ja-JP').format(value) + 'å';
}
}
}
}
});
// æ£ã°ã©ãäœæ
new Chart(itemBarCtx, {
type: 'bar',
data: {
labels: itemSalesData.map(d => d.item),
datasets: [{
label: '売äžé¡',
data: itemSalesData.map(d => d.value),
backgroundColor: '#8884d8',
}]
},
options: {
responsive: true,
maintainAspectRatio: false,
plugins: {
legend: {
position: 'top'
},
tooltip: {
callbacks: {
label: function(context) {
let label = context.dataset.label || '';
if (label) {
label += ': ';
}
if (context.parsed.y !== null) {
label += new Intl.NumberFormat('ja-JP').format(context.parsed.y) + 'å';
}
return label;
}
}
},
datalabels: {
align: 'end',
anchor: 'end',
color: '#333',
font: {
weight: 'bold'
},
formatter: function(value) {
return new Intl.NumberFormat('ja-JP').format(value) + 'å';
}
}
},
scales: {
y: {
beginAtZero: true,
ticks: {
callback: function(value) {
return (value / 1000) + 'k';
}
}
}
}
}
});
// æå¥å£²äžã°ã©ãäœæ
const shopColors = {
'åºèA': '#0088FE',
'åºèB': '#00C49F',
'åºèC': '#FFBB28',
'åºèD': '#FF8042',
'åºèE': '#8884D8'
};
const monthlyDatasets = Object.keys(shopColors).map(shop => {
return {
label: shop,
data: monthlySalesData.map(d => d[shop]),
borderColor: shopColors[shop],
backgroundColor: shopColors[shop],
tension: 0.1
};
});
new Chart(monthlyLineCtx, {
type: 'line',
data: {
labels: monthlySalesData.map(d => {
// YYYY-MMããæã ã衚瀺
return d.month.substring(5);
}),
datasets: monthlyDatasets
},
options: {
responsive: true,
maintainAspectRatio: false,
plugins: {
legend: {
position: 'bottom'
},
tooltip: {
mode: 'index',
intersect: false,
callbacks: {
title: function(context) {
// æè¡šç€ºãYYYY幎MMæã«å€æ
const month = monthlySalesData[context[0].dataIndex].month;
return `${month.substring(0, 4)}幎${month.substring(5)}æ`;
},
label: function(context) {
let label = context.dataset.label || '';
if (label) {
label += ': ';
}
if (context.parsed.y !== null) {
label += new Intl.NumberFormat('ja-JP').format(context.parsed.y) + 'å';
}
return label;
}
}
},
// ããŒã¿ã©ãã«ãç¡å¹å
datalabels: {
display: false
}
},
scales: {
y: {
beginAtZero: true,
ticks: {
callback: function(value) {
return (value / 1000) + 'k';
}
}
}
},
// ããŠã¹ãããŒæã®åäœãèšå®
interaction: {
mode: 'index',
intersect: false
},
hover: {
mode: 'index',
intersect: false
}
}
});
});
</script>
</body>
</html>
å人çãªææ³
æ¥åçãªã€ã³ãã¯ã
ãã¡ãã«ã€ããŠã¯ãã¯ãMCPãšã¯é¢ä¿ãªãã®ã§ãããDXã»BPRããã£ãšãã£ãŠããç«å ŽãšããŠã¯ãAIã«ãã£ãŠä»¥äž3ã€ãé«ç²ŸåºŠãã€ã·ãŒã ã¬ã¹ã«ç¹ããããã«ãªã£ãäºã®ç Žå£åããšãŠã€ããªããªãšæã£ãŠããŸãã
â TextToSQL
â¡ åçã°ã©ãçæ
⢠HTMLåºå
TextToSQLã«ãã£ãŠããŠãŒã¶ãŒåŽã®SQLã®ç¥èãå®è³ªäžèŠã«ãªããããŒã¿ããŒã¹ãšèªç¶èšèªã§äŒè©±ã§ããããã«ãªããŸããã
ãã¯ã誰ããSQLã«é·ããããŒã¿ãµã€ãšã³ã¹ã®ã¹ãã·ã£ãªã¹ããšãã¢ã§ä»äºãã§ããç¶æ ã«ãªãã®ã§ãããŒã¿å©æŽ»çšã®æ°äž»åã«ããããŒã¿ããªãã³ãäžæ°ã«é²ãå¯èœæ§ãç§ããŠããŸãã
ããããããŒã¿ãµã€ãšã³ãã£ã¹ãã§ãããè€éãªã¯ãšãªãèªåã§äœããããšæã人ã¯ããªãã¯ããªã®ã§(ãœãããŠã§ã¢ãšã³ãžãã¢ãšã³ãŒãã£ã³ã°ã®é¢ä¿)ãããŒã¿ãµã€ãšã³ãã£ã¹ãã®ä»äºãæãã§ãããã
äžæ¹ãTextToSQLåäœã ãšããããŸã§CSVãããŒãã«ãè¿ãã ããªã®ã§çæèœã¡æããã£ãã®ã§ãããåæçšã®ã°ã©ãããã®å Žã§çæããŠã€ã³ã¿ã©ã¯ãã£ããªæäœãã§ãããšãªããšãæŽã«è£Ÿéãåºããªãã®ã§ã¯ãªãããšæããŸãã
Code InterpreterãæååºãŠããæãè¡æã§ããããClaude Desktopã®Artifactã®ã¬ãã«ã ãšãå®åã§äœ¿ãããïŒããšããããã»ãšãã©ã®äººãæãã®ã§ã¯ãªãã§ããããã
ç§èªèº«ãCode Interpreterã®æã®ãã¢ãšä»åã®ãã¢ã宿œããéã®ãŠãŒã¶ãŒã®ãªã¢ã¯ã·ã§ã³ãæããã«ç°ãªãäºãæããŠãããæ¥åãŠãŒã¶ãŒã§ã®å©çšæ®åã«ãããUXã®å£ãè¶ããŠãããšããæèŠããããŸãã
ãã®ã¬ãã«ã§ããã°ãä»åŸã¯ç®¡çè·ã圹å¡ã®ãããªã¯ã©ã¹ã§ãããã®ããŒã¿åºããŠãããŠããšéšäžã«æç€ºãããããèªåã§ãã£ãã»ããæ©ããšãªãã±ãŒã¹ãå¢ããŠããã®ã§ã¯ãªãã§ããããã
ãããŠã以åã³ã³ãµã«ãã¡ãŒã ã«æå±ããŠããäºããããè³æïŒãã¯ãããšããæèã«åŒã£åŒµãããŠããã®ã§ãããããããAIã¯ãã¯ãããHTMLã®ã»ããäœæãç·šéãå§åçã«åŸæãªã®ã§ãHTMLãè³æãšããŠãã®ãŸãŸäœ¿ã£ãŠãè¯ããããããŸããã
MS Copilotã®éåžžã«ç°¡çŽ ãªãã¯ãè³æã«æ¯ã¹ãGensparkãHTMLã§ããªãè¯ãè³æãçæããŠããäºãããããã¯æããã§ãä»åŸã¯ç€Ÿå è³æããã¯ãããŒã¹ããHTMLããŒã¹ã«ãªããšããäŒæ¥ãã©ãã©ãå¢ããŠããã®ã§ã¯ãªãã§ããããã
綺éºãªãã¯ããäœããããŒã«ããŸãããããåºãŠããããã«ãªããšã¯æããŸããããããããã¯ãã«ãã ããå¿ èŠããªãã®ã§ãHTML+PDFåºåãäž»äœã«ãªã£ãŠãããããªæ°ãããŸãã
ãããŠãããã®æ©èœãä»ãŸã§åå¥ã ã£ããã®ã®ããããŒã¿ååŸãâãã°ã©ãå+åæãâãè³æåããã€ã³ã¿ã©ã¯ãã£ããã€ã·ãŒã ã¬ã¹ã«ç¹ããUXã«ãªã£ãŠããäžã«ããããæšè«ã¢ãã«ã§ããäºã§æŽã«æ¡åŒµã§ããããã«ãªããŸãã
ããããèªååãšãããããèªååæ¡åŒµã®ãããªåœ¢ã§ãããããå人ã¬ãã«ã§ã¯åºãããªãæ§ã ãªè§åºŠã§ã®ã¯ãšãªãåæãã¬ããŒãã£ã³ã°ãªã©ãèããŠãããã®ã§ãåãªãèªååã»å¹çåã«çãŸããªãåšåãæã¡ãŸãã
ãããäžéå端ã«çްããæç€ºãåºããšAIã®åæã¹ã³ãŒããçããªãããããããã®ã§ãæœè±¡åºŠé«ãã«äŸé Œããã»ããæšè«ã¢ãã«ã®å®åãçºæ®ããããããããããŸãã (åªç§ãªéšäžããã€ã¯ããããžãããšãããçç£æ§ãäžããã€ã¡ãŒãž)ã
ãŸãä»åã¯BigQueryã ãã§ãããMCPã§æ§ã ãªããŒã«ãšå®¹æã«é£æºã§ããããã«ãªããšãåçš®å ¬éæ å ±ããã¬ã³ãããŒã¿ãªã©ã®ç€Ÿå€æ å ±ãçµã¿åãããå æ¬çãªåæã»ã¬ããŒãã£ã³ã°ãã§ããããã«ãªãã§ãããã
ãã¯ãèªååã¿ã¹ã¯ãšããŠãæ¥æ¬¡/鱿¬¡/ææ¬¡åæã¬ããŒãã®è³æåãŸã§AIã«ä»»ããŠããŸã£ãŠããããããŒã¹ã«ç€Ÿå ã§ãã£ã¹ã«ãã·ã§ã³ãšãªãæªæ¥ãããé ããªãæ°ãããŸãã
ããã§1ã€æ³šæãå¿ èŠãªã®ã¯ãä»åŸã¯ãããããAIã䜿ãããªãããããšãããããããŒã¿ãAIã®æãå±ãç¯å²ã«ããã(ããŒã¿åºç€ãæŽã£ãŠããã)ããšããã€ã·ã¥ãŒã®ã»ãã倧ãããªã£ãŠãããšããç¹ã§ãã
AIãã³ã¢ãã£ãã£åããæšè«ã¢ãã«ããããããã£ãŠãããäžçç·ã«ãããŠã¯ããéåžžã«åªç§ãªAIãšã³ãžãã¢ÃããŒã¿ãæ£åšããŠããçµç¹ããšãããããã®AIãšã³ãžãã¢ÃããŒã¿ãæŽåãããçµç¹ãã§ããã°ãå§åçã«åŸè ã匷ããªããŸãã
AIã§æè¿ã¯è©±é¡ããã¡ããã§ãããå®éã®ãšãããæ¬åœã«æè³ãã¹ãã¯AI以äžã«ããŒã¿åºç€ã®æŽåã»æ§ç¯ã«ãªãã§ãããã
çæAIã®ç»å Žã«ãã£ãŠDXã®ãã§ãŒãºãæããã«å€ãã£ãæããããã®ã®ãå®éã®ãšããããããŸã§DXãçé¢ç®ã«ãã£ãŠããäŒæ¥ãæŽã«å éã§ãããšããç¶æ ã«ãªã£ãŠããŸãã
å°ãªããšããåªç§ãªAIãšã³ãžãã¢ã ãæ¡çšããã°äœãšããªããšãã話ã§ã¯ãªãã®ã§æ³šæãå¿ èŠã§ãã
æè¡çãªè©±
ããããéãšã³ãžãã¢ã®äººéã®ã»ãšãã©ããŸã åéãããŠãããšæããŸãããMCPã§æ©èœçã«ã§ããäºãç¹ã«å¢ããããã§ã¯ãªããFunctionCallingãå«ããããŸã§ãããããã§ããŠããäºãæšæºåããããã€ãŸããããããããªã£ãã ããšããã°ããã ããšãã圢ã«ãªããŸãã
å ã AIãšãŒãžã§ã³ãã®æ§ç¯åšãããã£ãŠãã人ã¯ããããäœãå¬ããã®ïŒ(äœã§ãããªã«éšãããŠãã®ïŒïŒ)ããšæãã人ãå°ãªããªãã£ãã®ã§ã¯ãªãããšæããŸãã
ç§ãå ã BigQueryãšTextToSQLã§äŒè©±ããAIãšãŒãžã§ã³ããFunctionCallingã§äœã£ãŠããã®ã§ãBigQueryã®MCPãæåèŠãæãããããã ãïŒããšé©ããŸããã
æåãMCPã¯USB-Cããšããã¢ãããžãŒãä»äžã€è ã«èœã¡ãªãã£ãã®ã§ãããUSB-Cã«æšæºåãããåãããããã®èŠæ Œã§å é»ã¯ã§ããŠãããã®ã®ãUSB-Cã§å é»ã楜ã«ãªã£ãã®ã¯ç¢ºããªã®ã§ãããçš®äžæã衚çŸãªã®ãããããŸããã
åå¥ã¢ããªã®äœã蟌ã¿ãšãã芳ç¹ã§èšãã°ãæšæºçãªMCPã䜿ã£ãå Žåã®ã¬ã¹ãã³ã¹ã®åŠçã¯ã¢ããªåŽã§æžãå¿ èŠãããã®ã§ããããªãã°MCPãµãŒããŒãèªåã§ç«ãŠãããšãã話ã«çµå±ãªããããªäžã«ãããããèªåãã䜿ããªããªãMCPåããæå³ãããŸããªãã®ã§ããã®ãŸãŸæžãæ¹ãè¯ãã®ã§ã¯ïŒãšãã圢ã«ãªãæ°ãããŸãã
å©çšã§ãããã®ã¯ãªãã¹ã掻çšããŠãããããä»åŸã®ãšã³ã·ã¹ãã åã®æ©æµãšé²åã¯æ¥œãã¿ã§ãããç¹ååã®ã±ãŒã¹ã§èšãã°ãäœãäœã§ãMCPããšãããšãã©ãããŒåŠçãæžãã³ã¹ãããããé«ãã€ãäžã«ã¬ã¹ãã³ã¹ãé ããªããšããã±ãŒã¹ãå°ãªããªãæ°ãããã®ã§ãä»ã®æã¯ãããŸã§æšæºå+å ¬é芳ç¹ã®çšéãšããæèã¯æã£ãŠããå¿ èŠãããããã§ãã
æ¢ã«ç€Ÿå ã§æ§ç¯ã»ãªãªãŒã¹æžã¿ã®AIã¢ããªã±ãŒã·ã§ã³ã«å¯ŸããŠããããMCPåãããïŒããšèšãã®ã¯æããã«ééãã§ããšããããMCPåãããšäœããã¯ãŒã¢ãããããšããèš³ã§ã¯ãããŸããã
äžã€ããããã ãªãšæã£ãã®ã¯ã瀟å DWHæ§ç¯ã®éã«MCPãµãŒããŒãæ§ç¯åŽãã»ããã§çšæããŠããããšãã圢ã§ãã
æ¯åAIãšãŒãžã§ã³ããããŒã¿ããŒã¹ã®äžèЧååŸãã¹ããŒãæ€çŽ¢ãããã®ãé ãäžã«ãããŒã¿ã®æå³çãªæ å ±ã瀟å çšèªãªã©ã®æ å ±ã¯ã©ãããŠãèœã¡ãã®ã§ããã®èŸºãã®æ å ±ããã¬ããžãMCPãµãŒããŒåŽã«äžæãçµã¿èŸŒãã§å ¬éããã°(æœè±¡åããŠããŒã«ãšããŠå ¬éããã°)ãDWHãå©çšããAIãšãŒãžã§ã³ãã®æ§ç¯ãšå©çšå¹çãããªãäžãããããªæ°ãããŸãã
ãããªããšBIã¬ããŒããã³ãŒãããŒã¹ã®ãã®ãããAIãžã®æç€ºããã³ãããšããŠç®¡çã»ä¿®æ£ããã圢ã«ãªã£ãŠãããããããŸãã(æ¥åãŠãŒã¶ãŒåŽã§å³æä¿®æ£ã§ããããã«ãªã)ã
ãŸãšã
ãããã ã£ãã§ããããã
MCPã«é¢ããŠã¯äœ¿ããæã§ã¯å©äŸ¿æ§ãéåžžã«é«ããã®ã®ãéæ³ã®ããŒã«ãšããããã§ã¯ãªãã®ã§ã驿驿ã§äœ¿ãã©ãããèŠæ¥µããŠããã¹ãã ãšæããŸãã
ãŸããä»åã¯ã¢ããªã±ãŒã·ã§ã³ãšããŠã®å¯èœæ§ã®èŠç¹ã§ãããããŸã ãŸã æªæçãªé åã§ãããåçäžã®ã»ãã¥ãªãã£ãªã¹ã¯ã«ã€ããŠãæ§ã ãªææãããããããµã³ãããã¯ã¹ç°å¢ã§ãŸãã¯è©Šãã®ãè¯ãã§ãããã
ãã MCPã䜿ããšã¢ãã«ãã©ã€ãã©ãªã®ã¹ã€ããã¯éåžžã«æ¥œã«ãªãäžãåAIãšãŒãžã§ã³ãããã®å©çšãå€ã瀟å ã·ã¹ãã ãããŒã¿ããŒã¹ã«ã€ããŠã¯ããã¬ããžãå«ãMCPåããŠãããšãåæã§ã®AI婿޻çšä¿é²ã«å€§ããå¯äžãããããããŸããã
ãããŸã§ã®åå¥ã¿ã¹ã¯ã®èªååããMCPã®ç»å Žãå«ããã©ãã©ãE2E(End-to-End)ã®æ¹åã«åãã£ãŠããã®ã楜ãã¿ã§ãã




