MCP-MySQL Server

create_table

Create a new table in the database

Input Schema

NameRequiredDescriptionDefault
fieldsYes
indexesNo
tableYesTable 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" }