staff-sql-engineer
CommunityOptimize and craft SQL queries for financial databases.
Finance & Accounting#postgresql#optimization#financial data#data modeling#sql#query performance#snowflake
AuthorWayneBanksy
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill enables precise construction, optimization, and modeling of SQL queries tailored for Snowflake and PostgreSQL, addressing common challenges in financial data environments.
Core Features & Use Cases
- Query Writing and Optimization: Create efficient SQL queries, enhance performance, and troubleshoot slow-running statements.
- Data Modeling: Design star schemas, implement Slowly Changing Dimensions (SCD Type 2), and structure complex data models.
- Use Cases: Automate query tuning for large datasets, develop incremental models in dbt, and apply Snowflake-specific features like VARIANT handling and clustering to improve data retrieval times.
Quick Start
Write a SQL query to calculate daily account balances using CTEs and window functions.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: staff-sql-engineer Download link: https://github.com/WayneBanksy/wayneys_claude/archive/main.zip#staff-sql-engineer Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.