YATO

Yato is an open-source Python-based tool for analyzing SQL files and managing database schemas using DuckDB. It provides a lightweight and flexible command-line interface for running SQL scripts, tracking dependencies between tables and views, and generating visual diagrams to understand complex database structures. Yato is designed to simplify database workflows for developers, data engineers, and analysts by automating dependency resolution and execution planning.

Features of Yato:

• Dependency tracking: Automatically identifies relationships between SQL objects to visualize data flow and dependencies.
• DuckDB integration: Uses DuckDB as the backend for fast and efficient SQL execution.
• CLI-based: Provides a simple command-line interface for running SQL workflows and analyzing projects.
• Lightweight: Minimal setup with a virtual environment, making it easy to install and run on different systems.

To verify the working of YATO in your shell:

$ sudo su
$ cd /opt/yato
$ source venv/bin/activate
$ grep version pyproject.toml

Disclaimer: Yato is developed and maintained as an open-source project. It relies on DuckDB for database operations and Python for its runtime environment.