snowflake-postgres

Manage Snowflake Postgres instances with create, list, suspend, resume, and credential reset workflows.

Updated Mar 7, 2026
One-click install
npx skills add https://github.com/randoneering/nix-flake-mirror --skill snowflake-postgres-randoneering
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: snowflake-postgres
Source: https://github.com/randoneering/nix-flake-mirror/tree/main/.claude/skills/snowflake/snowflake-postgres
Command: npx skills add https://github.com/randoneering/nix-flake-mirror --skill snowflake-postgres-randoneering

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2-binary, snowflake-connector-python, cryptography, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Snowflake Postgres operations such as creating, listing, describing, suspending, resuming, resetting credentials, and importing connections are often error-prone and require careful coordination across multiple Snowflake objects and local credential stores. This Skill provides a structured, end-to-end workflow that coordinates with scripts and references to safely perform these tasks while avoiding credential leakage.

Core Features & Use Cases

  • Create and manage Postgres instances (compute, storage, high availability, Postgres version, and optional network policy)
  • Save and manage connections securely in ~/.pg_service.conf and ~/.pgpass
  • Import existing connections and verify network policies, IP access, and credentials

Quick Start

Tell me you want to manage a Snowflake Postgres instance and I will guide you through creating, listing, suspending, resuming, or resetting credentials.

Frequently Asked Questions about snowflake-postgres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create and manage a Snowflake Postgres instance end-to-end?

To manage a Snowflake Postgres instance, you can use structured workflows to create, list, describe, suspend, resume, and reset credentials. This process coordinates compute, storage, high availability, and network policies safely without exposing secrets.

How does this skill handle Postgres credentials securely?

Postgres credentials are handled securely by saving and managing connections locally in ~/.pg_service.conf and ~/.pgpass files. The workflow ensures structured results and safe outputs without exposing secrets during operations like credential resets.

Can I import existing connections and verify network policies for Snowflake Postgres?

Yes, you can import existing connections and verify network policies, IP access, and credentials. This ensures your Snowflake Postgres instances maintain proper access controls and valid authentication before executing end-to-end management workflows.

Do I need psycopg2 and snowflake-connector-python to manage Snowflake Postgres instances?

Yes, managing Snowflake Postgres instances requires dependencies like psycopg2-binary, snowflake-connector-python, and cryptography. These libraries enable the scripts to execute end-to-end workflows, handle secure connections, and orchestrate instance operations safely.

What is the best way to suspend and resume Snowflake Postgres instances safely?

The best way to suspend and resume Snowflake Postgres instances is through structured workflows that coordinate with scripts and references. This approach applies safety rails to prevent credential leakage and ensures structured results during lifecycle management.

Why does resetting Snowflake Postgres credentials require careful coordination?

Resetting Snowflake Postgres credentials requires careful coordination because it involves updating multiple Snowflake objects and local credential stores like ~/.pgpass simultaneously. Without structured workflows, this process is error-prone and risks exposing secrets.