3. Data, Science & AI

Defines batch quantities and componentized recipe structure for a recipes application's data model.

Explains MVCC mechanisms in KalamDB: versioned records, visibility rules, snapshot reads, and transaction lifecycle management.

Provides DataFusion integration for query execution, logical/physical plan handling, and SQL routing within data processing pipelines.

Enables AI agents to discover available tools and capabilities via progressive disclosure, enhancing agent autonomy in LLM workflows.

Enables hydrodynamic diffraction analysis through integration of AQWA, OrcaWave, and BEMRosetta software.

Converts hydrodynamic coefficients between AQWA and OrcaFlex formats, supporting QTF and mesh data for marine structural analysis.

Creates composable AI agent systems in NestJS with orchestrator, planner, executor, and evaluator components, supporting DAG-based planning and database-backed state persistence.

Provides guidance for executing Jupyter Notebooks and integrating with Databricks kernels for data science and machine learning tasks.

Comprehensive guide for data engineering, machine learning infrastructure, and permission design on the Databricks platform.

Expert guide for GoogleSQL queries, data management, performance tuning, and cost optimization in BigQuery.

Provides expert guidance on dbt development best practices, command execution, and environment configuration for efficient data transformation and modeling.

Performs vortex-induced vibration (VIV) analysis for risers and tubular members, including natural frequency, safety factor, and fatigue assessment calculations.

Analyzes catenary and lazy wave riser configurations for static shape, forces, and generates OrcaFlex models from parameters.

Generates and optimizes panel meshes for OrcaWave diffraction analysis, including CAD conversion, quality validation, and GDF file output for hydrodynamic computations.

Converts OrcaWave diffraction results to OrcaFlex vessel types, handling hydrodynamic database generation, RAO import, and coordinate transformations.

Generates and manipulates finite element meshes for engineering simulations using GMSH, supporting 1D/2D/3D and integration with simulation tools.

Automates OrcaFlex marine engineering model creation using template-based component assembly and lookup tables for vessels, risers, materials, and environments.

Compares OrcaFlex simulation results for design verification, sensitivity analysis, and configuration comparison, including pretension, stiffness, and force distribution.

Configures OrcaFlex line properties and automates tension/length calculations for mooring lines and risers using the Line Setup Wizard.

Specializes in multi-body hydrodynamic interactions for offshore vessel operations, including coupled analysis and gap resonance effects in OrcaWave.

Generates comprehensive visualizations from OrcaFlex simulation data including model views, time series, and interactive HTML reports using Plotly for analysis presentation.

Post-processes OrcaFlex simulation results to extract statistics, generate graphs, and create interactive HTML reports from .sim files.

Configures wave spectra, current profiles, wind loading, and seabed properties for OrcaFlex offshore structural analysis simulations.

Performs advanced marine hydrodynamics analysis including wave-structure interaction, added mass/damping, and QTF computations for OrcaFlex database generation.