Schema Matching Python Packages

valentine

A tool facilitating matching columns across tabular datasets. It also serves as an experiment suite for state-of-the-art schema matching methods.

ofunnel

A regex alternative for pulling fields out of XML, JSON, CSV, HTML and key-value text. Survives renamed keys, reformatted values and schema drift, verifies every capture is lossless, and tells you why a field is missing. Pure Python, zero dependencies.

schema-matching

A python tool using XGboost and sentence-transformers to perform schema matching task on tables.

canoniq

AI-assisted, local-first engine that automatically maps messy data to your canonical schema — with a confidence score and a plain-English reason for every match. Profiles, validates, and detects schema drift. No data leaves your machine.

magneto-python

[VLDB '25] Magneto combines small and large language models to provide cost-effective schema matching.

uma-pydi

The PyDI framework provides methods for end-to-end data integration. The framework covers all steps of the integration process, including schema matching, data translation, entity matching, and data fusion. The framework offers traditional string-based methods as well as modern LLM- and embedding-based techniques for these tasks.

bbw

Entity linking, entity typing and relation extraction: Matching CSV to a Wikibase instance (e.g., Wikidata) via Meta-lookup

nexus-matcher

Match schema fields to data dictionary entries by meaning. Hybrid dense + BM25 retrieval on a bundled CPU encoder, with governance classification, a no-match verdict, and measured accuracy.

smartjoin-py

Deterministic key and join discovery for structured datasets

insert-tools

CLI tool for inserting SELECT query results into ClickHouse with automatic schema matching and type-safe casting. Ideal for ETL pipelines and SQL-driven data flows.