Works with the AI tools you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+22 more

    CSV Data Profiler

    1

    Profile CSV/JSONL files for data quality, PII, and statistics while generating SQL schemas and HTML reports.

    $9.99

    Secure checkout via Stripe

    30-day refund guarantee

    Converts to your local currency at checkout

    Security scanned
    CSV Data Profiler

    CSV Data Profiler

    Example session with this skill installed

    Profile this user_exports.csv file, check for PII, and give me a Postgres CREATE TABLE statement for it.

    • Read your context and instructions
    • Compiled the csv data profiler
    • Generated the data export

    I have analyzed user_exports.csv using the data profiler. The file uses UTF-8 encoding and a comma delimiter. I detected 3,450 rows and identified several columns containing PII that should be masked or encrypted.

    Data Profile Summary

    ColumnInferred TypeNullsDistinctNotes
    user_idUUID03,450Candidate Primary Key
    emailEmail03,448PII Detected, 2 duplicates
    signup_dateDatetime122,890Format: YYYY-MM-DD HH:MM:SS
    account_balanceFloat01,240Mean: 450.25, Max: 12500.00
    phone_extInteger45012Contains leading zeros

    Postgres Schema

    CREATE TABLE user_exports (
    user_id UUID PRIMARY KEY,
    email VARCHAR(255) NOT NULL,
    signup_date TIMESTAMP,
    account_balance NUMERIC(12, 2),
    phone_ext INTEGER
);

-- Index suggested for frequent lookups
CREATE INDEX idx_user_email ON user_exports(email);

    Next steps

    1. Review the 2 duplicate entries in the email column to prevent unique constraint violations.
    2. Verify if the phone_ext null values are expected or indicate an extraction error.
    3. Apply the generated SQL to your staging environment to validate against your migration script.

    user_exports.csv

    CSV · data export

    Generated

    Example file from a real run - the skill writes it into your workspace.

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

    About this skill

    Data integration often fails because you don't know what is actually inside the file. This skill profiles CSV, TSV, and JSON Lines files to catch data quality issues and schema mismatches before you start building.

    What it does

    • Format detection automatically identifies delimiters, encodings, and headers without manual configuration.
    • Deep type inference identifies integers, floats, booleans, dates, UUIDs, emails, and URLs.
    • Statistical analysis calculates min, max, mean, median, standard deviation, and percentiles for numeric data.
    • Data quality auditing flags nulls, blanks, leading/trailing whitespace, and suspicious sentinel values like -999.
    • Schema generation exports CREATE TABLE statements for SQL or JSON Schema files based on the analyzed data.

    How it works

    1. Initial Scan: The tool probes the file to determine the structure and encoding.
    2. Profiling: It streams the data, using reservoir sampling for large files to keep statistics accurate while managing memory.
    3. Detection: It checks for PII, duplicate rows, and potential primary keys.
    4. Output Generation: You receive a summary report, SQL schema, or HTML visualization depending on the flags used.

    Frameworks & tools

    This tool uses a custom Python streaming processor. It operates without a pandas dependency to ensure it works in lightweight environments and handles large files via memory-efficient streaming.

    Why this beats prompting it yourself

    Generic LLMs often hallucinate data distributions or fail on large files due to context limits. This skill uses deterministic streaming logic to provide precise statistics and valid SQL schemas that you can actually run.

    Use cases

    • Pre-migration audits to find dirty data before loading a CSV into a production database.
    • Schema bootstrapping to generate DDL for a new Postgres or Snowflake table from a flat file.
    • PII discovery to identify sensitive fields like emails or card numbers that need masking.

    Known limitations

    Does not support Excel (.xlsx) files. SQL dialect support is focused on Postgres and standard SQL. Large file processing requires local Python execution.

    How to use

    Skills on Agensi run inside your AI agent. Copy the prompt, paste it into your agent, and it connects to Agensi and installs this skill for you. If a payment is needed, your agent shows it to you first.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill passes our trust checks below.

    Security scanned

    Passed our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    30-day refund

    Not a fit? Get your money back

    Trust & safety

    Security scanned

    Verified clean today

    • Passed all security checks, Safe to install

    Needs access to

    Json Schema

    Listedtoday

    What's inside

    Frequently Asked Questions