get_table_data
Retrieve sample data from SQL Server tables with optional filtering conditions and row limits for data analysis and verification.
Instructions
Get sample data from a table with optional filtering and limiting
Input Schema
Name | Required | Description | Default |
---|---|---|---|
database | No | Database name (optional) | |
limit | No | Maximum number of rows to return (optional, defaults to 100) | |
schema | No | Schema name (optional, defaults to dbo) | |
table_name | Yes | Name of the table | |
where | No | WHERE clause conditions (optional) |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name (optional)",
"type": "string"
},
"limit": {
"description": "Maximum number of rows to return (optional, defaults to 100)",
"type": "number"
},
"schema": {
"description": "Schema name (optional, defaults to dbo)",
"type": "string"
},
"table_name": {
"description": "Name of the table",
"type": "string"
},
"where": {
"description": "WHERE clause conditions (optional)",
"type": "string"
}
},
"required": [
"table_name"
],
"type": "object"
}