Find how your tables connect
Drop the tables together. Keys, links and rows that point nowhere appear as you drop them.
- Runs on your device
- No sign-up
- Works offline after a visit
0tables
0key columns
0links found
0likely links
Columns of table
SQL sketch
Mermaid diagram
How to find how your tables connect
- Drop two or more CSV or Excel files, or add a pasted table.
- Read the links, the keys and the orphan rows, then look at the diagram.
- Copy the SQL sketch or the Mermaid diagram text.
Questions
What is a link here?
A column in one table whose values are found in a key column of another table. A key is a column with a value on every row and no repeats. The tool reports a link when at least 90% of the distinct values are found, and marks it Likely when the names agree, such as customer_id and customers.id.
What are orphan rows?
Rows whose link value is filled in but is not in the key column of the other table, for example an order for a customer ID that does not exist. Fix or remove them before you add the foreign key.
Is my data uploaded?
No. The files are read by your browser and the analysis runs on your device. Nothing is sent anywhere.
Reviews
No reviews yet. Be the first.