DEV Community

Cover image for Frosty : 150 + AI Open Source Sub- Agents to Automate Snowflake
Priyank Malviya
Priyank Malviya

Posted on

Frosty : 150 + AI Open Source Sub- Agents to Automate Snowflake

With the advancement in AI, most teams are still not sure whether to use AI for their data or not. I feel the only way to empower them is to give them the control. That's why we released our AI Agent #Frosty as open source project on March 25th. Teams can own it and pay nothing beyond actual token usage.

What is Frosty?

Frosty is an AI Agent that can do everything that you can do on Snowflake. Yes EVERYTHING is a very broad scope, but that is exactly what Frosty can do. It has its own google search agent, which can read snowflake documentation and understand best practices and implement them for you.

It has a roster of 153 special agents, that can take care of engineering, administrator, security, governance , research tasks. It understands the entire context of your Snowflake by using its Inspector agent.

Agent Breakdown by Function

  • Engineer : 34 Agents

  • Administrator : 16 Agents

  • Security : 14 Agents

  • Governance : 8 Agents

  • Inspector : 56 Agents

  • Account Monitor : 25 Agents.

Checkout the repository here:

GitHub logo Gyrus-Dev / frosty

AI Agent for Snowflake

███████╗██████╗  ██████╗ ███████╗████████╗██╗   ██╗
██╔════╝██╔══██╗██╔═══██╗██╔════╝╚══██╔══╝╚██╗ ██╔╝
█████╗  ██████╔╝██║   ██║███████╗   ██║    ╚████╔╝
██╔══╝  ██╔══██╗██║   ██║╚════██║   ██║     ╚██╔╝
██║     ██║  ██║╚██████╔╝███████║   ██║      ██║
╚═╝     ╚═╝  ╚═╝ ╚═════╝ ╚══════╝   ╚═╝      ╚═╝
                    ╰─ by Gyrus Inc ─╯

An open-source, self-hosted agentic framework that turns plain English into Snowflake operations.

License Python Models Agents Snowflake

Quick Start · Features · Architecture · Setup · Safety · Contributing · Get in Touch

If you find Frosty useful, please consider giving it a ⭐ — it helps others discover the project!


What is Frosty?

Frosty is a 153-agent system built by Gyrus Inc that lets you manage your entire Snowflake environment in plain English — from querying data to administering security policies.

"who are my top 10 customers by revenue last quarter?"
  → Returns a Markdown table, powered by live SQL
"set up MFA for all users without it"
  → Generates and runs the ALTER statements, with your approval

"why is my

What can Frosty do?

  • Frosty can build entire pipeline in minutes.

  • Frosty can create roles, grant privileges and plan the least access privilege policy.

  • Frosty can implement password policies, session policies, network rules, network policies to safeguard your Snowflake.

  • Frosty can implement masking policies, row access policies , plan tags to tag every object for better governance.

  • Frosty can access the metadata of every object on your Snowflake to understand your setup and plan things accordingly.

  • Frosty can generate synthetic data to help developers do comprehensive testing.

  • Frosty can do Data profiling and explain you the gaps in your data.

What Frosty can't do?

  • It can't drop any objects , as it has two level of safeguards, one through prompt, the other through code. So even if for some reason Frosty decides to run a DROP query, the code blocks it out before it reaches Snowflake.

  • It can't run CREATE OR REPLACE statements, without approval.

  • It can't create dashboards, but being open source users can extend its capabilities.

Frosty is open source and free to use. We would love feedback, feature requests , contributions from Dev.to community.

Top comments (0)