mssql_query
Execute read-only SELECT queries on Microsoft SQL Server databases to retrieve data with secure authentication and connection options.
Instructions
Execute a read-only SELECT query
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database name | |
| encrypt | No | Use encrypted connection (default: true) | |
| limit | No | Maximum number of rows to return (default: 100) | |
| password | Yes | Password for authentication | |
| port | No | Port number (default: 1433) | |
| query | Yes | SQL SELECT query to execute | |
| server | Yes | MSSQL Server hostname or IP address | |
| trustServerCertificate | No | Trust server certificate (default: true) | |
| user | Yes | Username for authentication |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name",
"type": "string"
},
"encrypt": {
"default": true,
"description": "Use encrypted connection (default: true)",
"type": "boolean"
},
"limit": {
"default": 100,
"description": "Maximum number of rows to return (default: 100)",
"type": "number"
},
"password": {
"description": "Password for authentication",
"type": "string"
},
"port": {
"default": 1433,
"description": "Port number (default: 1433)",
"type": "number"
},
"query": {
"description": "SQL SELECT query to execute",
"type": "string"
},
"server": {
"description": "MSSQL Server hostname or IP address",
"type": "string"
},
"trustServerCertificate": {
"default": true,
"description": "Trust server certificate (default: true)",
"type": "boolean"
},
"user": {
"description": "Username for authentication",
"type": "string"
}
},
"required": [
"server",
"user",
"password",
"database",
"query"
],
"type": "object"
}