SingleStore MCP Server

create_table

Create a new table in the database with specified columns and constraints

Input Schema

NameRequiredDescriptionDefault
columnsYesList of columns to create
table_nameYesName of the table to create
table_optionsNo

Input Schema (JSON Schema)

{ "properties": { "columns": { "description": "List of columns to create", "items": { "properties": { "auto_increment": { "description": "Whether the column should auto increment", "type": "boolean" }, "default": { "description": "Default value for the column", "type": "string" }, "name": { "description": "Column name", "type": "string" }, "nullable": { "description": "Whether the column can be NULL", "type": "boolean" }, "type": { "description": "Data type (e.g., INT, VARCHAR(255), etc.)", "type": "string" } }, "required": [ "name", "type" ], "type": "object" }, "type": "array" }, "table_name": { "description": "Name of the table to create", "type": "string" }, "table_options": { "properties": { "auto_increment_start": { "description": "Starting value for auto increment columns", "type": "number" }, "compression": { "description": "Table compression type", "enum": [ "SPARSE" ], "type": "string" }, "is_reference": { "description": "Whether this is a reference table", "type": "boolean" }, "shard_key": { "description": "Columns to use as shard key", "items": { "type": "string" }, "type": "array" }, "sort_key": { "description": "Columns to use as sort key", "items": { "type": "string" }, "type": "array" } }, "type": "object" } }, "required": [ "table_name", "columns" ], "type": "object" }