whodb_audit
Audit a database schema or table for common data quality issues: null-rate spikes, missing primary keys, duplicates, and orphaned foreign keys.
Instructions
Run data-quality checks on one schema or table.
Best for: Finding null-rate spikes, missing primary keys, low-cardinality issues, duplicate rows, and orphaned foreign keys. Not recommended for: Replacing a full observability or data-governance system. Common mistakes: Forgetting to scope the audit to one table when you only need one table.
Usage Example:
{
"name": "whodb_audit",
"arguments": {
"connection": "mydb",
"schema": "public",
"table": "orders",
"null_warning": 15,
"null_error": 60
}
}Returns: Audit results per table, including issue summaries and the underlying table/column findings.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | Yes | Connection name (optional if only one exists) | |
| schema | No | Schema or database name override | |
| table | No | Optional table name | |
| null_warning | No | Warning threshold for null percentage | |
| null_error | No | Error threshold for null percentage |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| summary | Yes | ||
| results | Yes | ||
| error | No | ||
| request_id | No |