Skill UI

This comprehensive guide details strategies for migrating enterprise data platforms to Databricks. It provides PySpark examples for discovery, schema mapping (converting types from Hadoop, Snowflake, etc.), and executing robust data transfer methods like SYNC, DEEP CLONE, and CTAS. Use this when moving data from legacy sources like Hadoop, Snowflake, or Redshift to a modern Delta Lake environment.

Designs normalized database schemas by analyzing requirements, mapping relationships, generating ERD diagrams, and producing SQL CREATE statements so you can build well-structured relational databases and follow best practices.

This advanced workflow executes sophisticated web data gathering tasks. It supports three primary functions: LLM-powered structured data extraction using custom JSON schemas or prompts; efficient batch scraping of multiple known URLs; and rapid site mapping to discover all reachable URLs on a domain. Use this when you require reliable, typed data structures rather than raw markdown content.

This deep-dive guide provides a comprehensive framework for migrating complex operational data into the MaintainX platform. It systematically guides users through assessing source data quality from legacy CMMS systems (like Maximo), spreadsheets, or custom databases. The process covers essential steps including data assessment, schema mapping, and executing robust ETL processes for work orders and assets, ensuring a smooth re-platforming transition.

This skill is designed for understanding complex database structures. It allows users to list all available tables, intelligently filter relevant tables based on natural language queries, retrieve detailed schemas (columns, types, primary/foreign keys), and map inter-table relationships. It culminates in generating the M-Schema format, which is essential for accurately preparing the context needed for advanced SQL query generation.

A comprehensive guide detailing professional data migration strategies for Salesforce. It covers utilizing Bulk API 2.0, implementing ETL patterns, complex schema mapping, and preserving object relationships (parent-child). Ideal for large-scale CRM data transfers, org-to-org migrations, and data re-platforming.

A comprehensive playbook for API reconnaissance and documentation review. Use this skill early in the testing process to enumerate all reachable endpoints, extract schemas, identify hidden versions (e.g., v1, v2, mobile), and discover undocumented parameters or fields across REST, GraphQL, and mobile APIs. Essential for mapping the full attack surface before deeper exploitation.

This skill generates comprehensive Entity Relationship Diagrams (ERDs) and database schemas as D2 source code from an existing Entity Framework Core codebase. It analyzes DbContexts, DbSet declarations, Fluent API mappings, and migrations to accurately visualize tables, columns, primary/foreign keys, relationships (including many-to-many joins), owned types, and constraints. The output is a structured .d2 file, suitable for rendering into SVG or PNG, helping developers document the persistence model.

Builds the smallest useful analytics dashboard metric register for a business: metric, source module, formula, period, value, target, trend and owner. Starts from the decision the dashboard supports, then emits CSV, SQL DDL, JSON Schema or a Notion mapping only on request.

Designs and builds the smallest useful asset and IT register for a business: serial numbers, model, condition, assignee, location, purchase value, warranty expiry and return date. Outputs CSV, SQL DDL, JSON Schema or Notion mappings on request for asset audits and equipment tracking.

Daily attendance register for check-in and check-out, hours worked, work mode, late minutes, leave and regularisation flags. Outputs CSV, SQL, JSON Schema or Notion mapping on request, suitable for payroll input.

Builds a compliance audit trail register capturing timestamp, user, module, record, action, changed field, old and new values and change reason. Outputs CSV, SQL DDL, JSON Schema or Notion mappings on request for change history and control evidence.