MCP Toolbox for Databases in Action

Google Cloud Tech · Beginner ·🧠 Large Language Models ·1y ago

Key Takeaways

MCP Toolbox for Databases is an open-source MCP server designed to simplify the connection between AI agents and databases, providing a standardized way for AI agents to communicate with tools and enhancing security and performance. The toolbox supports a broad number of databases and includes contributions for third-party databases, with client SDK and integrations for popular frameworks.

Full Transcript

[Music] Maybe you'd like to develop agents to understand natural language requests and even have them dynamically select the right tools based on your data. Connecting these intelligent agents to databases can often feel like navigating a maze. You're going to have to break down silos, ensuring robust security, all that feels challenging. And this is where MCP toolbox for databases comes in. It's an open-source MCP server designed specifically to make this connection easier, faster, and more secure. MCP or model context protocol acts as the standardized way for AI agents to communicate with tools, much like a universal adapter. So why should you consider using the toolbox? First of all, it simplifies your development. You can integrate tools in your AI agent with very little code. Second, it delivers better performance because Toolbox incorporates best practices like connection pooling right out of the box. Third, security is enhanced with integrated authentication methods. You also gain endtoend observability thanks to out-of-the-box metrics and tracing with built-in open telemetry support. And finally, MCP toolbox provides a centralized location for your tools, allowing you to share them between agents and applications. Let's look at the architecture. MCP toolbox acts as a control plane sitting between your application's orchestration framework. And this could be something like Google's ADK agent development kit which acts as the MCP client and the MCP toolbox which is your server exposing those defined database capabilities. To see this in action, let's explore an example, the time series forecasting agent. You can find this project in the GitHub ADK samples repository. It shows you how you can build an intelligent agent using Bitquery's AI forecast function which uses a state-of-the-art times FM model. This agent can understand natural language requests for forecast and dynamically select the right tools. So imagine you want to predict future values based on historical data. In this case, we could ask the agent forecast liquor sales for the next week in Iowa. The agent potentially powered by a large language model like Gemini first needs to understand this natural language request and then it figures out how to get that forecast and this is where the tools come in. The forecasting agent is configured to load its tools from the toolbox which acts as the MCP server. These tools are defined in a config file called tools.yml. Each tool has a description that the agent uses to understand its purpose. It will also list any parameters needed like horizon in our case and contain the actual SQL statement that interacts with the database. The really powerful aspect here is the dynamic tool system. You can add or update forecasting capabilities simply by updating that tools.yml file and then restarting the MCP server. So there's no need to change the agents core Java code, recompile, any of that. This makes the entire system highly extensible and maintainable. We can interact with this forecasting agent using the ADK's forecasting UI. You'd first type in your forecasting request. The agent with the help of the MCP toolbox understands this, selects the correct tools, determines parameters like the horizon, and then instructs the toolbox to execute the query. So the agent not just presents raw forecast data but it provides qualitative analysis and insights and this gives us an interactive way to experiment and see the agents reasoning and results in real time. So this agentic design is particularly effective because it combines the broad contextual understanding of a large language model with the specialized precision of a model like the times FM model for forecasting. MCP toolbox for databases currently supports a broad number of databases from Google Cloud and even includes contributions for thirdparty databases like Neo forj and Dgraph for integrating these tools in your applications. You also have a client SDK and integrations for popular frameworks of lingraph in llama index. To sum it all up, MCP Toolbox for databases is an open- source MCP server that drastically simplifies how your AI agents can utilize enterprise data. If you're building agentic applications that need to interact with databases, this is a tool you'll want to check out. Visit the MCP toolbox for databases on GitHub. Explore this documentation and see how it can accelerate your AI development today.

Original Description

Explore MCP Toolbox for Databases on GitHub→https://goo.gle/3Sm4BgJ Dive into the Documentation →https://goo.gle/3SssRhb Learn more about BigQuery AI.FORECAST → https://goo.gle/4kGcKJ0 Struggling to connect your AI agents to your valuable enterprise data? Building powerful AI applications that truly understand your data, respond to natural language, and dynamically select the right tools can feel like navigating a complex maze. Data silos and security concerns often stand in the way. Enter MCP Toolbox for Databases! This open source MCP (Model Context Protocol) server is your streamlined solution to bridge AI and databases – making connections easier, faster, and more secure. Why choose MCP Toolbox? 1️⃣ Simplified development: integrate tools into your AI agents with minimal code. 2️⃣ Better performance: Benefit from out of the box best practices like connection pooling. 3️⃣ Enhanced security: Leverage integrated authentication methods for robust data protection. 4️⃣ End to end observability: Gain clear insights with built in OpenTelemetry for metrics and tracing. 5️⃣ Centralized tool management: Manage and share tools efficiently between agents and applications. How does it work? MCP Toolbox for Databases acts as a control plane between your AI agent's orchestration framework (like Google's Agent Development Kit) and your databases. Your AI agent (the MCP client) connects to the Toolbox (the MCP server) to access defined database capabilities. See it in Action: Time Series Forecasting Agent! Imagine asking your AI: "Forecast liquor sales for next week in Iowa." This agent, potentially powered by a Large Language Model like Gemini, uses MCP Toolbox to understand the request and dynamically select the right forecasting tool defined in a simple tools.yaml configuration file. This example, available in the GitHub ADK samples repository, showcases how to use BigQuery’s AI.FORECAST function with the state of the art TimesFM model. The beauty lies in the d
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from Google Cloud Tech · Google Cloud Tech · 0 of 60

← Previous Next →
1 I’m going for it #GoogleCloudCertified
I’m going for it #GoogleCloudCertified
Google Cloud Tech
2 I had to get #GoogleCloudCertified
I had to get #GoogleCloudCertified
Google Cloud Tech
3 Be better overall at what you do #GoogleCloudCertified
Be better overall at what you do #GoogleCloudCertified
Google Cloud Tech
4 Cloud Monitoring on our radar #Analysis #Uptime
Cloud Monitoring on our radar #Analysis #Uptime
Google Cloud Tech
5 Introduction to Generative AI Studio
Introduction to Generative AI Studio
Google Cloud Tech
6 How to use Github Actions with Google's Workload Identity Federation
How to use Github Actions with Google's Workload Identity Federation
Google Cloud Tech
7 Introduction to Responsible AI
Introduction to Responsible AI
Google Cloud Tech
8 Networking updates and CDMC-certified architecture
Networking updates and CDMC-certified architecture
Google Cloud Tech
9 Create and use a Cloud Storage bucket
Create and use a Cloud Storage bucket
Google Cloud Tech
10 How to digitize text from documents
How to digitize text from documents
Google Cloud Tech
11 Faster analytical queries with AlloyDB
Faster analytical queries with AlloyDB
Google Cloud Tech
12 Next ‘23 sessions and FaaS Wave
Next ‘23 sessions and FaaS Wave
Google Cloud Tech
13 Introduction to Assured Open Source Software
Introduction to Assured Open Source Software
Google Cloud Tech
14 BigQuery Cost Optimization: Storage
BigQuery Cost Optimization: Storage
Google Cloud Tech
15 BigQuery Cost Optimization: Compute
BigQuery Cost Optimization: Compute
Google Cloud Tech
16 BigQuery Cost Optimization: Select Queries
BigQuery Cost Optimization: Select Queries
Google Cloud Tech
17 Remote Field Equipment Management with Manufacturing Data Engine
Remote Field Equipment Management with Manufacturing Data Engine
Google Cloud Tech
18 Supercharging your applications with Cloud SQL Enterprise Plus
Supercharging your applications with Cloud SQL Enterprise Plus
Google Cloud Tech
19 Vector Support on our radar #GenAI
Vector Support on our radar #GenAI
Google Cloud Tech
20 Architecting a blockchain startup with Google Cloud
Architecting a blockchain startup with Google Cloud
Google Cloud Tech
21 Kubernetes and multitasking updates!
Kubernetes and multitasking updates!
Google Cloud Tech
22 GKE: Using Kubernetes Events
GKE: Using Kubernetes Events
Google Cloud Tech
23 How to configure firewall rules for Cloud Composer
How to configure firewall rules for Cloud Composer
Google Cloud Tech
24 Vertex AI Embeddings API + Matching Engine: Grounding LLMs made easy
Vertex AI Embeddings API + Matching Engine: Grounding LLMs made easy
Google Cloud Tech
25 Geospatial analytics on our radar #EarthEngine #BigQuery
Geospatial analytics on our radar #EarthEngine #BigQuery
Google Cloud Tech
26 Ensuring requests are set in Kubernetes
Ensuring requests are set in Kubernetes
Google Cloud Tech
27 Cloud Next 2023, Google research program, and more!
Cloud Next 2023, Google research program, and more!
Google Cloud Tech
28 How to migrate projects between organizations with Resource Manager
How to migrate projects between organizations with Resource Manager
Google Cloud Tech
29 How to run #MySQL in Google Cloud
How to run #MySQL in Google Cloud
Google Cloud Tech
30 #GenerativeAI for enterprises and #Next2023
#GenerativeAI for enterprises and #Next2023
Google Cloud Tech
31 How Google Photos scales to store 4 trillion photos and videos
How Google Photos scales to store 4 trillion photos and videos
Google Cloud Tech
32 Google Cross-Cloud Interconnect (Demo 2)
Google Cross-Cloud Interconnect (Demo 2)
Google Cloud Tech
33 GKE Cost Optimization Golden Signals: Introduction
GKE Cost Optimization Golden Signals: Introduction
Google Cloud Tech
34 GKE Cost Optimization Golden Signals: Workload Rightsizing
GKE Cost Optimization Golden Signals: Workload Rightsizing
Google Cloud Tech
35 GKE Load Balancing: Overview
GKE Load Balancing: Overview
Google Cloud Tech
36 GKE Load Balancing: Best Practices
GKE Load Balancing: Best Practices
Google Cloud Tech
37 Disaster Recovery in GKE
Disaster Recovery in GKE
Google Cloud Tech
38 How to configure IP masquerade agent in GKE Standard clusters
How to configure IP masquerade agent in GKE Standard clusters
Google Cloud Tech
39 Enable and use GKE Control plane logs
Enable and use GKE Control plane logs
Google Cloud Tech
40 Compliance in Australia with Assured Workloads
Compliance in Australia with Assured Workloads
Google Cloud Tech
41 Creating budgets and budget alerts in Google Cloud #FinOps
Creating budgets and budget alerts in Google Cloud #FinOps
Google Cloud Tech
42 Cloud SQL Enterprise Plus on our radar #mySQL
Cloud SQL Enterprise Plus on our radar #mySQL
Google Cloud Tech
43 What's Next for Google Cloud?
What's Next for Google Cloud?
Google Cloud Tech
44 How Loveholidays scaled with Contact Center AI
How Loveholidays scaled with Contact Center AI
Google Cloud Tech
45 What is fleet team management in GKE?
What is fleet team management in GKE?
Google Cloud Tech
46 Troubleshoot VPC Network Peering
Troubleshoot VPC Network Peering
Google Cloud Tech
47 Introduction to DocAI and Contact Center AI
Introduction to DocAI and Contact Center AI
Google Cloud Tech
48 Cloud Run Direct VPC egress explained
Cloud Run Direct VPC egress explained
Google Cloud Tech
49 Database deployment options in GKE
Database deployment options in GKE
Google Cloud Tech
50 Analyze cloud billing data with #BigQuery
Analyze cloud billing data with #BigQuery
Google Cloud Tech
51 Tips to becoming a world-class Prompt Engineer
Tips to becoming a world-class Prompt Engineer
Google Cloud Tech
52 Serverless is simple. Do I need CI/CD?
Serverless is simple. Do I need CI/CD?
Google Cloud Tech
53 Accelerating model deployment with MLOps
Accelerating model deployment with MLOps
Google Cloud Tech
54 How Hawaii's Department of Human Services scaled with CCAI
How Hawaii's Department of Human Services scaled with CCAI
Google Cloud Tech
55 Pricing API on our #Radar
Pricing API on our #Radar
Google Cloud Tech
56 How Recommendations AI for Media can boost customer retention
How Recommendations AI for Media can boost customer retention
Google Cloud Tech
57 Troubleshooting: Node Not Ready Status
Troubleshooting: Node Not Ready Status
Google Cloud Tech
58 One weekend until Cloud Next 2023!
One weekend until Cloud Next 2023!
Google Cloud Tech
59 #GoogleCloudNext starts tomorrow!
#GoogleCloudNext starts tomorrow!
Google Cloud Tech
60 #GoogleCloudNext will be demand!
#GoogleCloudNext will be demand!
Google Cloud Tech

MCP Toolbox for databases is an open-source MCP server that simplifies the connection between AI agents and databases, providing a standardized way for AI agents to communicate with tools and enhancing security and performance. The toolbox supports a broad number of databases and includes contributions for third-party databases, with client SDK and integrations for popular frameworks. By using MCP Toolbox, developers can build AI agents that interact with databases and develop applications that

Key Takeaways
  1. Explore the MCP Toolbox for databases on GitHub
  2. Dive into the documentation to learn more about the toolbox
  3. Use the ADK Agent Development Kit to build intelligent agents
  4. Configure the forecasting agent to load tools from the toolbox
  5. Interact with the forecasting agent using the ADK's forecasting UI
  6. Add or update forecasting capabilities by updating the tools.yml file
  7. Restart the MCP server to apply changes
💡 The MCP Toolbox for databases provides a standardized way for AI agents to communicate with tools, enhancing security and performance, and simplifying the development of AI agents that interact with databases.

Related Reads

📰
The Math Behind Every AI Agent: A Beginner’s Guide to LLM Intelligence
Learn the mathematical foundations behind LLM intelligence and why prompting alone is not enough for optimal results
Medium · AI
📰
The Math Behind Every AI Agent: A Beginner’s Guide to LLM Intelligence
Learn the math behind LLM intelligence and why prompting alone is not enough for AI agents
Medium · Machine Learning
📰
I Used AI for 30 Days Instead of Google. Here’s What Actually Changed
Replace Google with AI for 30 days to discover new ways of finding information and experience the benefits and limitations of AI-powered search
Medium · ChatGPT
📰
Changes to LLM pricing: Novita and StreamLake
Learn about the pricing changes for Novita and StreamLake LLMs and how they impact your projects
Dev.to AI
Up next
5 Levels of AI Agents - From Simple LLM Calls to Multi-Agent Systems
Dave Ebbelaar (LLM Eng)
Watch →