create_table
Define and generate a new table in a MySQL database by specifying table name, fields, data types, indexes, and other properties using the MCP MySQL Server interface.
Instructions
Create a new table in the database
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fields | Yes | ||
| indexes | No | ||
| table | Yes | Table name |
Input Schema (JSON Schema)
{
"properties": {
"fields": {
"items": {
"properties": {
"autoIncrement": {
"optional": true,
"type": "boolean"
},
"default": {
"optional": true,
"type": [
"string",
"number",
"null"
]
},
"length": {
"optional": true,
"type": "number"
},
"name": {
"type": "string"
},
"nullable": {
"optional": true,
"type": "boolean"
},
"primary": {
"optional": true,
"type": "boolean"
},
"type": {
"type": "string"
}
},
"required": [
"name",
"type"
],
"type": "object"
},
"type": "array"
},
"indexes": {
"items": {
"properties": {
"columns": {
"items": {
"type": "string"
},
"type": "array"
},
"name": {
"type": "string"
},
"unique": {
"optional": true,
"type": "boolean"
}
},
"required": [
"name",
"columns"
],
"type": "object"
},
"optional": true,
"type": "array"
},
"table": {
"description": "Table name",
"type": "string"
}
},
"required": [
"table",
"fields"
],
"type": "object"
}