StarRocks MCP Server

Official
Apache 2.0
20

query_and_plotly_chart

Execute SQL queries to extract data from a StarRocks database and generate interactive Plotly charts for visualization using a simple Python expression.

Instructions

using sql query to extract data from database, then using python plotly_expr to generate a chart for UI to display

Input Schema

NameRequiredDescriptionDefault
plotly_exprNoa one function call expression, with 2 vars binded: `px` as `import plotly.express as px`, and `df` as dataframe generated by query `plotly_expr` example: `px.scatter(df, x="sepal_width", y="sepal_length", color="species", marginal_y="violin", marginal_x="box", trendline="ols", template="simple_white")`
queryNoSQL query to execute

Input Schema (JSON Schema)

{ "properties": { "plotly_expr": { "description": "a one function call expression, with 2 vars binded: `px` as `import plotly.express as px`, and `df` as dataframe generated by query `plotly_expr` example: `px.scatter(df, x=\"sepal_width\", y=\"sepal_length\", color=\"species\", marginal_y=\"violin\", marginal_x=\"box\", trendline=\"ols\", template=\"simple_white\")`", "type": "string" }, "query": { "description": "SQL query to execute", "type": "string" } }, "type": "object" }

You must be authenticated.

Other Tools from StarRocks MCP Server

Related Tools

ID: mgys7ofvs0