query
Execute SQL queries on Microsoft SQL Server databases by providing connection details or a connection string. Manage database interactions and retrieve results directly.
Instructions
Execute a SQL query on a MSSQL database
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | Full connection string (alternative to individual parameters) | |
| database | No | Database name (default: master) | |
| encrypt | No | Enable encryption (default: false) | |
| host | No | Database server hostname | |
| password | No | Database password | |
| port | No | Database server port (default: 1433) | |
| query | Yes | SQL query to execute | |
| trustServerCertificate | No | Trust server certificate (default: true) | |
| username | No | Database username |
Input Schema (JSON Schema)
{
"oneOf": [
{
"required": [
"connectionString"
]
},
{
"required": [
"host",
"username",
"password"
]
}
],
"properties": {
"connectionString": {
"description": "Full connection string (alternative to individual parameters)",
"type": "string"
},
"database": {
"description": "Database name (default: master)",
"type": "string"
},
"encrypt": {
"description": "Enable encryption (default: false)",
"type": "boolean"
},
"host": {
"description": "Database server hostname",
"type": "string"
},
"password": {
"description": "Database password",
"type": "string"
},
"port": {
"description": "Database server port (default: 1433)",
"type": "number"
},
"query": {
"description": "SQL query to execute",
"type": "string"
},
"trustServerCertificate": {
"description": "Trust server certificate (default: true)",
"type": "boolean"
},
"username": {
"description": "Database username",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}