profile_table
Profiles a table or view from sampled rows to report nulls, distinct values, ranges, frequent values, patterns, and numeric spread, with counts only for sensitive columns.
Instructions
Profiles the columns of a table or view from a sample of its rows (the first sample_rows, default 10000, up to 100000; no order is implied): per column NULLs, distinct values, empty texts, minimum and maximum, the most frequent values, patterns (emails, dates, numbers stored as text...) and, for numbers, their spread. Sensitive columns (as in results) give counts only: no value of any kind. Read-only, within the connection's limits; max_bytes and timeout_seconds work as in run_query.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"connection": "<connection>",
"schema": "<schema>",
"table": "<table>"
},
"name": "profile_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | The table, view or collection. | |
| schema | Yes | The table's schema (a database in MySQL and MongoDB, `main` in SQLite and DuckDB). | |
| max_bytes | No | Bytes of output at most (default 32768, up to 1048576). | |
| connection | Yes | The connection's name, as `list_connections` shows it. | |
| sample_rows | No | Rows to profile: the first ones the database reads (default 10000, up to 100000). | |
| timeout_seconds | No | Seconds the read may take before it is cancelled (default 30, up to 300). |