MSSQL MCP Server

Inserts data into an MSSQL Database table. Supports both single record insertion and multiple record insertion using standard SQL INSERT with VALUES clause. FORMAT EXAMPLES: Single Record Insert: { "tableName": "Users", "data": { "name": "John Doe", "email": "john@example.com", "age": 30, "isActive": true, "createdDate": "2023-01-15" } } Multiple Records Insert: { "tableName": "Users", "data": [ { "name": "John Doe", "email": "john@example.com", "age": 30, "isActive": true, "createdDate": "2023-01-15" }, { "name": "Jane Smith", "email": "jane@example.com", "age": 25, "isActive": false, "createdDate": "2023-01-16" } ] } GENERATED SQL FORMAT:

• Single: INSERT INTO table (col1, col2) VALUES (@param1, @param2)

• Multiple: INSERT INTO table (col1, col2) VALUES (@param1, @param2), (@param3, @param4), ... IMPORTANT RULES:

• For single record: Use a single object for the 'data' field

• For multiple records: Use an array of objects for the 'data' field

• All objects in array must have identical column names

• Column names must match the actual database table columns exactly

• Values should match the expected data types (string, number, boolean, date)

• Use proper date format for date columns (YYYY-MM-DD or ISO format)

Executes a SELECT query on an MSSQL Database table. The query must start with SELECT and cannot contain any destructive SQL operations for security reasons.

Describes the schema (columns and types) of a specified MSSQL Database table.

Updates data in an MSSQL Database table using a WHERE clause. The WHERE clause must be provided for security.

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

Creates an index on a specified column or columns in an MSSQL Database table

Drops a table from the MSSQL Database.

Lists tables in an MSSQL Database, or list tables in specific schemas