create_table
Define and create a new database table with specific columns, constraints, and table options in SingleStore using the MCP Server for structured data management.
Instructions
Create a new table in the database with specified columns and constraints
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | Yes | List of columns to create | |
| table_name | Yes | Name of the table to create | |
| table_options | No |
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"
}