generate_synthetic_data

Create and insert synthetic data into a specified table, supporting custom column generators and batch processing for efficient data population in SingleStore databases.

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

MCP directory API