data▌

Senior-level data engineering expertise for building scalable pipelines, ETL systems, and production data infrastructure. \n \n Covers advanced patterns across data pipeline architecture, modeling, and DataOps with distributed computing frameworks (Spark, Airflow, dbt, Kafka) and modern data stack tools (Databricks, BigQuery, Snowflake) \n Includes production deployment patterns for scalable data processing, ML model serving with low latency, and real-time inference with auto-scaling and monitor

Fetches financial and market data from Yahoo Finance using the yfinance Python library.

Optimize Entity Framework Core queries by fixing N+1 problems, choosing correct tracking modes, using compiled queries, and avoiding common performance traps. Use when EF Core queries are slow, generating excessive SQL, or causing high database load.

Persistence layer patterns for Spring Data JPA repositories, entities, queries, and advanced features. \n \n Create repository interfaces extending JpaRepository with derived queries, custom @Query methods, and automatic CRUD operations \n Configure entity relationships (one-to-one, one-to-many, many-to-many) with appropriate cascade types and fetch strategies \n Implement pagination, sorting, database auditing with timestamps and user tracking, and transaction management \n Optimize performance

Dataset exploration, cleaning, statistical analysis, and visualization in Python or SQL. \n \n Supports CSV, JSON, and SQL data sources with pandas DataFrames and direct database queries \n Covers the full analysis pipeline: data loading, missing value handling, outlier detection, grouping, correlation analysis, and pivot tables \n Includes visualization templates for histograms, boxplots, heatmaps, and time series using matplotlib and seaborn \n Generates structured markdown reports with datase

Chart selection guidance, Python code patterns, and design principles for effective data visualizations. \n \n Comprehensive chart selection table covering 13+ chart types with guidance on when to use each and common anti-patterns to avoid (pie charts, 3D, dual-axis) \n Ready-to-use Python code examples for line charts, bar charts, histograms, heatmaps, small multiples, and interactive Plotly visualizations with professional styling \n Design principles covering color theory (sequential, divergi

Automatically analyzes CSV files and generates comprehensive statistics with intelligent, context-aware visualizations. \n \n Intelligently adapts analysis to data type (sales, customer, financial, operational, survey) by inspecting columns first, then runs relevant analyses without asking \n Generates only applicable visualizations: time-series plots for date columns, correlation heatmaps for multiple numeric columns, distributions for categorical data \n Provides complete output in one respons

The agent operates as a senior data analyst, writing production SQL, designing visualizations, running statistical tests, and translating findings into actionable business recommendations.

Which file? Server-only (DB/secrets): +page.server.ts | Universal (runs both): +page.ts | API: +server.ts

Transform raw data into compelling narratives that drive decisions and inspire action.