read_data
Execute SELECT queries on MSSQL databases to retrieve data from tables while maintaining security by preventing destructive SQL operations.
Instructions
Executes a SELECT query on an MSSQL Database table. The query must start with SELECT and cannot contain any destructive SQL operations for security reasons.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL SELECT query to execute (must start with SELECT and cannot contain destructive operations). Example: SELECT * FROM movies WHERE genre = 'comedy' |
Input Schema (JSON Schema)
{
"properties": {
"query": {
"description": "SQL SELECT query to execute (must start with SELECT and cannot contain destructive operations). Example: SELECT * FROM movies WHERE genre = 'comedy'",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}