datools

Introduction

datools is a collection of Python-based tools for working with data in relational databases. While it contains several utilities for smoothing the rough edges of SQL, its most baked component is datools.diff, an algorithm that’s best explained in a blog post and Jupyter Notebook.

To learn more, read the docs or reach out.

Database support

While datools generates SQL for its operations, different databases have their nuances. datools may run on your database today, but in an attempt to give you some certainty as to databases we know it has successfully run on, we run all tests in the test suite against the following databases:

Database	Evaluated by test suite
SQLite	Since v0.1.2
DuckDB	Since v0.1.4
PostgreSQL	Since v0.1.5
Redshift, Snowflake	You provide an instance, I’ll make the tests pass