mcp_preview_data
Preview data from a SQL Server table using optional filters and row limits for quick insights and validation.
Instructions
Get a preview of data from a SQL Server table with optional filters
Input Schema
Name | Required | Description | Default |
---|---|---|---|
filters | No | Optional filters as column-value pairs, e.g. {"Status": "Active"} | |
limit | No | Maximum number of rows to return | |
table_name | Yes | Fully qualified table name (schema.table), e.g. "dbo.Users" |
Input Schema (JSON Schema)
{
"properties": {
"filters": {
"description": "Optional filters as column-value pairs, e.g. {\"Status\": \"Active\"}",
"type": "object"
},
"limit": {
"default": 100,
"description": "Maximum number of rows to return",
"maximum": 1000,
"minimum": 1,
"type": "number"
},
"table_name": {
"description": "Fully qualified table name (schema.table), e.g. \"dbo.Users\"",
"type": "string"
}
},
"required": [
"table_name"
],
"type": "object"
}