Skills

Analyzes datasets to extract insights, identify patterns, and generate visualizations. Supports exploratory data analysis (EDA), statistical testing, trend detection, and report generation. Works with CSV, JSON, and database outputs.

Generates optimized SQL queries from natural language descriptions. Supports multiple dialects (PostgreSQL, MySQL, SQLite, SQL Server), handles complex joins, subqueries, window functions, and CTEs. Includes query explanation and performance optimization hints.

Designs normalized database schemas from business requirements. Covers entity relationships, indexing strategies, migration planning, and performance considerations. Supports PostgreSQL, MySQL, MongoDB, and other databases with dialect-specific optimizations.