drio
Open app

Snowflake Cube Server

Source

MCP Server for Interacting with Cube Semantic Layers

Catalog onlyCatalog onlySTDIO

Overview

Snowflake Cube Server is an MCP server designed for interacting with Cube semantic layers, allowing users to access and manipulate data in a structured format.

To use the Snowflake Cube Server, you can send queries to the Cube REST API using the provided tools, such as read_data and describe_data, to retrieve and describe data from the Cube deployment.

  • Interacts with Cube semantic layers for data manipulation - Provides tools for reading and describing data - Returns data in JSON and YAML formats for easy processing
  1. Accessing structured data from Cube deployments for analysis.
  2. Integrating with other applications that require data from Cube layers.
  3. Facilitating data exploration and visualization through API calls.

Add to your AI client

Use these steps to connect Snowflake Cube Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "mcp-cube-server-isaacwasserman": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-cube-server-isaacwasserman"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "mcp-cube-server-isaacwasserman": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-cube-server-isaacwasserman"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "mcp-cube-server-isaacwasserman": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-cube-server-isaacwasserman"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "mcp-cube-server-isaacwasserman": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-cube-server-isaacwasserman"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-cube-server-isaacwasserman": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-cube-server-isaacwasserman"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "mcp-cube-server-isaacwasserman": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-cube-server-isaacwasserman"
      ]
    }
  }
}

FAQ

What types of data can I access with Snowflake Cube Server?

You can access any data available in the Cube deployment that is structured and defined within the semantic layers.

Is there a limit to the number of queries I can send?

There may be rate limits depending on your Cube deployment configuration, but generally, you can send multiple queries as needed.

Can I use Snowflake Cube Server for real-time data access?

Yes, Snowflake Cube Server is designed to provide timely access to data, depending on the underlying Cube deployment.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":1536,"uuid":"056085c3-12c1-4000-b254-03f630033a9a","name":"mcp_cube_server","title":"Snowflake Cube Server","description":"MCP Server for Interacting with Cube Semantic Layers","avatar_url":"https://avatars.githubusercontent.com/u/1498116?v=4","created_at":"2025-02-20T16:18:14.639Z","updated_at":"2025-02-23T07:22:06.428Z","status":"created","author_name":"isaacwasserman","author_avatar_url":"https://avatars.githubusercontent.com/u/1498116?v=4","tags":"mcp_cube_server,cube-semantic-layers,data-interaction","category":"research-and-data","is_featured":false,"sort":1,"url":"https://github.com/isaacwasserman/mcp_cube_server","target":"_self","content":"$29","summary":"$2a","img_url":"https://camo.githubusercontent.com/19f9a9f46e180ea83ce4f9f71213e38c91633dafc19f7b8f028d3b6b643eccfe/68747470733a2f2f736d6974686572792e61692f62616467652f4069736161637761737365726d616e2f6d63705f637562655f736572766572","type":null,"metadata":null,"user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Research and data