histogram

Visualize data distribution by creating histograms from SQL queries on CSV or Parquet sources. Specify a column, optional color dimension, and bin count to generate actionable insights for analytics on Zaturn.

Instructions

Run query against specified source and make a histogram 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
`color`	No	Optional; column name from SQL result to use for drawing multiple colored histograms representing another dimension
`column`	Yes	Column name from SQL result to use for the histogram
`nbins`	No	Optional; number of bins
`query`	Yes	SQL query to run on the data source
`source_id`	Yes	The data source to run the query on

Input Schema (JSON Schema)

{
  "properties": {
    "color": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Optional; column name from SQL result to use for drawing multiple colored histograms representing another dimension",
      "title": "Color"
    },
    "column": {
      "description": "Column name from SQL result to use for the histogram",
      "title": "Column",
      "type": "string"
    },
    "nbins": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Optional; number of bins",
      "title": "Nbins"
    },
    "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"
    }
  },
  "required": [
    "source_id",
    "query",
    "column"
  ],
  "type": "object"
}

Zaturn

histogram

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Zaturn

Related Tools

MCP directory API