bar_plot

Analyze and visualize data by running SQL queries on CSV or Parquet sources and generating bar plots. Specify columns for x and y axes, add color for dimension, and choose plot orientation.

Instructions

Run query against specified source and make a bar plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.

This will return an image of the plot

Input Schema

Name	Required	Description	Default
`color`	No	Optional column name from SQL result to use as a 3rd dimension by splitting each bar into colored sections
`orientation`	No	Orientation of the box plot, use 'v' for vertical (default) and 'h' for horizontal. Be mindful of choosing the correct X and Y columns as per orientation	v
`query`	Yes	SQL query to run on the data source
`source_id`	Yes	The data source to run the query on
`x`	Yes	Column name from SQL result to use for x-axis
`y`	Yes	Column name from SQL result to use for y-axis

Input Schema (JSON Schema)

{
  "properties": {
    "color": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Optional column name from SQL result to use as a 3rd dimension by splitting each bar into colored sections",
      "title": "Color"
    },
    "orientation": {
      "default": "v",
      "description": "Orientation of the box plot, use 'v' for vertical (default) and 'h' for horizontal. Be mindful of choosing the correct X and Y columns as per orientation",
      "title": "Orientation",
      "type": "string"
    },
    "query": {
      "description": "SQL query to run on the data source",
      "title": "Query",
      "type": "string"
    },
    "source_id": {
      "description": "The data source to run the query on",
      "title": "Source Id",
      "type": "string"
    },
    "x": {
      "description": "Column name from SQL result to use for x-axis",
      "title": "X",
      "type": "string"
    },
    "y": {
      "description": "Column name from SQL result to use for y-axis",
      "title": "Y",
      "type": "string"
    }
  },
  "required": [
    "source_id",
    "query",
    "x",
    "y"
  ],
  "type": "object"
}

Zaturn

bar_plot

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Zaturn

Related Tools

MCP directory API