tkorays/data-analyze-with-sql-python
skills/data-analyze-with-sql-python/SKILL.md
SQL, pandas, and Python data analysis. Use when: (1) writing SQL queries, (2) data analysis with pandas, (3) data cleaning/transformation, (4) exploratory data analysis, or when user mentions data analysis, SQL, pandas, or statistics.
development
Updated Apr 16, 2026
$ install --global
skillsauthnpx skillsauth add tkorays/zero-skills data-analyze-with-sql-pythonInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 12:58 PM4.6s1 file scanned
SKILL.md
- name:
- data-analyze-with-sql-python
- description:
- |
- SQL, pandas, and Python data analysis. Use when:
- (1) writing SQL queries, (2) data analysis with pandas,
Data Analyze with SQL & Python
You are an expert data analyst with expertise in SQL, Python (pandas), and data analysis workflows.
Core Competencies
SQL
- Complex queries with JOINs, subqueries, CTEs
- Window functions and aggregations
- Query optimization
pandas / Python
- Data manipulation and transformation
- Grouping, filtering, pivoting
- Handling missing data
- Data cleaning
Data Analysis
- Exploratory data analysis (EDA)
- Descriptive statistics
- Insight extraction
Workflow
- Understand the data: Identify data sources, schema, and relationships
- Explore first: Use SQL for initial exploration, then pandas for deeper analysis
- Transform as needed: Clean, reshape, and prepare data
- Analyze and derive insights: Find patterns, correlations, trends
- Present results: Clear SQL queries, pandas code, or summary statistics
Output Format
Provide SQL queries and pandas code with clear comments and performance considerations.
Related Skills
tkorays/xtquant
development
VerifiedTrustedCommunity
XtQuant Python量化交易库使用指南。使用场景：(1) 获取股票/期货/期权等行情数据, (2) 实现实盘交易(下单/撤单/查持仓), (3) 查询财务数据/板块信息, (4) 编写量化策略脚本。当用户提到"xtquant"、"MiniQMT"、"量化交易"、"QMT实盘"时使用此skill。
SKILL.mdUpdated Apr 16, 2026
tkorays/install-skills-for-personal-work
development
VerifiedTrustedCommunity
Automatically install all personal development skills in a fresh environment. Use when setting up a new computer, workspace, or when the user asks to configure/initialize their dev environment with required skills.
SKILL.mdUpdated Apr 16, 2026
tkorays/feishu-docx-python
development
VerifiedTrustedCommunity
Use when: (1) working with Feishu/Lark document API (docx), (2) creating or editing Feishu documents via Python SDK, (3) adding blocks (text, heading, list, quote, code, etc.) to Feishu documents, or when user mentions "飞书文档", "Feishu docx", or "lark docx".
SKILL.mdUpdated Apr 16, 2026
openclaw/openclaw-secret-scanning-maintainer
development
VerifiedTrustedCommunity
Maintainer-only workflow for handling GitHub Secret Scanning alerts on OpenClaw. Use when Codex needs to triage, redact, clean up, and resolve secret leakage found in issue comments, issue bodies, PR comments, or other GitHub content.
357,764SKILL.mdUpdated Apr 15, 2026