claude-database-tools

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

Describes the complete schema of a specified MSSQL Database table, including columns, types, constraints, indexes, and foreign keys.

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.

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)

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

Executes a physical DELETE operation on table records. WARNING: This database uses soft delete patterns (__deleted flag). Consider using update_data to set __deleted = 1 instead for most use cases.

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.

Generates CREATE TABLE DDL script for an existing table, including columns, constraints, and optionally indexes.

Generates ALTER TABLE DDL statements to add columns and constraints from an existing table.

Executes a stored procedure with optional parameters. Supports input parameters and returns result sets, output parameters, and return values.