Data & Analytics
2,125 results
- Aidp Semantic ModelOracle Sample ProjectsMaintain a semantic grounding layer (.aidp/semantic.md) for AIDP — logical entity names, SQL-defined metrics, joins with cardinality, synonyms, and value dictionaries. Use when the user wants to define metrics/business terms, improve NL-to-SQL accuracy, standardize "revenue/customers/etc.", or set up a semantic model. Read by analyzing-data, verified-queries, profiling, and data-quality.
- Aidp SiebelOracle Sample ProjectsRead from Oracle Siebel CRM into a Spark DataFrame in an AIDP notebook via the AIDP `aidataplatform` Spark format handler. Use when the user mentions Siebel, Siebel CRM, S_CONTACT, S_ORG_EXT, or has a Siebel host/port. Auth is host/port + database name + user/password. Read-only.
- Aidp Spark DebuggingOracle Sample ProjectsDiagnose slow or failed AIDP Spark work using cluster logs, metrics, and the Spark UI REST API. Use when a job/query is slow or failed, the user asks "why did this fail / why is it slow", or you need stage/task timings, skew, shuffle/spill, executor, or SQL-execution details.
- Aidp SQL DdlOracle Sample ProjectsWrite-side Spark SQL on the AIDP lakehouse — DDL (CREATE/ALTER/DROP table·view·schema), DML (INSERT/UPDATE/DELETE/MERGE upsert), and Delta maintenance (OPTIMIZE, VACUUM, time travel, RESTORE, schema evolution, liquid clustering).
- Aidp SqlserverOracle Sample ProjectsRead or write Microsoft SQL Server from an AIDP notebook via the AIDP `aidataplatform` Spark format handler. Use when the user mentions SQL Server, MSSQL, or has a TDS host/port. Auth is host/port + database + user/password.
- Aidp Verified QueriesOracle Sample ProjectsRegister and validate reusable question→Spark-SQL pairs in .aidp/verified-queries.md so the agent reuses trusted SQL before generating new SQL. Use when the user wants to save a working query as canonical, build a verified-query repository, or improve answer reliability for recurring questions. Validates each pair on the cluster before marking it verified.
- Aidpf Error TriageOracle Sample ProjectsRead-only triage router for Oracle AIDP Fusion Autopilot failures. Use when the user pastes CLI output, a traceback, an `.aidp/diagnostics` path, a run id, or says bootstrap, validate, seed, incremental, dashboard, OAC, or workbook failed.
- Aidpf Error TriageOracle Sample ProjectsRead and explain AIDPF error codes, tracebacks, diagnostics, run IDs, datasets, layers, and variation failures, then route to the owning recovery Skill or command. Use whenever a bundle workflow fails or the user pastes failure evidence.
- Fabric Aidp MigratorOracle Sample ProjectsMigrate a Microsoft Fabric workspace (notebooks, Warehouse T-SQL, Dataflow Gen2 / Power Query M, Data Pipelines, Lakehouse shortcuts, OneLake paths) to Oracle AI Data Platform. Use when the user wants to inventory a Fabric estate, plan a migration to AIDP, translate Fabric notebooks, Warehouse T-SQL or Power Query to Spark, verify a migration's output, or publish it into an AIDP workspace.
- Mart AuthorOracle Sample ProjectsAuthor a new medallion node (gold mart, silver dim, or additive column) when the live gold layer AND the content pack both cannot serve a business need. Takes the user's business logic, inspects the Fusion PVO SOURCE schema (not bronze) for available raw fields, and authors the lowest-cost, additive, non-destructive change as content-pack YAML + SQL in an overlay pack — never touching…
- Medallion AuthorOracle Sample ProjectsDraft a content-pack overlay extending the starter pack's variation-point candidate lists when `aidp-fusion-autopilot bootstrap` fails AIDPF-2010 / AIDPF-2011. Reads diagnostic artifacts under `.aidp/diagnostics/<run_id>/`, proposes new candidates from the observed bronze schema, presents a draft overlay for operator approval, and drafts a backend-aware remediation runbook (Option A/B/D/E…
- Oac Dataset AdvisorOracle Sample ProjectsTurn a natural-language dashboard request into a concrete OAC dataset plan, grounded in the LIVE AIDP gold layer. Inspects the actual materialized Delta tables in the AIDP catalog (evidence — never the content-pack YAMLs), checks what OAC datasets already exist via OAC MCP, then tells the operator exactly which OAC dataset to create (which AIDP gold table(s), which columns, which join key) — or…
- Oac Dataset AdvisorOracle Sample ProjectsTranslate a dashboard request into an OAC dataset plan grounded in live AIDP gold tables and existing OAC catalog evidence. Use to select tables, columns, joins, reusable datasets, or identify a true mart gap.
- Oac Dataset SetupOracle Sample ProjectsGuide the governed manual OAC AIDP connection and dataset checkpoint, then verify the result through OAC MCP. Use after dataset advice, when creating or reusing an OAC dataset, or before workbook authoring.
- PomodorojakedahnSimple Pomodoro timer for focused work sessions with session tracking and productivity analytics. Use when users request focus timers, ask about productivity patterns, or want to track work sessions over time. Demonstrates the System Skill Pattern (CLI + SKILL.md + Database).
- Snowflake Migration PlanOracle Sample ProjectsBuild a high-level Snowflake to AIDP migration plan and present it for approval. States which objects can migrate and which cannot with a brief reason for each, applies user-supplied restrictions such as excluded databases or size caps, derives dependency order so views follow their base tables, and lists the Silver and Gold job stubs.
- Snowflake Migrator OverviewOracle Sample ProjectsRouter, runbook and shared rules for migrating a Snowflake estate onto Oracle AI Data Platform (AIDP). Read this first whenever the user mentions migrating, moving, assessing, inventorying or cloning Snowflake databases, schemas, tables, views or warehouses onto AIDP, asks to "run the migration" or "start from zero", or asks what a Snowflake migration would involve.
- Workbook AuthoringOracle Sample ProjectsGenerate, bind, validate, save, and preview OAC workbook JSON using deterministic templates and OAC MCP. Use when creating or updating supported OAC workbook visualizations over a verified dataset.
- Skill Debugging AssistantExploration-labsDebug, diagnose, and troubleshoot skill issues including trigger failures, parameter problems, prompt conflicts, and SKILL.md structural issues. Use when skills don't activate as expected, trigger incorrectly, produce unexpected behavior, conflict with system instructions, or fail packaging validation.
- Skill Dependency MapperExploration-labsAnalyzes skill ecosystem to visualize dependencies, identify workflow bottlenecks, and recommend optimal skill stacks. Use when asked about skill combinations, workflow optimization, bottleneck identification, or which skills work together. Triggers include phrases like "which skills work together", "skill dependencies", "workflow bottlenecks", "optimal skill stack", or "recommend skills for".
- ImessagedvdsglInteract with Messages app - read conversations, send messages, and check for new messages using AppleScript and SQLite database access
- Word StatshumanizeraiGet word count, character count, reading time, and text statistics. Quick analysis without questions.
- Shodan Censys ReconuseosintFind internet-exposed hosts, services, and devices from third-party scan data. Use when searching Shodan or Censys, finding open ports and banners, identifying an IP's tech stack, or discovering exposed databases, cameras, or industrial devices — without scanning the target yourself.
- Who Really Owns ItuseosintResearch companies, directors, shareholders and ultimate beneficial ownership in official corporate registries, filings and offshore datasets — OpenCorporates, UK Companies House and the PSC register, SEC EDGAR, US Secretary of State registries, EU business registers, GLEIF LEI records, OpenOwnership, OpenSanctions and the ICIJ Offshore Leaks database.