CJ

    CSV Join Cardinality Check

    1

    Find duplicate keys, missing matches and row inflation before joining tables. Report exact counts and safe fixes for the requested join.

    $1

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more
    CJ

    CSV Join Cardinality Check

    Example session with this skill installed

    Can I safely left-join an orders table with keys [a,a,b,c] to a customer table with keys [a,a,b]?

    • Read your context and instructions
    • Compiled the csv join cardinality

    Illustrative output

    The input is many-to-many on a. The SQL-style left join returns 6 rows: a contributes 4, b contributes 1, c contributes 1 unmatched. Customer records need a unique key, a documented deduplication rule, or a valid secondary join key before treating the result as one row per order.

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

    About this skill

    Ask for or infer the intended join type, key columns, expected grain and null semantics from the spec. Profile each side before joining. Inspect encoding, key type, blank strings, whitespace and leading zeros. Review any proposed normalization with collision counts before treating changed keys as equal. Preserve case sensitivity unless domain rules specify otherwise.

    Count rows, distinct valid keys, nulls, duplicate groups and unmatched keys per side. For an inner join compute expected contribution as left_count(key) times right_count(key). For a left join use left_count(key) times max(1,right_count(key)) for valid keys and evaluate nulls under the selected engine's semantics. Check many-to-many examples, multiplicity and post-join grain. Treat composite keys as tuples.

    Report exact expected row count with assumptions, a key-level audit of the largest inflation drivers, and corrections supported by domain rules. If performing the join, use a separate output requested by the user and recheck actual versus expected counts. Never silently keep the first duplicate.

    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

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed today

    Permissions

    No special permissions declared or detected

    Listedtoday

    What's inside

    Frequently Asked Questions

    Find duplicate keys, missing matches and row inflation before joining tables. Report exact counts and safe fixes for the requested join.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use CSV Join Cardinality Check on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.