snowflake-create-database-role

SkillDatabases & data

Consult Snowflake CREATE DATABASE ROLE parameter reference before generating any CREATE DATABASE ROLE DDL.

Available today. Use it from your connected AI after setup.

No other account needed.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the snowflake-create-database-role skill

What this skill tells your AI

The instructions your AI receives, as published by gyrus-dev/frosty in skills/snowflake-create-database-role/SKILL.md and read by ahel’s review.

Before writing a CREATE DATABASE ROLE statement:

Read references/parameters.md to review all available parameters and their defaults.
For each parameter, decide whether the user's request implies a non-default value.
Include only the parameters that differ from the default or that the user explicitly requested.
Never use CREATE OR REPLACE — always use CREATE DATABASE ROLE IF NOT EXISTS.
Always qualify the role name with the target database (e.g., <db_name>.<role_name>) unless the current session database is already confirmed. Always add a COMMENT describing the role's purpose. Note that upon creation Snowflake automatically grants the USAGE privilege on the containing database to the new database role, so an explicit GRANT for that is not needed.

Advanced