mssql_manage_schema
Retrieve SQL Server schema info, create or alter tables, and manage enum-style CHECK constraints.
Instructions
Manage SQL Server schema - get schema info, create/alter tables, manage enum-style CHECK constraints. Examples: operation="get_info" for table lists, operation="create_table" with tableName and columns, operation="get_enums" to list IN-list CHECK constraints, operation="create_enum" with enumName, tableName, columnName and values
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema name (defaults to dbo) | |
| values | No | Allowed values (required for create_enum) | |
| columns | No | Column definitions (required for create_table) | |
| enumName | No | CHECK constraint name (optional filter for get_enums, required for create_enum) | |
| operation | Yes | Operation: get_info (schema/table info), create_table (new table), alter_table (modify table), get_enums (list IN-list CHECK constraints), create_enum (new IN-list CHECK constraint) | |
| tableName | No | Table name (optional for get_info to get specific table info, required for create_table/alter_table/create_enum) | |
| columnName | No | Column the enum CHECK applies to (required for create_enum) | |
| operations | No | Alter operations (required for alter_table) | |
| ifNotExists | No | Include IF NOT EXISTS guard (for create_enum) | |
| connectionString | No | SQL Server connection string (optional; requires --allow-tool-connection-string) |