Can I use this for complex analytics like funnels?

Absolutely. The skill includes pre-defined patterns and templates for session calculation, conversion funnels, and retention analysis.

What games are supported by the sql-writer skill?

The skill currently supports analytics for litemeta, linkpang, pkpkg, matchflavor, matchwitch, and traincf titles.

Does this skill support safe query execution?

Yes, it includes mandatory partition filter checks (for fields like dt or log_date) and row limits to prevent accidental full table scans.

How does the log specification lookup work?

The skill integrates with Google Cloud auth to fetch event definitions and field details directly from Google Sheets specifications.

SQL Writer for Game Analytics

Name: SQL Writer for Game Analytics
Author: treenod-IDQ

bytreenod-IDQ

•

Database Management

Generates, validates, and executes Databricks SQL queries specifically for mobile game analytics and user behavior tracking.

The sql-writer skill empowers Claude to act as a specialized data analyst for game telemetry, specifically integrated with Databricks environments. It enables users to research log specifications from Google Sheets, explore complex schemas across multiple game titles such as Litemeta and Linkpang, and write optimized SQL queries for critical metrics like retention and funnel analysis. With built-in validation and safety protocols—including mandatory partition filters and row limits—it ensures that queries are both syntactically accurate and resource-efficient before execution in production environments.

Key Features

01Support for nested properties extraction and session calculation patterns

02Automated Databricks SQL query generation and syntax validation

03Log specification lookup for specific game events and field definitions

04Safe query execution with enforced partition filters and row limits

05Interactive schema exploration and table metadata retrieval

061 GitHub stars

Use Cases

01Extracting and formatting nested JSON properties from production telemetry tables

02Analyzing player retention and churn behavior across multiple game titles

03Researching specific event properties and game data fields within log specifications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add treenod-idq/treenod-market sql-writer

For use in Claude.ai and ChatGPT

Download Skill