Hi everyone 👋 I’ve built this OpenSource tool called YamlQL — a Python-based CLI and library that lets you interact with YAML files using SQL, powered by DuckDB under the hood. 🔹 It flattens complex nested YAML (like Docker Compose, Kubernetes, Helm charts, etc.) into a sequence of DuckDB tables 🔹 Supports manual SQL and AI-assisted SQL queries (without sending your YAML to external servers) 🔹 Includes a discover mode to explore the structure/schema of the YAML Features: discover – Introspect the structure of any YAML file as a table schema sql – Write your own DuckDB queries over YAML data ai – Generate SQL queries using LLM (no data is sent; just the schema) Built it primarily for RAG indexing and AI-native infra use cases, but it works surprisingly well for a variety of DevOps/config/data pipelines too. Would love feedback from the community — happy to improve it further with your ideas. GitHub: https://github.com/AKSarav/YamlQL PyPI: https://pypi.org/project/yamlql/ Thanks for checking it out 🙏

YamlQL

query yaml files with sql and natural language powered by AI