check_database_design
Validate database models against custom design rules to catch missing primary keys, naming violations, and column issues. Returns passed, errors, warnings, and skipped rules for clear compliance reporting.
Instructions
Check a model against YOUR design rules. rules: [{id, description, type, params?, severity?}]. Machine-checkable types: TABLE_HAS_PK, TABLE_CODE_PATTERN, TABLE_NAME_STYLE, COLUMN_HAS_COMMENT, COLUMN_CODE_PATTERN, COLUMN_MANDATORY, REQUIRED_COLUMNS, PK_NAME_PATTERN, FK_NAME_PATTERN, INDEX_NAME_PATTERN, DATA_TYPE_ALLOWED, NO_DUPLICATE_INDEX, NO_EMPTY_COMMENT_TABLE, REGEX. Rules with unknown types are reported in 'skipped' (never silently ignored). Returns passed/errors/warnings/violations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rules | Yes | ||
| model_id | Yes |