execute_query
Run SQL SELECT queries on Microsoft SQL Server databases with automatic row limits. Use connection strings or named connections to directly explore data without coding.
Instructions
Execute a custom SQL SELECT query with automatic limit (top 20 rows)
Input Schema
Name | Required | Description | Default |
---|---|---|---|
connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
connectionString | No | SQL Server connection string (uses default if not provided) | |
query | Yes | SQL SELECT query to execute |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"connectionName": {
"description": "Named connection to use (e.g., 'production', 'staging')",
"type": "string"
},
"connectionString": {
"description": "SQL Server connection string (uses default if not provided)",
"type": "string"
},
"query": {
"description": "SQL SELECT query to execute",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}