J

jsonstat.com

A JSON-stat dataset explorer: fetch any JSON-stat endpoint (GET or POST) and browse it as an interactive table. WebMCP tools let an agent load a dataset or pick one from a bundle, pivot/filter/sort the table, search cells, export CSV, and read the dataset's metadata, dimensions, and view summary.

7read
5action
https://jsonstat.com/webmcp/

live · Developer Tools · JSON · API for agents

Tools 12 tools

fetch_datasetaction

Fetch a JSON-stat dataset from a URL. Supports both GET and POST requests. For POST requests, provide a JSON payload.

View tool JSON
{
  "name": "fetch_dataset",
  "kind": "action",
  "impl": "imperative",
  "description": "Fetch a JSON-stat dataset from a URL. Supports both GET and POST requests. For POST requests, provide a JSON payload.",
  "inputSchema": {
    "type": "object",
    "properties": {
      "url": {
        "type": "string",
        "description": "The URL of the JSON-stat dataset endpoint to fetch"
      },
      "payload": {
        "type": "object",
        "description": "Optional JSON payload for POST requests"
      }
    },
    "required": [
      "url"
    ]
  }
}
select_datasetaction

Select a specific dataset from a loaded bundle or collection. Use this after loading a bundle with fetch_dataset.

View tool JSON
{
  "name": "select_dataset",
  "kind": "action",
  "impl": "imperative",
  "description": "Select a specific dataset from a loaded bundle or collection. Use this after loading a bundle with fetch_dataset.",
  "inputSchema": {
    "type": "object",
    "properties": {
      "datasetIndex": {
        "type": "number",
        "description": "The index of the dataset to select (0-based)",
        "minimum": 0
      }
    },
    "required": [
      "datasetIndex"
    ]
  }
}
set_view_modeaction

Switch between flat (value list) and pivot (cross-tabulation) view modes. Flat mode shows all dimensions as rows, pivot mode allows cross-tabulation.

View tool JSON
{
  "name": "set_view_mode",
  "kind": "action",
  "impl": "imperative",
  "description": "Switch between flat (value list) and pivot (cross-tabulation) view modes. Flat mode shows all dimensions as rows, pivot mode allows cross-tabulation.",
  "inputSchema": {
    "type": "object",
    "properties": {
      "mode": {
        "type": "string",
        "enum": [
          "flat",
          "pivot"
        ],
        "description": "The view mode to set: 'flat' for value list, 'pivot' for cross-tabulation"
      }
    },
    "required": [
      "mode"
    ]
  }
}
set_dimension_roleaction

Set the role of a dimension for data visualization. In flat mode, use 'row'. In pivot mode, use 'row' or 'column'.

View tool JSON
{
  "name": "set_dimension_role",
  "kind": "action",
  "impl": "imperative",
  "description": "Set the role of a dimension for data visualization. In flat mode, use 'row'. In pivot mode, use 'row' or 'column'.",
  "inputSchema": {
    "type": "object",
    "properties": {
      "dimensionId": {
        "type": "string",
        "description": "The ID of the dimension to set the role for"
      },
      "role": {
        "type": "string",
        "enum": [
          "row",
          "column"
        ],
        "description": "The role to set: 'row' to show as row, 'column' to show as column (pivot only)"
      }
    },
    "required": [
      "dimensionId",
      "role"
    ]
  }
}
filter_dimensionaction

Filter a dimension to show only specific categories. Provide an array of category labels to include. Empty array shows all categories.

View tool JSON
{
  "name": "filter_dimension",
  "kind": "action",
  "impl": "imperative",
  "description": "Filter a dimension to show only specific categories. Provide an array of category labels to include. Empty array shows all categories.",
  "inputSchema": {
    "type": "object",
    "properties": {
      "dimensionId": {
        "type": "string",
        "description": "The ID of the dimension to filter"
      },
      "categories": {
        "type": "array",
        "items": {
          "type": "string"
        },
        "description": "Array of category labels to include. Empty array means show all categories."
      }
    },
    "required": [
      "dimensionId",
      "categories"
    ]
  }
}
search_dataread

Search for text across all cells in the current data view. Only available in flat view mode.

View tool JSON
{
  "name": "search_data",
  "kind": "read",
  "impl": "imperative",
  "description": "Search for text across all cells in the current data view. Only available in flat view mode.",
  "inputSchema": {
    "type": "object",
    "properties": {
      "query": {
        "type": "string",
        "description": "The search query to find in the data. Empty string clears the search."
      }
    },
    "required": [
      "query"
    ]
  }
}
sort_dataread

Sort the data by a specific column in ascending or descending order.

View tool JSON
{
  "name": "sort_data",
  "kind": "read",
  "impl": "imperative",
  "description": "Sort the data by a specific column in ascending or descending order.",
  "inputSchema": {
    "type": "object",
    "properties": {
      "columnIndex": {
        "type": "number",
        "description": "The index of the column to sort by (0-based)",
        "minimum": 0
      },
      "direction": {
        "type": "string",
        "enum": [
          "asc",
          "desc",
          "ascending",
          "descending"
        ],
        "description": "Sort direction: 'asc' or 'ascending' for ascending, 'desc' or 'descending' for descending"
      }
    },
    "required": [
      "columnIndex",
      "direction"
    ]
  }
}
export_csvread

Export the current data view (including any filters and sorting) to a CSV file for download.

View tool JSON
{
  "name": "export_csv",
  "kind": "read",
  "impl": "imperative",
  "description": "Export the current data view (including any filters and sorting) to a CSV file for download.",
  "inputSchema": {
    "type": "object",
    "properties": {}
  }
}
get_metadataread

Get comprehensive metadata about the currently loaded dataset including label, source, dimensions, and observation count.

View tool JSON
{
  "name": "get_metadata",
  "kind": "read",
  "impl": "imperative",
  "description": "Get comprehensive metadata about the currently loaded dataset including label, source, dimensions, and observation count.",
  "inputSchema": {
    "type": "object",
    "properties": {}
  }
}
get_dimensionsread

Get a list of all dimensions in the current dataset with their properties, available categories, and current filter settings.

View tool JSON
{
  "name": "get_dimensions",
  "kind": "read",
  "impl": "imperative",
  "description": "Get a list of all dimensions in the current dataset with their properties, available categories, and current filter settings.",
  "inputSchema": {
    "type": "object",
    "properties": {}
  }
}
get_data_summaryread

Get a summary of the current data view including row counts, view mode, active filters, and sort settings.

View tool JSON
{
  "name": "get_data_summary",
  "kind": "read",
  "impl": "imperative",
  "description": "Get a summary of the current data view including row counts, view mode, active filters, and sort settings.",
  "inputSchema": {
    "type": "object",
    "properties": {}
  }
}
get_preset_endpointsread

Get a list of available preset JSON-stat endpoints that can be quickly loaded.

View tool JSON
{
  "name": "get_preset_endpoints",
  "kind": "read",
  "impl": "imperative",
  "description": "Get a list of available preset JSON-stat endpoints that can be quickly loaded.",
  "inputSchema": {
    "type": "object",
    "properties": {}
  }
}