query_and_plotly_chart
Extract data with SQL queries and visualize it using Plotly charts for dynamic UI display, connecting directly to StarRocks databases via the MCP server.
Instructions
using sql query to extract data from database, then using python plotly_expr to generate a chart for UI to display
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| plotly_expr | Yes | 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")` | |
| query | Yes | SQL query to execute |