MCP-MongoDB-MySQL-Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

create_table

Define and create new tables in MySQL or MongoDB databases by specifying table name, fields, indexes, and constraints through a standardized schema, enabling efficient database schema management.

Instructions

Create a new table in the database

Input Schema

Name	Required	Description
`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"
}

Install Server

HTTP connection URL

Other Tools from MCP-MongoDB-MySQL-Server

Related Tools

create_table
@TickHaiJun/mysql-mcp-server
add_column
@yaoxiaolinglong/mcp-mongodb-mysql-server
create_table
@kevinbin/mcp-mysql-server
create_table
@enemyrr/mcp-mysql-server
create_table
@michael7736/mysql-mcp-server
create_table
@alittleyellowkevin/Mysql-MCP

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/yaoxiaolinglong/mcp-mongodb-mysql-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server