mcp_get_sample_values
Retrieve distinct sample values from a specified column in a database table, with an optional limit on the number of values returned. Simplify data analysis and validation tasks.
Instructions
Get sample values from a specific column in a table
Input Schema
Name | Required | Description | Default |
---|---|---|---|
column_name | Yes | Name of the column to get sample values from | |
limit | No | Maximum number of distinct values to return | |
table_name | Yes | Fully qualified table name (schema.table), e.g. "dbo.Users" |
Input Schema (JSON Schema)
{
"properties": {
"column_name": {
"description": "Name of the column to get sample values from",
"type": "string"
},
"limit": {
"default": 10,
"description": "Maximum number of distinct values to return",
"type": "number"
},
"table_name": {
"description": "Fully qualified table name (schema.table), e.g. \"dbo.Users\"",
"type": "string"
}
},
"required": [
"table_name",
"column_name"
],
"type": "object"
}