Bases de dades
Gestió i consultes de bases de dades
modular-saas-architecture
peterbamuhigire
"Build SAAS platforms with pluggable business modules (Advanced Inventory, Restaurant, Pharmacy, etc.) that can be enabled/disabled per tenant without breaking the system. Use when designing modular SAAS features, implementing module toggles, ensuring module independence, and building scalable multi-tenant platforms with optional features."
legacy-bridge
williamzujkowski
Backward compatibility bridge that translates legacy @load patterns to new Skills format. Enables seamless migration with zero breaking changes during 6-month transition period.
kotlin-coding-standards
williamzujkowski
Master Kotlin coding standards with null safety, coroutines, and idiomatic patterns. Use when developing JVM/Android applications requiring type-safe async programming.
nosql
williamzujkowski
Nosql standards for nosql in Database environments. Covers best practices,
batch-processing
dadbodgeoff
Collect-then-batch pattern for database operations achieving 30-40% throughput improvement. Includes graceful fallback to sequential processing when batch operations fail.
ai-coaching
dadbodgeoff
Multi-turn conversational AI for intent extraction, clarification, and generation readiness detection. Guides users through articulating creative intent with structured parameter extraction.
checkpoint-resume
dadbodgeoff
Exactly-once processing semantics with distributed coordination for file-based data pipelines. Atomic file claiming, status tracking, and automatic retry with in-memory fallback.
multi-tenancy
dadbodgeoff
Implement multi-tenant architecture with tenant isolation, data separation, and per-tenant configuration. Supports shared database and schema-per-tenant models.
waterline
sailscastshq
Waterline ORM query language, model definitions, associations, and data access patterns for Sails.js. Use this skill when writing, reviewing, or debugging Waterline queries, model attributes, associations, lifecycle callbacks, validations, or any database interaction in a Sails.js application.
tdx-basic
treasure-data
Executes tdx CLI commands for Treasure Data. Covers tdx databases, tdx tables, tdx query, tdx auth setup, context management with profiles/sessions, and output formats (JSON/TSV/table). Use when users need tdx command syntax, authentication setup, database/table exploration, or query execution.
trino
treasure-data
TD Trino SQL with TD-specific functions (td_interval, td_time_range, td_time_string, td_sessionize). Use for time-based filtering, partition pruning, and TD query patterns.
schema-auto-tagger
treasure-data
Automated schema tagging and resource classification for Treasure Data. Detects new tables/columns, analyzes metadata patterns, and suggests appropriate policy tags with confidence scoring. Reduces manual tagging effort by 80% while maintaining compliance standards (GDPR, CCPA, HIPAA, SOX).
time-filtering
treasure-data
Advanced td_interval patterns including offset dates (-1d/2025-10-01, -7d/-1d, 0M/now), td_interval_range for debugging, td_time_string for display formatting, and partition pruning optimization.
trino-to-hive-migration
treasure-data
Convert Trino queries to Hive when memory errors occur. Covers syntax differences (td_time_string→TD_TIME_FORMAT, REGEXP_LIKE→RLIKE, ARRAY_AGG→COLLECT_LIST) and engine selection.
pytd
treasure-data
Expert assistance for using pytd (Python SDK) to query and import data with Treasure Data. Use this skill when users need help with Python-based data analysis, querying Presto/Hive, importing pandas DataFrames, bulk data uploads, or integrating TD with Python analytical workflows.
identity
treasure-data
Query identity change logs to explore profile creation and merging
parent-segment
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
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
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
treasure-data
Monitor RT journeys - track activation success, debug failures, query activation logs, and optimize performance
digdag
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
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
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
treasure-data
Write effective system prompts for TD AI agents. Covers role definition, constraint specification, output formatting, tool usage instructions, and prompt structure patterns.