MSSQL MCP Server

121

Overview InspectNew Schema Related Servers Reviews Score

create_table

Define and generate a new table in MSSQL databases by specifying the table name and column configurations, enabling direct database structure management.

Instructions

Creates a new table in the MSSQL Database with the specified columns.

Input Schema

Name	Required	Description	Default
`columns`	Yes	Array of column definitions (e.g., [{ name: 'id', type: 'INT PRIMARY KEY' }, ...])
`tableName`	Yes	Name of the table to create

Input Schema (JSON Schema)

{
  "properties": {
    "columns": {
      "description": "Array of column definitions (e.g., [{ name: 'id', type: 'INT PRIMARY KEY' }, ...])",
      "items": {
        "properties": {
          "name": {
            "description": "Column name",
            "type": "string"
          },
          "type": {
            "description": "SQL type and constraints (e.g., 'INT PRIMARY KEY', 'NVARCHAR(255) NOT NULL')",
            "type": "string"
          }
        },
        "required": [
          "name",
          "type"
        ],
        "type": "object"
      },
      "type": "array"
    },
    "tableName": {
      "description": "Name of the table to create",
      "type": "string"
    }
  },
  "required": [
    "tableName",
    "columns"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Other Tools from MSSQL MCP Server

Related Tools

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/EvilPhatBoi/McpSqlServer'

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