SingleStore MCP Server

generate_synthetic_data

Generate and insert synthetic data into an existing table

Input Schema

NameRequiredDescriptionDefault
batch_sizeNoNumber of rows to insert in each batch
column_generatorsNoCustom generators for specific columns (optional)
countNoNumber of rows to generate and insert
tableYesName 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" }