Combine and split¶

Putting tables together, finding how they fit, and taking them apart again.

Combine and split

Each row is one job, with where to find it in the app, on the command line and as an MCP tool for AI agents. A dash means that surface does not offer it.

I want to...	In the app	Command line	MCP tool
Stack tables (union)	Union Tables	`--union`	`union_tables`
Join tables	Join Tables	`--join`	`join_tables`
Join on similar, not equal, values	Fuzzy join	`--fuzzy-join`	`fuzzy_join`
Join by location	Spatial join	`--spatial-join`	`spatial_join`
Find the columns to join on	Join Key Finder	`--unique-columns`	`suggest_join_keys`, `unique_columns`
Find out why a join loses rows	Join Diagnostics	-	`diagnose_join`
Find lookup columns	Find lookup tables	`--lookups`	`find_lookups`
Map how tables relate, in a folder or a database	Relationship Map	`--relationships`	`db_relationships`
Check that keys exist in another table	Referential Integrity	`--check-references`	`check_references`
Bring a folder of files to one schema	Harmonise Schemas	`--harmonise-schema`	`harmonise_schemas`
Merge copies several people edited	Merge Versions	`--merge`	`merge_tables`
Split a table into files by a column, row count or size	Split into Files	`--partition-by`	`partition_table`