UBOS Asset Marketplace: Unleashing AI on Google Cloud Storage with the MCP Server

In the rapidly evolving landscape of Artificial Intelligence (AI), the ability for Large Language Models (LLMs) to access and interpret real-world data is paramount. The UBOS Asset Marketplace offers a powerful solution: the Model Context Protocol (MCP) Server for Google Cloud Storage (GCS). This innovative tool bridges the gap between LLMs like Claude and your data residing in Google Cloud Storage, enabling seamless integration and AI-driven insights.

The Challenge: Connecting LLMs to Real-World Data

LLMs, while powerful, are inherently limited by their training data. To truly leverage the potential of AI, these models need access to current, relevant, and often proprietary data sources. Traditional methods of integrating LLMs with external data sources often involve complex APIs, custom code, and significant engineering effort. This complexity can be a major barrier to adoption, especially for organizations lacking specialized AI expertise.

The Solution: The UBOS MCP Server for Google Cloud Storage

The MCP Server for Google Cloud Storage, available on the UBOS Asset Marketplace, simplifies the process of connecting LLMs to your GCS data. Based on CData’s Model Context Protocol (MCP), this server acts as a translator, allowing LLMs to query GCS data using natural language. Instead of writing complex SQL queries or grappling with intricate APIs, users can simply ask questions in plain English and receive accurate, up-to-date information.

This particular server is a read-only implementation. For full read, write, update, delete, and action capabilities, CData offers a free (beta) MCP Server for Google Cloud Storage, which can be found at CData MCP Server for Google Cloud Storage (beta).

Key Features and Benefits:

• Seamless Integration: Effortlessly connect LLMs like Claude to your Google Cloud Storage data without the need for complex coding or API integrations.
• Natural Language Querying: Enable users to query GCS data using natural language, eliminating the need for SQL or other technical skills.
• Real-Time Data Access: Provide LLMs with access to live, up-to-date data from your GCS buckets, ensuring accurate and relevant insights.
• Simplified Data Exploration: Empower users to explore and understand their GCS data more easily, uncovering hidden patterns and trends.
• Enhanced AI Capabilities: Unlock new possibilities for AI-powered applications, such as data analysis, reporting, and decision-making.
• Cost-Effective: Reduce the time and resources required to integrate LLMs with GCS data, lowering the overall cost of AI adoption.
• Based on Open Standards: Built on the open Model Context Protocol (MCP), ensuring interoperability and future-proofing your AI infrastructure.
• Secure Data Access: Leverages the security features of the CData JDBC Driver for Google Cloud Storage to ensure secure access to your data.
• Rapid Deployment: Quickly deploy the MCP Server and start querying your GCS data with LLMs in a matter of minutes.

Use Cases: Transforming Data into Actionable Insights

The MCP Server for Google Cloud Storage unlocks a wide range of use cases across various industries and applications. Here are a few examples:

• Business Intelligence: Ask questions about your sales data stored in GCS to identify top-performing products, customer segments, or sales regions. For example, “What is the correlation between closed won opportunities and the account industry?”
• Customer Support: Analyze customer support logs stored in GCS to identify common issues, prioritize tickets, and improve customer satisfaction. For example, “How many open tickets do I have in the SUPPORT project?”
• Marketing Analytics: Gain insights from your marketing campaign data stored in GCS to optimize ad spend, personalize customer experiences, and improve ROI.
• Financial Analysis: Analyze financial data stored in GCS to identify trends, detect anomalies, and make better investment decisions.
• Supply Chain Management: Track inventory levels, monitor shipments, and optimize logistics using data stored in GCS.
• Data Exploration & Discovery: Allow data scientists and analysts to quickly explore and understand large datasets stored in GCS, accelerating the process of data discovery and insight generation.

Getting Started: A Step-by-Step Guide

Setting up the MCP Server for Google Cloud Storage is a straightforward process. Here’s a summary of the steps involved:

1. Clone the Repository: Clone the project repository from GitHub: git clone https://github.com/cdatasoftware/google-cloud-storage-mcp-server-by-cdata.git

2. Build the Server: Use Maven to build the server: mvn clean install. This will create the JAR file CDataMCP-jar-with-dependencies.jar.

3. Download and License the CData JDBC Driver: Download the CData JDBC Driver for Google Cloud Storage from https://www.cdata.com/drivers/googlecloudstorage/download/jdbc and license it using the command java -jar cdata.jdbc.googlecloudstorage.jar --license in the driver’s lib folder.

4. Configure the Connection: Use the CData JDBC Driver’s Connection String utility (java -jar cdata.jdbc.googlecloudstorage.jar) to configure the connection to your Google Cloud Storage data. Test the connection and copy the connection string.

5. Create a .prp File: Create a .prp file (e.g., google-cloud-storage.prp) with the following properties:

   • Prefix: A prefix for the tools exposed (e.g., googlecloudstorage).
   • ServerName: A name for your server (e.g., CDataGoogleCloudStorage).
   • ServerVersion: A version for your server (e.g., 1.0).
   • DriverPath: The full path to the CData JDBC Driver JAR file.
   • DriverClass: The name of the JDBC Driver Class (cdata.jdbc.googlecloudstorage.GoogleCloudStorageDriver).
   • JdbcUrl: The JDBC connection string you copied earlier.
   • Tables: Leave blank to access all tables, or specify a comma-separated list of tables to access.

   env Prefix=googlecloudstorage ServerName=CDataGoogleCloudStorage ServerVersion=1.0 DriverPath=PATHTOcdata.jdbc.googlecloudstorage.jar DriverClass=cdata.jdbc.googlecloudstorage.GoogleCloudStorageDriver JdbcUrl=jdbc:googlecloudstorage:InitiateOAuth=GETANDREFRESH; Tables=

6. Configure Claude Desktop (Optional): If you’re using Claude Desktop, create or modify the claude_desktop_config.json file to add the new MCP server. The location of this file varies depending on your operating system (see documentation for details).

7. Run the Server: Run the MCP Server using the command java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

Leveraging the UBOS Platform for Enhanced AI Agent Development

While the MCP Server provides a crucial bridge between LLMs and your data, the UBOS platform offers a comprehensive ecosystem for building and deploying AI Agents. UBOS empowers you to:

• Orchestrate AI Agents: Design complex workflows involving multiple AI Agents, each specialized for a specific task.
• Connect to Enterprise Data: Seamlessly integrate AI Agents with your existing data sources, including databases, cloud storage, and APIs.
• Build Custom AI Agents: Develop custom AI Agents tailored to your specific business needs, leveraging your own LLM models and data.
• Create Multi-Agent Systems: Build sophisticated AI systems that combine the strengths of multiple AI Agents to solve complex problems.

By combining the MCP Server with the UBOS platform, you can unlock the full potential of AI and transform your data into actionable insights.

Tools Provided by the MCP Server

The MCP Server exposes a set of tools that LLMs can use to interact with your Google Cloud Storage data. These tools include:

• {servername}_get_tables: Retrieves a list of tables available in the data source. Use the {servername}_get_columns tool to list available columns on a table. The output of the tool will be returned in CSV format, with the first line containing column headers.
• {servername}_get_columns: Retrieves a list of columns for a table. Use the {servername}_get_tables tool to get a list of available tables. The output of the tool will be returned in CSV format, with the first line containing column headers.
• {servername}_run_query: Execute a SQL SELECT query

JSON-RPC Request Examples

For developers who prefer to script requests directly, the MCP Server supports the JSON-RPC 2.0 specification. Here are some examples of JSON payloads for calling the available tools:

google_cloud_storage_get_tables

{ “jsonrpc”: “2.0”, “id”: 1, “method”: “tools/call”, “params”: { “name”: “google_cloud_storage_get_tables”, “arguments”: {} } }

google_cloud_storage_get_columns

{ “jsonrpc”: “2.0”, “id”: 2, “method”: “tools/call”, “params”: { “name”: “google_cloud_storage_get_columns”, “arguments”: { “table”: “Account” } } }

google_cloud_storage_run_query

{ “jsonrpc”: “2.0”, “id”: 3, “method”: “tools/call”, “params”: { “name”: “google_cloud_storage_run_query”, “arguments”: { “sql”: “SELECT * FROM [Account] WHERE [IsDeleted] = true” } } }

Troubleshooting

If you encounter any issues, here are some troubleshooting tips:

• Server Not Visible in Claude Desktop: Ensure you have fully quit and restarted Claude Desktop.
• Data Retrieval Issues: Verify your connection configuration and ensure the connection string in the .prp file is correct.
• Connection Problems: Contact the CData Support Team for assistance with data source connectivity.
• MCP Server Feedback: Join the CData Community to share feedback or seek help with the MCP Server.

Conclusion: Empowering AI with Data Connectivity

The UBOS Asset Marketplace’s MCP Server for Google Cloud Storage provides a simple, secure, and cost-effective way to connect LLMs to your GCS data. By enabling natural language querying and real-time data access, this tool empowers you to unlock new possibilities for AI-powered applications and gain actionable insights from your data. Combine it with the UBOS platform’s comprehensive AI Agent development capabilities to build truly transformative AI solutions for your business.