Skip to content
Skills Library
Data & analytics · Analysis

snowflake-database-analyzer

/snowflake-database-analyzer

When the user needs to explore, analyze, and manipulate Snowflake database structures and data. This skill provides 1) Listing databases, schemas, and tables within Snowflake environments, 2) Describing table structures including column names, data types, and constraints, 3) Executing read queries to extract employee data, task assignments, and status information, 4) Performing write operations to insert new records or update existing data, 5) Joining tables to establish relationships between employees, managers, and tasks, 6) Querying current dates and comparing with deadlines. Triggers inclu

Repository
skills ↗
Licence
MIT
Last repository change
05.07.2026

Assessment and security

90/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content25 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
3
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 05.07.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

When the user needs to explore, analyze, and manipulate Snowflake database structures and data. This skill provides 1) Listing databases, schemas, and tables within Snowflake environments, 2) Describing table structures including column names, data types, and constraints, 3) Executing read queries to extract employee data, task assignments, and status information, 4) Performing write operations to insert new records or update existing data, 5) Joining tables to establish relationships between employees, managers, and tasks, 6) Querying current dates and comparing with deadlines. Triggers inclu

Original author description

When the user needs to explore, analyze, and manipulate Snowflake database structures and data. This skill provides 1) Listing databases, schemas, and tables within Snowflake environments, 2) Describing table structures including column names, data types, and constraints, 3) Executing read queries to extract employee data, task assignments, and status information, 4) Performing write operations to insert new records or update existing data, 5) Joining tables to establish relationships between employees, managers, and tasks, 6) Querying current dates and comparing with deadlines. Triggers inclu

How it works

  1. Core Workflow
Original SKILL.md headings · 43 lines, 387 words
SKILL.md preview
---
name: snowflake-database-analyzer
description: When the user needs to explore, analyze, and manipulate Snowflake database structures and data. This skill provides 1) Listing databases, schemas, and tables within Snowflake environments, 2) Describing table structures including column names, data types, and constraints, 3) Executing read queries to extract employee data, task assignments, and status information, 4) Performing write operations to insert new records or update existing data, 5) Joining tables to establish relationships between employees, managers, and tasks, 6) Querying current dates and comparing with deadlines. Triggers include 'Snowflake database', 'query employee data', 'database schema exploration', 'data extraction from tables', 'database updates'.
---
# Instructions

## Core Workflow
This skill orchestrates a multi-step process to manage employee onboarding and task reminders via a Snowflake database. Follow these steps precisely.

### 1. Initial Exploration & Context Gathering
*   **Objective:** Understand the database landscape and locate the relevant onboarding document.
*   **Actions:**
    1.  List all available Snowflake databases. Identify the one likely containing employee data (e.g., `LANDING_TASK_REMINDER`).
    2.  List the contents of the `/workspace/dumps/workspace` directory to find the onboarding PDF (e.g., `landing_tips.pdf`).
    3.  Read the PDF to extract the standardized task list, deadlines (D+7, D+30, etc.), and group assignments (Backend, Frontend, Testing, Data).

### 2. Database Schema Investigation
*   **Objective:** Map the database structure to understand how data is organized.
*   **Actions:**
    1.  List all schemas within the target database.
    2.  List all tables within the target schema (e.g., `PUBLIC`).
    3.  Describe the key tables to understand their columns:
        *   `EMPLOYEE` (ID, Name, Email, Manager_ID)
        *   `EMPLOYEE_LANDING` (Employee_ID, Landing_Date, Task_Assigned_Flag)
        *   `PUBLIC_TASKS` (Employee_ID, Task_Name, Deadline, Status)
        *   Group-specific task tables (`GROUP_TASKS_BACKEND`, `GROUP_TASKS_FRONTEND`, etc.)

### 3. Data Analysis & Logic Building
*   **Objective:** Identify new employees needing onboarding and existing employees with overdue tasks.
*   **Actions:**
    1.  Query the `EMPLOYEE` and `EMPLOYEE_LANDING` tables. Cross-reference to find employees where `LANDING_TASK_ASSIGNED = FALSE`. These are the new hires.
    2.  For each new hire, determine their group/manager by joining the `EMPLOYEE` table with itself (manager lookup via `REPORT_TO_ID`). Infer group from manager ID based on historical data from group task tables.
    3.  Get the current date (`CURRENT_DATE()`).
    4.  For each task table (`PUBLIC_TASKS`, `GROUP_TASKS_*`), query for records where `FINISHED_FLAG = FALSE` AND `DDL < CURRENT_DATE()`. Join with employee/manager data for context.

### 4. Data Manipulation & Task Creation
*   **Objective:** Create task records for new employees and update their status flags.
*   **Actions:**
    1.  For each new employee, calculate deadlines based on their landing date and the rules from the PDF (e.g., Public Tasks: D+7, Backend Tasks: D+30).
    2.  Execute `INSERT` statements into `PUBLIC_TASKS` and the appropriate `GROUP_TASKS_*` table with the task names, calculated deadlines, and `FINISHED_FLAG = FALSE`.
    3.  Update the `EMPLOYEE_LANDING` table, setting `LANDING_TASK_ASSIGNED = TRUE` for the processed new hires.

### 5. Communication & Notification
*   **Objective:** Send formatted emails to employees and their managers.
*   **Actions:**
    1.  **For New Employees (Onboarding):** Generate an email for each new hire. Use the exact format:
        
Files in this package (3)
  • SKILL.md 4 KB
  • references/email_templates.md 1 KB
  • references/task_schema.md 2 KB

Versions

The database has no other skills named snowflake-database-analyzer.

Database snapshot: 13.11.2026 · package version 7ab0802da4a6 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 1 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100snowflake-explore
    Discover databases, schemas, tables, views, and columns in Snowflake. Use when the user wants to understand what data is available or inspect table structure.
  • 100snowflake-development
    This skill should be used when the user asks to "optimize Snowflake queries", "analyze Snowflake SQL performance", "size Snowflake warehouses", "review Snowflake data models", or "troubleshoot Snowflake cost issues".
  • 100mysql
    Execute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions…
  • 100database-scout
    Explore SQLite and PostgreSQL databases: list tables, inspect schemas (columns/types/constraints), preview data, generate Mermaid ER diagrams, and run safe read-only queries. Triggered by requests to explore a database, view table structures, describe tables, generate diagrams,…
  • 100snowflake-api
    Run SQL against Snowflake — submit statements, poll async handles, fetch result partitions, cancel, and browse warehouses/databases/schemas/tables. Use this whenever the user wants to query Snowflake, ask "what tables are in this schema", check a warehouse's status, or mentions…
  • 100pgtool
    PostgreSQL database exploration and debugging. Use when user asks to explore database schemas, tables, columns, or run queries. Requires a `.pgtool.json` file in the project directory.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.