Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    askmydata- AI Data Analyst

    1

    Turn raw CSV, JSON, and Excel files into a local SQL-queryable database for instant analysis and reporting.

    Free

    Security scanned
    askmydata- AI Data Analyst

    askmydata- AI Data Analyst

    Example session with this skill installed

    I've uploaded sales_report.csv. Analyse the sales performance, show total revenue by region, identify the top-performing products, compare monthly trends and highlight any significant drops in sales.

    • Read your context and instructions
    • Compiled the askmydata- ai data

    Sales Performance Analysis

    The dataset was prepared and cleaned successfully. The analysis below is based on the uploaded sales data.

    1. Overall Sales Summary

    MetricResult
    Total RevenueCalculated from dataset
    Total TransactionsCalculated from dataset
    Average Order ValueCalculated from dataset

    2. Revenue by Region

    RegionTotal Revenue
    SouthCalculated from dataset
    NorthCalculated from dataset
    EastCalculated from dataset
    WestCalculated from dataset

    3. Top Performing Products

    Identify the five products with the highest revenue.

    4. Monthly Sales Trends

    Compare revenue across months and identify growth or decline.

    5. Business Insights

    Highlight significant sales changes and potential areas for improvement.

    All results are calculated from the uploaded dataset. Recommendations are suggestions based on the available data.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Raw data files are often too messy or structured incorrectly for immediate analysis. Manual cleaning in Excel or writing custom Python scripts for every new CSV, JSON, or Parquet file is time-consuming and error-prone. This skill automates the ingestion, cleaning, and querying of local data files using SQL. What it does Automated Data Cleaning flattens nested JSON, standardizes column names, removes duplicates, and handles null values. Type Conversion transforms currency strings and text-based dates into queryable numeric and datetime formats. SQL-Powered Analysis executes DuckDB queries against your local files to generate precise answers. Trend and Comparison Analysis calculates month-over-month changes, growth percentages, and identifying outliers or significant drops.

    • Natural Language to Table converts vague business questions into structured Markdown tables and plain-English summaries. How it works
    1. Prepare the data using a CLI command to ingest and clean the file, creating a local workspace.
    2. Inspect the schema to understand available columns and data types generated during preparation.
    3. Query the data using DuckDB SQL via the CLI to extract specific insights or respond to user questions.
    4. Iterate on queries automatically if errors occur or if filters return empty results by relaxing constraints or matching case-insensitively. Frameworks & tools This skill uses Python, Pandas for data manipulation, DuckDB for high-performance SQL querying, and PyArrow for Parquet support. Why this beats prompting it yourself Generic prompts often fail at complex data types, currency formatting, or large file contexts. This skill uses a specialized CLI to pre-process data into a structured DuckDB instance, ensuring the AI works with a clean schema and real SQL execution rather than hallucinating calculations. Use cases Sales Performance identifying top-selling products, regional revenue trends, and growth drops. Customer Analysis segmenting users by activity or calculating lifetime value from raw logs. Inventory Audits finding low-stock items or discrepancies across multiple product categories. Data Exploration quickly understanding the contents and quality of a new, unknown JSON or CSV dataset.

    Known limitations Requires local installation of pandas, duckdb, pyarrow, and openpyxl. Only SELECT/WITH SQL queries are supported. Operations are limited to the first sheet of Excel files.

    DEVELOPED BY Prathima S and Masani Varun Jointly developed as an independent project

    Requires local installation of pandas, duckdb, pyarrow, and openpyxl. Supports only SELECT/WITH queries. Excel support is limited to the first sheet.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    • Free with an Agensi account

    Requires

    Python

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Listed2 days ago

    What's inside

    Frequently Asked Questions

    The skill supports CSV, JSON, Parquet, and Excel (.xlsx) files. It automatically handles the heavy lifting of flattening nested JSON and converting messy text-based dates or currency strings into queryable formats.

    Unlike basic prompts that rely on the AI's internal math, this skill creates a local DuckDB instance. This ensures calculations are performed by a high-performance SQL engine, preventing the "hallucinated" numbers often seen with raw file uploads.

    This skill is designed for AI agents with CLI access and requires a local Python environment. You will need to have pandas, duckdb, pyarrow, and openpyxl installed on your system for the skill to process data.

    The skill currently supports all SELECT and WITH SQL statements for data retrieval and analysis. Please note that it does not support data modification commands like UPDATE or DELETE, and it defaults to the first sheet when processing Excel files.

    You receive the complete skill package, including the CLI integration tools and the logic for automated data cleaning and schema inspection. This allows your agent to immediately start transforming raw files into structured, queryable databases.

    New in Data & Databases