Data Analyzer
Community•数据与 AI•v1.0.0
Data analysis tool for Excel, CSV, Word, PDF, TXT, Markdown files. Use when user needs to analyze, summarize, or compare data from multiple files. Supports folder scanning, data aggregation, statistics, report generation in Markdown/Excel/Word/PDF. Multi-language support. 数据分析、文件夹分析、Excel分析。
Zouroboros Memory
Community•数据与 AI•v1.0.0
Production-grade persistent memory for AI agents. Hybrid SQLite + vector search, decay classes, episodic memory, cognitive profiles, and MCP server.
Data Completeness Check
Community•数据与 AI•v1.0.0
数据完整性判断机制。通过前晚基准值 vs 早上值对比,判断 Power BI 数据是否回灌完毕。适用于任何有延迟回灌的数据源。避免发送不完整数据。
Daily Data Tracker
Community•数据与 AI•v1.0.0
每日数据追踪与历史记录。维护每日关键指标的历史表格(日期/Revenue/Gross Adds/EOP/Paid Subs/端拆分),支持 WoW 计算和趋势分析。数据追加到 memory/powerbi-daily-track.md 的历史表。
Volcano Plot Script
Community•数据与 AI•v1.0.0
Generate R/Python code for volcano plots from DEG (Differentially Expressed Genes) analysis results. Triggered when user needs visualization of gene expression data, p-value vs fold-change scatter plots, publication-ready figures for bioinformatics analysis.
Uplo Data Analytics
Community•数据与 AI•v1.0.0
AI-powered data analytics knowledge management. Search data pipeline documentation, dashboard specifications, data governance policies, and reporting standards with structured extraction.
stock_data
Community•数据与 AI•v1.0.0
Fetch comprehensive stock data from Simplywall.st. Use when user asks about stock prices, valuation, financials, dividend, or investment analysis for any global stock.
SQLite
Community•数据与 AI•v1.0.0
Use SQLite correctly with proper concurrency, pragmas, and type handling.
SQL Toolkit
Community•数据与 AI•v1.0.0
Query, design, migrate, and optimize SQL databases. Use when working with SQLite, PostgreSQL, or MySQL — schema design, writing queries, creating migrations, indexing, backup/restore, and debugging slow queries. No ORMs required.
SQL 文件拆分工具
Community•数据与 AI•v1.0.0
拆分 SQL 文件为独立文件(存储过程、函数、视图、触发器、表结构、索引、约束),自动分析依赖并生成合并脚本
sql-server-toolkit
Community•数据与 AI•v1.0.0
Command-line toolkit for Microsoft SQL Server.
Sql Server Skills
Community•数据与 AI•v1.0.0
Comprehensive SQL Server performance diagnostics, index analysis, execution plan interpretation, query optimization, schema management, backup/restore, and monitoring using sqlcmd and T-SQL DMVs. Use when analyzing slow queries, investigating wait stats, finding missing indexes, reading execution plans, optimizing stored procedures or views, managing migrations, monitoring SQL Agent jobs, or diagnosing blocking/deadlocks on Microsoft SQL Server. Triggers on: SQL Server, MSSQL, sqlcmd, T-SQL performance, slow query, execution plan, DMV, missing index, wait stats, blocking, deadlock, stored procedure optimization, view tuning.
sql-reflect
Community•数据与 AI•v1.0.0
快速定位 SQL 语句在 PHP/Laravel 代码中的触发位置,通过分析 SQL 结构反向追踪到具体的代码文件、方法和行号
SQL Query Reviewer
Community•数据与 AI•v1.0.0
Review SQL queries across any dialect for correctness, performance, and security. Finds N+1 patterns, missing indexes, injection risks, cartesian joins, and implicit type casts. Returns a structured report with severity ratings and optimize
Sql Pro
Community•数据与 AI•v1.0.0
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Sql Optimization Patterns
Community•数据与 AI•v1.0.0
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
SQL Master
Community•数据与 AI•v1.0.0
SQL 查询、数据获取智能体。覆盖 SQL 全链路能力:自然语言转生产级 SQL、慢查询诊断与执行计划分析、索引设计与优化、数仓建模、SQL 原理深度科普、查询结果可视化。支持 MySQL / PostgreSQL / Hive / Spark SQL / ClickHouse / BigQuery 多方言。触发场景:(1) 写 SQL / 生成查询,(2) SQL 慢/优化/调优,(3) 执行计划分析 EXPLAIN,(4) 索引设计,(5) 数仓建模 / 分层设计,(6) SQL 原理问题(事务/锁/MVCC/Join算法等),(7) 表结构设计 DDL,(8) SQL 报错诊断,(9) 任何"帮我写个查询"、"这个SQL为什么慢"、"怎么建索引"类请求,(10) 查询结果可视化 / 出图 / 图表 / 数据展示。
当用户希望“通过建表语句 + 慢 SQL 自动优化索引”时使用此 Skill,支持 MySQL、Oracle、PostgreSQL。脚本使用 Python,自动解析 DDL 与慢 SQL 中的 WHERE/JOIN/ORDER BY 列,生成候选索引及对应数据库的 CREATE INDEX 语句,并输出到文件。
Community•数据与 AI•v1.0.0
当用户希望“通过建表语句 + 慢 SQL 自动优化索引”时使用此 Skill,支持 MySQL、Oracle、PostgreSQL。脚本使用 Python,自动解析 DDL 与慢 SQL 中的 WHERE/JOIN/ORDER BY 列,生成候选索引及对应数据库的 CREATE INDEX 语句,并输出到文件。
提供数据库ddl内容,根据自然语言生成sql
Community•数据与 AI•v1.0.0
你是一个专业的SQL生成专家。根据用户提供的自然语言需求,自动提取产品名称并生成SQL SELECT查询语句。
Sql Generator
Community•数据与 AI•v1.0.0
📊 SQL生成器 — sql.sh. Use when you need sql generator capabilities. Triggers on: sql generator.
SQL 查询优化助手
Community•数据与 AI•v1.0.0
Use this skill when you need to write, review, optimize, or debug SQL queries. Covers query construction, performance tuning, index strategy, window functions, CTEs, and common anti-patterns for PostgreSQL, MySQL, and SQLite.
SQL
Community•数据与 AI•v1.0.0
Master relational databases with SQL. Schema design, queries, performance, migrations for PostgreSQL, MySQL, SQLite, SQL Server.
Semantic Cache
Community•数据与 AI•v1.0.0
Semantic cache for LLM API calls using Redis. Caches responses by meaning, not exact match.
Activate when the user wants to cache AI responses, reduce API costs, speed up repeated queries,
or add semantic caching to any workflow. Use this skill to check cache before making expensive
LLM calls and store results for future similar queries.
Data Analysis
Community•数据与 AI•v1.0.0
Analyze data, generate insights, and create reports.