generate_synthetic_data

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

Input Schema

Input Schema (JSON Schema)

Other Tools