generate_synthetic_data

Insert synthetic data into a SingleStore table by specifying row count, batch size, and custom column generators for testing and development purposes.

Instructions

Generate and insert synthetic data into an existing table

Input Schema

Name	Required	Description
`batch_size`	No	Number of rows to insert in each batch
`column_generators`	No	Custom generators for specific columns (optional)
`count`	No	Number of rows to generate and insert
`table`	Yes	Name of the table to insert data into

Input Schema (JSON Schema)

{
  "properties": {
    "batch_size": {
      "default": 1000,
      "description": "Number of rows to insert in each batch",
      "type": "number"
    },
    "column_generators": {
      "additionalProperties": {
        "properties": {
          "end": {
            "description": "Ending value for random number generator",
            "type": "number"
          },
          "formula": {
            "description": "SQL expression for formula generator",
            "type": "string"
          },
          "start": {
            "description": "Starting value for sequence generator",
            "type": "number"
          },
          "type": {
            "description": "Type of generator to use",
            "enum": [
              "sequence",
              "random",
              "values",
              "formula"
            ],
            "type": "string"
          },
          "values": {
            "description": "Array of values to choose from for values generator",
            "items": {
              "type": "string"
            },
            "type": "array"
          }
        },
        "type": "object"
      },
      "description": "Custom generators for specific columns (optional)",
      "type": "object"
    },
    "count": {
      "default": 100,
      "description": "Number of rows to generate and insert",
      "type": "number"
    },
    "table": {
      "description": "Name of the table to insert data into",
      "type": "string"
    }
  },
  "required": [
    "table"
  ],
  "type": "object"
}

SingleStore MCP Server

generate_synthetic_data

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from SingleStore MCP Server

Related Tools