Run SQL Query
mssql_run_sql_queryExecute any SQL statement on the connected MS SQL Server, using named parameters for secure, injection-resistant queries and selectable JSON or Markdown output for flexible results.
Instructions
Executes an arbitrary SQL statement against the connected database. ⚠️ WARNING: This tool can read AND modify data (INSERT, UPDATE, DELETE, DDL). Always prefer parameterized inputs via the 'parameters' field — never embed user-supplied values directly in the query string. Example: query='SELECT * FROM dbo.Users WHERE Id = @id', parameters={id: 42}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL statement to execute | |
| parameters | No | Named parameters referenced in the query via @paramName | |
| response_format | No | Output format: 'json' for structured data, 'markdown' for human-readable table | json |