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.
• Modular design: Organized code structure allows developers to extend functionality or integrate it into other workflows.
• Open-source: Freely available on GitHub with active contributions and regular updates from the community.

To verify the working of YATO in your environment:

$ sudo su
$ sudo apt update
$ cd /opt/yato
$ source venv/bin/activate
$ yato --help
$ 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. For the latest updates, supported versions, and detailed documentation, visit the official Yato repository at github.com/Bl3f/yato.