← WebMCP Directory

Tool tree

strategyshifu.com

Developer ToolsTools verified
Website
An agent-ready decision engine for regional Databricks SQL warehouse sizing and pricing.
Explore capabilities

    page: Home

    get_decision_stateAnswer

    Read the project workloads, active workload, requirements, budget, regional assumptions, and current recommendation.

    View tool JSON
    {
      "name": "get_decision_state",
      "kind": "answer",
      "impl": "imperative",
      "description": "Read the project workloads, active workload, requirements, budget, regional assumptions, and current recommendation.",
      "page": "/"
    }
    list_workloadsAnswer

    List every configured workload and identify the workload currently being edited.

    View tool JSON
    {
      "name": "list_workloads",
      "kind": "answer",
      "impl": "imperative",
      "description": "List every configured workload and identify the workload currently being edited.",
      "page": "/"
    }
    add_workloadAction

    Add a named DWH, ETL, or development workload with category-appropriate defaults and select it for editing.

    View tool JSON
    {
      "name": "add_workload",
      "kind": "act",
      "impl": "imperative",
      "description": "Add a named DWH, ETL, or development workload with category-appropriate defaults and select it for editing.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "name": {
            "type": "string",
            "minLength": 1,
            "maxLength": 120,
            "description": "Human-readable workload name shown in the workspace."
          },
          "type": {
            "type": "string",
            "enum": [
              "DWH",
              "ETL",
              "DEV"
            ],
            "description": "DWH for SQL/BI, ETL for jobs, or DEV for interactive development."
          }
        },
        "additionalProperties": false
      },
      "page": "/"
    }
    update_workloadAction

    Update a workload's identity, category, compute, sizing, or chat/NLP requirement. Set naturalLanguageAnalytics=true when users ask natural-language questions over data so Genie-capable Serverless and Pro options are highlighted.

    View tool JSON
    {
      "name": "update_workload",
      "kind": "act",
      "impl": "imperative",
      "description": "Update a workload's identity, category, compute, sizing, or chat/NLP requirement. Set naturalLanguageAnalytics=true when users ask natural-language questions over data so Genie-capable Serverless and Pro options are highlighted.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "workloadId": {
            "type": "string"
          },
          "name": {
            "type": "string",
            "minLength": 1,
            "maxLength": 120,
            "description": "Human-readable workload name shown in the workspace."
          },
          "type": {
            "type": "string",
            "enum": [
              "DWH",
              "ETL",
              "DEV"
            ],
            "description": "DWH for SQL/BI, ETL for jobs, or DEV for interactive development."
          },
          "computeId": {
            "type": "string",
            "enum": [
              "serverless-sql",
              "pro-sql",
              "classic-sql",
              "jobs-classic",
              "jobs-serverless",
              "all-purpose-classic"
            ],
            "description": "Compute option compatible with the workload type."
          },
          "naturalLanguageAnalytics": {
            "type": "boolean",
            "description": "Set true when users need chat-based or NLP questions over data; this requires Databricks Genie on Serverless or Pro SQL."
          },
          "warehouseSize": {
            "type": "string",
            "enum": [
              "2X-Small",
              "X-Small",
              "Small",
              "Medium",
              "Large",
              "X-Large",
              "2X-Large",
              "3X-Large",
              "4X-Large",
              "5X-Large"
            ]
          },
          "driverInstance": {
            "type": "string"
          },
          "workerInstance": {
            "type": "string"
          },
          "workerCount": {
            "type": "integer",
            "minimum": 1,
            "maximum": 1000
          },
          "pipelines": {
            "type": "integer",
            "minimum": 1,
            "maximum": 1000
          },
          "serverlessDbuPerHour": {
            "type": "number",
            "minimum": 0.01,
            "maximum": 10000
          }
        },
        "required": [
          "workloadId"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    remove_workloadAction

    Remove one workload from the project. The final remaining workload cannot be removed.

    View tool JSON
    {
      "name": "remove_workload",
      "kind": "act",
      "impl": "imperative",
      "description": "Remove one workload from the project. The final remaining workload cannot be removed.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "workloadId": {
            "type": "string"
          }
        },
        "required": [
          "workloadId"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    select_workloadAction

    Choose which configured workload the UI and comparison field should focus on.

    View tool JSON
    {
      "name": "select_workload",
      "kind": "act",
      "impl": "imperative",
      "description": "Choose which configured workload the UI and comparison field should focus on.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "workloadId": {
            "type": "string"
          }
        },
        "required": [
          "workloadId"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    set_requirementAction

    Update the cloud or private-networking requirement. Changing cloud normalizes cluster instances and selects a valid region.

    View tool JSON
    {
      "name": "set_requirement",
      "kind": "act",
      "impl": "imperative",
      "description": "Update the cloud or private-networking requirement. Changing cloud normalizes cluster instances and selects a valid region.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "cloud": {
            "type": "string",
            "enum": [
              "AWS",
              "Azure",
              "GCP"
            ]
          },
          "privateNetworking": {
            "type": "boolean"
          }
        },
        "additionalProperties": false
      },
      "page": "/"
    }
    set_regionAction

    Set the provider-native region used for every workload's DBU and VM rates.

    View tool JSON
    {
      "name": "set_region",
      "kind": "act",
      "impl": "imperative",
      "description": "Set the provider-native region used for every workload's DBU and VM rates.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "region": {
            "type": "string"
          }
        },
        "required": [
          "region"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    set_budgetAction

    Set the monthly USD budget applied to the complete project of configured workloads.

    View tool JSON
    {
      "name": "set_budget",
      "kind": "act",
      "impl": "imperative",
      "description": "Set the monthly USD budget applied to the complete project of configured workloads.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "monthlyBudgetUsd": {
            "type": "number",
            "minimum": 1,
            "description": "Complete project budget per month in USD."
          }
        },
        "required": [
          "monthlyBudgetUsd"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    update_projectAction

    Update the project name or switch the displayed cost period between monthly and annual.

    View tool JSON
    {
      "name": "update_project",
      "kind": "act",
      "impl": "imperative",
      "description": "Update the project name or switch the displayed cost period between monthly and annual.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "projectName": {
            "type": "string",
            "minLength": 1,
            "maxLength": 120
          },
          "costPeriod": {
            "type": "string",
            "enum": [
              "monthly",
              "annual"
            ]
          }
        },
        "additionalProperties": false
      },
      "page": "/"
    }
    set_currencyAction

    Switch displayed budgets and estimates between USD and INR. Ranking remains in canonical USD.

    View tool JSON
    {
      "name": "set_currency",
      "kind": "act",
      "impl": "imperative",
      "description": "Switch displayed budgets and estimates between USD and INR. Ranking remains in canonical USD.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "currency": {
            "type": "string",
            "enum": [
              "USD",
              "INR"
            ]
          },
          "usdToInrRate": {
            "type": "number",
            "minimum": 1
          }
        },
        "required": [
          "currency"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    set_workload_scheduleAction

    Update runtime for one workload. Schedule affects cost but does not change workload category.

    View tool JSON
    {
      "name": "set_workload_schedule",
      "kind": "act",
      "impl": "imperative",
      "description": "Update runtime for one workload. Schedule affects cost but does not change workload category.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "workloadId": {
            "type": "string"
          },
          "hoursPerDay": {
            "type": "integer",
            "minimum": 1,
            "maximum": 24
          },
          "daysPerMonth": {
            "type": "integer",
            "minimum": 1,
            "maximum": 31
          }
        },
        "required": [
          "workloadId"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    set_dwh_sizingAction

    Set the warehouse size for a DWH workload.

    View tool JSON
    {
      "name": "set_dwh_sizing",
      "kind": "act",
      "impl": "imperative",
      "description": "Set the warehouse size for a DWH workload.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "workloadId": {
            "type": "string"
          },
          "warehouseSize": {
            "type": "string",
            "enum": [
              "2X-Small",
              "X-Small",
              "Small",
              "Medium",
              "Large",
              "X-Large",
              "2X-Large",
              "3X-Large",
              "4X-Large",
              "5X-Large"
            ]
          }
        },
        "required": [
          "workloadId",
          "warehouseSize"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    get_pricing_optionsAnswer

    Inspect compute, sizing, DBU, and VM options for a workload category in the active cloud and region.

    View tool JSON
    {
      "name": "get_pricing_options",
      "kind": "answer",
      "impl": "imperative",
      "description": "Inspect compute, sizing, DBU, and VM options for a workload category in the active cloud and region.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "workloadType": {
            "type": "string",
            "enum": [
              "DWH",
              "ETL",
              "DEV"
            ]
          }
        },
        "required": [
          "workloadType"
        ],
        "additionalProperties": false
      },
      "page": "/"
    }
    compare_strategiesAction

    Compare category-valid compute options for the selected workload against technical requirements and total project budget.

    View tool JSON
    {
      "name": "compare_strategies",
      "kind": "act",
      "impl": "imperative",
      "description": "Compare category-valid compute options for the selected workload against technical requirements and total project budget.",
      "page": "/"
    }
    get_cost_estimatesAnswer

    Return configured monthly pricing components for every workload and the total project.

    View tool JSON
    {
      "name": "get_cost_estimates",
      "kind": "answer",
      "impl": "imperative",
      "description": "Return configured monthly pricing components for every workload and the total project.",
      "page": "/"
    }
    get_recommendationAnswer

    Return the best compute option for the active workload that satisfies technical constraints and total project budget.

    View tool JSON
    {
      "name": "get_recommendation",
      "kind": "answer",
      "impl": "imperative",
      "description": "Return the best compute option for the active workload that satisfies technical constraints and total project budget.",
      "page": "/"
    }

    page: Redshift to databricks

    get_redshift_iceberg_capabilitiesAnswer

    Validate current Redshift Iceberg versions, DML operations, and limitations against official documentation.

    View tool JSON
    {
      "name": "get_redshift_iceberg_capabilities",
      "kind": "answer",
      "impl": "imperative",
      "description": "Validate current Redshift Iceberg versions, DML operations, and limitations against official documentation.",
      "page": "/migrate/redshift-to-databricks"
    }
    get_databricks_iceberg_capabilitiesAnswer

    Validate managed and foreign Iceberg read/write behavior in Databricks.

    View tool JSON
    {
      "name": "get_databricks_iceberg_capabilities",
      "kind": "answer",
      "impl": "imperative",
      "description": "Validate managed and foreign Iceberg read/write behavior in Databricks.",
      "page": "/migrate/redshift-to-databricks"
    }
    get_lakehouse_federation_redshift_capabilitiesAnswer

    Validate current Lakehouse Federation support, access mode, use cases, and limits for Redshift.

    View tool JSON
    {
      "name": "get_lakehouse_federation_redshift_capabilities",
      "kind": "answer",
      "impl": "imperative",
      "description": "Validate current Lakehouse Federation support, access mode, use cases, and limits for Redshift.",
      "page": "/migrate/redshift-to-databricks"
    }
    get_redshift_export_optionsAnswer

    Validate current scalable Redshift bulk-export mechanisms and columnar output support.

    View tool JSON
    {
      "name": "get_redshift_export_options",
      "kind": "answer",
      "impl": "imperative",
      "description": "Validate current scalable Redshift bulk-export mechanisms and columnar output support.",
      "page": "/migrate/redshift-to-databricks"
    }
    get_migration_assessmentAnswer

    Read the current Redshift-to-Databricks inputs, deterministic scores, recommendation, risks, alternative, steps, and architecture.

    View tool JSON
    {
      "name": "get_migration_assessment",
      "kind": "answer",
      "impl": "imperative",
      "description": "Read the current Redshift-to-Databricks inputs, deterministic scores, recommendation, risks, alternative, steps, and architecture.",
      "page": "/migrate/redshift-to-databricks"
    }
    update_migration_inputsAction

    Update one or more advisor inputs; the StrategyShifu scoring engine will immediately recalculate the recommendation.

    View tool JSON
    {
      "name": "update_migration_inputs",
      "kind": "act",
      "impl": "imperative",
      "description": "Update one or more advisor inputs; the StrategyShifu scoring engine will immediately recalculate the recommendation.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "dataSizeGb": {
            "type": "number",
            "minimum": 0,
            "description": "Total source data volume in GB."
          },
          "tableCount": {
            "type": "integer",
            "minimum": 0,
            "description": "Number of source tables in migration scope."
          },
          "largestTableGb": {
            "type": "number",
            "minimum": 0,
            "description": "Largest in-scope source table size in GB."
          },
          "dailyChangeRate": {
            "type": "string",
            "enum": [
              "< 1%",
              "1–5%",
              "5–20%",
              "> 20%",
              "Unknown"
            ]
          },
          "writePattern": {
            "type": "string",
            "enum": [
              "Mostly append",
              "MERGE / upsert",
              "Frequent UPDATE",
              "Frequent DELETE",
              "Mixed workload",
              "Mostly read-only"
            ]
          },
          "redshiftSqlComplexity": {
            "type": "string",
            "enum": [
              "Low",
              "Medium",
              "High",
              "Unknown"
            ]
          },
          "keepRedshiftActive": {
            "type": "boolean"
          },
          "coexistenceDuration": {
            "type": "string",
            "enum": [
              "< 1 month",
              "1–3 months",
              "3–6 months",
              "> 6 months",
              "Unknown"
            ]
          },
          "downtimeTolerance": {
            "type": "string",
            "enum": [
              "Near zero",
              "< 1 hour",
              "< 1 day",
              "Multiple days acceptable"
            ]
          },
          "sharedS3Available": {
            "type": "string",
            "enum": [
              "Yes",
              "No",
              "Unknown"
            ]
          },
          "targetState": {
            "type": "string",
            "enum": [
              "Databricks becomes primary platform",
              "Long-term Redshift + Databricks coexistence",
              "Evaluate Databricks before migration",
              "Only move selected workloads",
              "Not decided"
            ]
          },
          "targetFormat": {
            "type": "string",
            "enum": [
              "Delta Lake",
              "Iceberg",
              "No preference",
              "Not decided"
            ]
          },
          "migrationPriority": {
            "type": "string",
            "enum": [
              "Data pipelines / ETL",
              "BI and reporting",
              "Selected workload POC",
              "Not decided"
            ]
          },
          "changeSyncPlan": {
            "type": "string",
            "enum": [
              "Write freeze",
              "Scheduled incremental loads",
              "CDC / replication tool",
              "Dual-write",
              "No plan",
              "Unknown"
            ]
          },
          "specialDataTypes": {
            "type": "string",
            "enum": [
              "None known",
              "Some",
              "Extensive",
              "Unknown"
            ]
          }
        },
        "additionalProperties": false
      },
      "page": "/migrate/redshift-to-databricks"
    }
    assess_redshift_databricks_migrationAction

    Apply supplied migration inputs to the visible workspace, then combine deterministic scoring with current AWS and Databricks capability evidence.

    View tool JSON
    {
      "name": "assess_redshift_databricks_migration",
      "kind": "act",
      "impl": "imperative",
      "description": "Apply supplied migration inputs to the visible workspace, then combine deterministic scoring with current AWS and Databricks capability evidence.",
      "inputSchema": {
        "type": "object",
        "properties": {
          "dataSizeGb": {
            "type": "number",
            "minimum": 0,
            "description": "Total source data volume in GB."
          },
          "tableCount": {
            "type": "integer",
            "minimum": 0,
            "description": "Number of source tables in migration scope."
          },
          "largestTableGb": {
            "type": "number",
            "minimum": 0,
            "description": "Largest in-scope source table size in GB."
          },
          "dailyChangeRate": {
            "type": "string",
            "enum": [
              "< 1%",
              "1–5%",
              "5–20%",
              "> 20%",
              "Unknown"
            ]
          },
          "writePattern": {
            "type": "string",
            "enum": [
              "Mostly append",
              "MERGE / upsert",
              "Frequent UPDATE",
              "Frequent DELETE",
              "Mixed workload",
              "Mostly read-only"
            ]
          },
          "redshiftSqlComplexity": {
            "type": "string",
            "enum": [
              "Low",
              "Medium",
              "High",
              "Unknown"
            ]
          },
          "keepRedshiftActive": {
            "type": "boolean"
          },
          "coexistenceDuration": {
            "type": "string",
            "enum": [
              "< 1 month",
              "1–3 months",
              "3–6 months",
              "> 6 months",
              "Unknown"
            ]
          },
          "downtimeTolerance": {
            "type": "string",
            "enum": [
              "Near zero",
              "< 1 hour",
              "< 1 day",
              "Multiple days acceptable"
            ]
          },
          "sharedS3Available": {
            "type": "string",
            "enum": [
              "Yes",
              "No",
              "Unknown"
            ]
          },
          "targetState": {
            "type": "string",
            "enum": [
              "Databricks becomes primary platform",
              "Long-term Redshift + Databricks coexistence",
              "Evaluate Databricks before migration",
              "Only move selected workloads",
              "Not decided"
            ]
          },
          "targetFormat": {
            "type": "string",
            "enum": [
              "Delta Lake",
              "Iceberg",
              "No preference",
              "Not decided"
            ]
          },
          "migrationPriority": {
            "type": "string",
            "enum": [
              "Data pipelines / ETL",
              "BI and reporting",
              "Selected workload POC",
              "Not decided"
            ]
          },
          "changeSyncPlan": {
            "type": "string",
            "enum": [
              "Write freeze",
              "Scheduled incremental loads",
              "CDC / replication tool",
              "Dual-write",
              "No plan",
              "Unknown"
            ]
          },
          "specialDataTypes": {
            "type": "string",
            "enum": [
              "None known",
              "Some",
              "Extensive",
              "Unknown"
            ]
          }
        },
        "additionalProperties": false
      },
      "page": "/migrate/redshift-to-databricks"
    }