query_mssql
Execute read-only SQL queries on MSSQL databases to retrieve data safely. Connect using host, port, credentials and database name to run SELECT statements without modification capabilities.
Instructions
执行MSSQL数据库查询（只读模式）
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db | Yes | 数据库名称 | |
| host | Yes | 数据库主机地址 | |
| port | Yes | 数据库端口 | |
| pwd | Yes | 数据库密码 | |
| querySql | Yes | 要执行的SQL查询语句（仅支持SELECT等只读操作） | |
| user | Yes | 数据库用户名 |
Input Schema (JSON Schema)
{
"properties": {
"db": {
"description": "数据库名称",
"type": "string"
},
"host": {
"description": "数据库主机地址",
"type": "string"
},
"port": {
"description": "数据库端口",
"type": "integer"
},
"pwd": {
"description": "数据库密码",
"type": "string"
},
"querySql": {
"description": "要执行的SQL查询语句（仅支持SELECT等只读操作）",
"type": "string"
},
"user": {
"description": "数据库用户名",
"type": "string"
}
},
"required": [
"host",
"port",
"user",
"pwd",
"db",
"querySql"
],
"type": "object"
}