execute-query
Execute SQL queries on a Microsoft SQL Server database using the MSSQL MCP Server. Specify queries and optional result limits to retrieve data securely and efficiently.
Instructions
執行 SQL 查詢語句
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | 結果筆數限制 (預設: 100) | |
| query | Yes | 要執行的 SQL 查詢語句 |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"limit": {
"default": 100,
"description": "結果筆數限制 (預設: 100)",
"type": "number"
},
"query": {
"description": "要執行的 SQL 查詢語句",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}