Use this skill when a table has been created or written and you need to verify both:

schema contract
post-write data quality

This skill assumes you can use existing database tools such as describe_table, get_table_ddl, and read_query. Prefer direct validation queries over prose reasoning.

When to use this skill

Activate when you need to validate one or more of:

object existence
missing / extra columns
type or nullability mismatches
row-count gates
null ratios
numeric ranges
accepted values
regex / format rules
uniqueness / duplicate keys

Core workflow

Confirm the exact target table and expected grain.
Run schema checks first.
Run row-count and cheap aggregate checks next.
Run duplicate and format checks after the cheap gates pass.
Return a compact pass / fail report with observed values and failing sample filters when useful.

Use this skill when a table has been created or written and you need to verify both:

schema contract
post-write data quality

This skill assumes you can use existing database tools such as describe_table, get_table_ddl, and read_query. Prefer direct validation queries over prose reasoning.

When to use this skill

Activate when you need to validate one or more of:

object existence
missing / extra columns
type or nullability mismatches
row-count gates
null ratios
numeric ranges
accepted values
regex / format rules
uniqueness / duplicate keys

Core workflow

Confirm the exact target table and expected grain.
Run schema checks first.
Run row-count and cheap aggregate checks next.
Run duplicate and format checks after the cheap gates pass.
Return a compact pass / fail report with observed values and failing sample filters when useful.

Table Validation

When to use this skill

Core workflow

Table Validation

When to use this skill

Core workflow

Checklist

Output expectations

Clickhouse Io

Clickhouse Io

Claude Devfleet

Clickhouse Io

Ai First Engineering

Postgres Patterns