数据库
数据库管理与查询
trino-optimizer
treasure-data
TD Trino performance optimization including CTAS (5x faster), UDP bucketing for ID lookups, magic comments for join distribution, REGEXP_LIKE vs LIKE, and approx functions.
hive
treasure-data
TD Hive SQL with TD-specific functions and Hive-only features (lateral view, explode, MAPJOIN hint). Use when Trino memory errors occur or for Hive-specific syntax.
parent-segment-analysis
treasure-data
Query and analyze CDP parent segment database data. Use tdx ps desc -o to get output database schema, then query customers and behavior tables. Use when exploring parent segment data, building reports, or analyzing customer attributes and behaviors.
rt-config-events
treasure-data
Configure RT 2.0 event tables and key events - define which streaming events to track and filter for real-time processing
dbt
treasure-data
dbt with TD Trino. Covers profiles.yml setup (method:none, user:TD_API_KEY), required override macros (no CREATE VIEW), TD_INTERVAL in models, and TD Workflow deployment.
aps-doc-ingestion
treasure-data
Expert documentation generation for ingestion layers. Automatically detects connector types (REST API, Database, File, Streaming), documents authentication patterns, rate limiting strategies, and incremental load patterns. Use when documenting data source ingestion workflows.
aps-doc-golden
treasure-data
Expert documentation generation for golden layers. Detects SCD types, documents business rules, metric definitions, aggregation logic, and data quality scoring. Use when documenting golden layer tables.
aps-doc-core
treasure-data
Core documentation generation patterns and framework for Treasure Data pipeline layers. Provides shared templates, quality validation, testing framework, and Confluence integration used by all layer-specific documentation skills.
activations
treasure-data
Query activation logs to check for errors and view volume
aps-doc-staging
treasure-data
Expert documentation generation for staging transformation layers. Auto-detects SQL engine (Presto/Trino vs Hive), documents transformation rules, PII handling, deduplication strategies, and data quality rules. Use when documenting staging transformations.
aps-doc-master-segment
treasure-data
Expert documentation generation for CDP Master Segment (Parent Segment) configurations. Analyzes master segment tables using TD MCP, extracts attribute and behavior schemas, documents star schema relationships, and creates comprehensive segment documentation. Use when documenting CDP parent segments.
backend-development
skillcreatorai
Backend API design, database architecture, microservices patterns, and test-driven development. Use for designing APIs, database schemas, or backend system architecture.
code-review
skillcreatorai
Automated code review for pull requests using specialized review patterns. Analyzes code for quality, security, performance, and best practices. Use when reviewing code changes, PRs, or doing code audits.
database-design
skillcreatorai
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
volcengine-rds-mysql
bytedance
使用火山引擎 RDS MySQL MCP Server，帮助用户完成 RDS MySQL 相关的实例管理、数据库操作、账号管理和运维任务，可直接调用 uv run ./scripts/call_rds_mysql.py 脚本获取实时结果。
Intelligence Layer Skill
markus41
AnythingLLM Documentation
oni-mcp-game-advisor
LIghtJUNction
当用户询问 ONI 游戏机制、建筑/资源/元素/动植物用途、策略建议，或在未授权控制游戏时问“我该做什么”时使用。事实性答案优先依据可验证的外部文档或静态仓库资料；仅当建议依赖当前存档时读取只读殖民地、世界和资源状态，不调用已禁用的游戏内 knowledge/database/guide 查询。
web-search
bytedance
使用内置 web_search 函数进行网页搜索并返回摘要结果, 准备清晰具体的 query。运行脚本 python scripts/web_search.py "query"。根据返回的摘要列表组织答案，不新增或臆造内容。
oracle-dba
acedergren
Use when managing Oracle Autonomous Database on OCI, troubleshooting performance issues, optimizing costs, or implementing HA/DR. Covers ADB-specific gotchas, cost traps, SQL_ID debugging workflows, auto-scaling behavior, and version differences (19c/21c/23ai/26ai).
finops-cost-optimization
acedergren
Use when optimizing OCI costs, investigating unexpected bills, planning budgets, or identifying waste. Covers hidden cost traps (boot volumes, reserved IPs, egress), Universal Credits gotchas, shape migration savings, free tier maximization, and cost allocation challenges.
drizzle-best-practices
honra-io
Drizzle ORM best practices for TypeScript projects using PostgreSQL. Use this skill when writing, reviewing, or optimizing Drizzle ORM schemas, queries, relations, migrations, or database configurations targeting Postgres. Apply these guidelines whenever you see drizzle-orm imports, pgTable definitions, drizzle-kit config files, or relational query patterns. Also use when setting up a new project with Drizzle + Postgres, migrating from another ORM, or troubleshooting type errors in Drizzle schemas.
json-schema
beshkenadze
Generate and validate JSON Schema definitions. Use when asked to create schemas, validate JSON structure, or document API payloads.
bio-similarity-searching
GPTomics
Performs molecular similarity searches using Tanimoto coefficient on fingerprints via RDKit. Finds structurally similar compounds using ECFP or MACCS keys and clusters molecules by structural similarity using Butina clustering. Use when finding analogs of a query compound or clustering chemical libraries.
bio-clinical-databases-myvariant-queries
GPTomics
Query myvariant.info API for aggregated variant annotations from multiple databases (ClinVar, gnomAD, dbSNP, COSMIC, etc.) in a single request. Use when annotating variants with clinical and population data from multiple sources simultaneously.