Sample candidate key analyzer

Find minimal column combinations that distinguish rows in a CSV sample. Search composite keys beyond single-column profiling without claiming future uniqueness.

The example value has been entered. Check it immediately or change the value.

Input is processed in the browser. Refreshing returns a sample value.

Result

Instructions and example

Retain column subsets with no empty values and unique row tuples, discarding supersets of an already-found key.

first and last each repeat, but together distinguish all 3 rows, so first + last is a candidate key.

At most 100 rows and 12 columns. Empty strings are missing key values; no numeric coercion, whitespace cleanup or future constraint guarantee.

Frequently asked questions

Does a sample candidate key prove a database primary key?

No. It establishes uniqueness only in this sample; data meaning and future input constraints need separate review.

Why are larger supersets of keys omitted?

They are not minimal: the extra columns are unnecessary to distinguish rows.

Calculation criteria and reference materials

The calculation formula and scope of this tool are disclosed in the above description. Examples can be checked by substituting input values into the formula or following the specified string and calendar handling rules.

Verification of calculation criteria: · Calculation·verification principles · Report errors