Database
Database management and queries
parent-segment
by treasure-data
Manages CDP parent segments using tdx ps commands with YAML configs. Covers master tables, attributes, behaviors, tdx ps validate for join validation, tdx ps preview for data preview, and schedule configuration (daily/hourly/cron). Use when creating customer master tables, validating join match rates, or troubleshooting parent segment workflows.
aps-doc-hist-union
by treasure-data
Expert documentation generation for hist-union workflows. Documents historical and incremental table combination strategies, schema validation, time-based partitioning, and backfill processes. Use when documenting hist-union layers.
segment
by treasure-data
Manages CDP child segments using tdx sg commands with YAML rule configs. Covers filtering with operators (Equal, In, Greater, TimeWithinPast, Contain), folder organization, and activations for Salesforce/Google Ads exports. Use when creating audience segments, validating with tdx sg push --dry-run, or listing fields with tdx sg fields.
rt-journey-monitor
by treasure-data
Monitor RT journeys - track activation success, debug failures, query activation logs, and optimize performance
digdag
by treasure-data
Treasure Workflow (digdag) for TD. Covers .dig syntax, session variables (session_date, session_date_compact), td> operator, _parallel/_retry/_error directives, and tdx wf commands.
connector-config
by treasure-data
Writes connector_config for segment/journey activations using tdx connection schema <type> to discover available fields. Use when configuring activations - always run schema command first to see connector-specific fields.
rt-config
by treasure-data
Configure RT 2.0 (Real-Time Personalization) for parent segments including event tables, key events, RT attributes, and ID stitching using tdx ps rt commands or API
agent-prompt
by treasure-data
Write effective system prompts for TD AI agents. Covers role definition, constraint specification, output formatting, tool usage instructions, and prompt structure patterns.
rt-config-id-stitching
by treasure-data
Configure RT 2.0 ID stitching - merge real-time profiles across different identifiers using stitching keys and primary keys
trino-optimizer
by 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
by 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
by 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
by treasure-data
Configure RT 2.0 event tables and key events - define which streaming events to track and filter for real-time processing
dbt
by 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
by 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
by 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
by 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
by treasure-data
Query activation logs to check for errors and view volume
aps-doc-staging
by 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
by 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
by skillcreatorai
Backend API design, database architecture, microservices patterns, and test-driven development. Use for designing APIs, database schemas, or backend system architecture.
code-review
by 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
by 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
by bytedance
使用火山引擎 RDS MySQL MCP Server，帮助用户完成 RDS MySQL 相关的实例管理、数据库操作、账号管理和运维任务，可直接调用 uv run ./scripts/call_rds_mysql.py 脚本获取实时结果。