query_mssql
Execute read-only MSSQL queries to retrieve database information through your LINE bot. Run SELECT statements with parameter support and get structured results with column data and row counts.
Instructions
Run a read-only MSSQL query (SELECT/WITH). Returns columns, rowCount, and sliced rows for preview.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows to return (client-side slice). | |
| maxChars | No | Max characters in serialized preview. | |
| params | No | Key-value parameters for @name placeholders in SQL. | |
| sql | Yes | Read-only SQL beginning with SELECT or WITH. Parameters as @name. |
Input Schema (JSON Schema)
{
"properties": {
"limit": {
"default": 100,
"description": "Maximum rows to return (client-side slice).",
"maximum": 500,
"minimum": 1,
"type": "integer"
},
"maxChars": {
"default": 12000,
"description": "Max characters in serialized preview.",
"maximum": 200000,
"minimum": 1000,
"type": "integer"
},
"params": {
"additionalProperties": {},
"description": "Key-value parameters for @name placeholders in SQL.",
"type": "object"
},
"sql": {
"description": "Read-only SQL beginning with SELECT or WITH. Parameters as @name.",
"minLength": 1,
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}