Index of every page on this site: llms.txt
All skills
jeremylongshore avatar

/snowflake-strong-auth-migration-pilot

@820dfc8
Run it yourself

Pilot a Snowflake authentication modernization without lockouts or credential exposure. Inventory PERSON, SERVICE, and LEGACY_SERVICE users; map named workloads to WIF, key pair, OAuth, or bounded PAT; and audit managed MCP/OAuth session controls. Use when replacing Snowflake passwords, reviewing service identities, planning workload identity federation, or scoping MCP OAuth. Trigger with phrases like "Snowflake auth migration", "service user password", "Snowflake WIF", "key pair rotation", or "MCP OAuth role scope".

Use this Skill: https://skilld.dev/gh/jeremylongshore/tons-of-skills-marketplace/snowflake-strong-auth-migration-pilot

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

referencesmcp-oauth-role-scoping.md

≈522 tokens on demand. Your agent reads this file only when SKILL.md points to it.

Managed MCP/OAuth role scoping

Read this reference when a workload uses a Snowflake-managed MCP/OAuth integration or another OAuth integration that brokers tool access.

Do not model managed MCP authorization as one role_scope list. Inventory these separate controls:

  • where OAUTH_SCOPES_SUPPORTED is set (account, database, or schema) and the advertised primary-role scopes;
  • whether the client requests session:role:<role>, session:role:all, or session:role-any;
  • the connecting user's DEFAULT_ROLE and DEFAULT_WAREHOUSE;
  • the Snowflake or External OAuth integration's allowed and blocked roles; and
  • OAUTH_USE_SECONDARY_ROLES (or the External OAuth equivalent).

session:role:all uses the user's default role; it does not activate all roles. Some clients request that scope even when named role scopes are advertised. OAuth scopes control the primary role, while secondary roles are controlled separately by the security integration. For a bounded Snowflake OAuth MCP pilot, use a task-specific default role, restrict allowed roles, and leave secondary roles at NONE. Stop on missing evidence rather than inventing a safe scope.

For a canary, prove both directions:

  • an in-scope request obtains a session with the expected role and can perform one approved operation; and
  • an out-of-scope role/object request is rejected, the observed primary role matches the declared client behavior, and no secondary-role expansion occurs.

Keep OAuth token values, client secrets, private keys, and authorization codes out of the inventory and cutover packet. Verify the live Snowflake feature, account edition, connector, and current managed-MCP documentation before execution; this reference does not promise availability in every account.

Sources

Source: SKILL.md on GitHub

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No alerts29d3 checks · Risk SAFE
  • Gen Agent Trust Hub29d

    This skill is a security tool designed to pilot Snowflake authentication migrations. It focuses on read-only evidence collection and planning, featuring extensive built-in sanitization to prevent credential exposure. No malicious patterns, prompt injections, or data exfiltration vectors were detected.

  • Socket1mo

    No alerts

  • Snyk1mo

    Risk: LOW · No issues

Signed by skilld at 820dfc8. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 3 months ago
What it can do
Reads files Runs commands
argument-hint
[redacted-auth-evidence.json]
version
3.16.0
author
Jeremy Longshore <jeremy@intentsolutions.io>
All 2 allowed tools
ReadBash(python3:*)
Other metadata
compatibility
Model-agnostic workflow; requires Python 3.10+; optional Snowflake CLI for live read-only evidence collection
tags
[
  "saas",
  "snowflake",
  "security",
  "authentication",
  "wif",
  "oauth",
  "mcp"
]

README badge

README badge for jeremylongshore/tons-of-skills-marketplace/snowflake-strong-auth-migration-pilot