sample_data
Extract sample data from a Microsoft SQL Server table to quickly preview its contents. Specify table name, schema, and row limit (default: 10).
Instructions
Retrieve sample data from a table (top 10 rows by default)
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) | |
| limit | No | Number of rows to return (default: 10, max: 100) | |
| schema | No | Schema name (default: dbo) | |
| tableName | Yes | Name of the table to sample |
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"
},
"limit": {
"description": "Number of rows to return (default: 10, max: 100)",
"type": "number"
},
"schema": {
"description": "Schema name (default: dbo)",
"type": "string"
},
"tableName": {
"description": "Name of the table to sample",
"type": "string"
}
},
"required": [
"tableName"
],
"type": "object"
}