fraud-investigation-data-consolidator
Investigates a suspicious transaction by gathering all related data from a BigQuery analytics dataset, consolidating it into a structured JSON format, and triggering alert workflows.
npx skills add majiayu000/claude-skill-registry --skill fraud-investigation-data-consolidator --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Instructions Execute the following steps to investigate a suspicious transaction. The primary goal is to create a comprehensive data snapshot for a given `transaction_id` and trigger the required alerting and archiving workflows. ## 1. Initial Setup & Discovery * **Input:** You will be given a specific `transaction_id` (e.g., `T8492XJ3`). * **First, confirm the target dataset and storage buckets exist.** * Use `google-cloud-bigquery_get_dataset_info` to verify the `transactions_analytics` dataset is accessible. * Use `google-cloud-storage_list_buckets` to locate the archive bucket (name prefixed by `mcp-fraud-investigation-archive-`) and the log bucket (name prefixed by `Trading_Logging-`). Note their exact names. ## 2. Schema Exploration & Data Querying * **Discover all tables** in the `transactions_analytics` dataset using `google-cloud-bigquery_run_query` on the `INFORMATION_SCHEMA.TABLES` view. * **For the target transaction, query data from two primary sources:** 1. `live_transactions` table: Get the full record for the given `transaction_id`. This record contains key foreign IDs (`user_id`, `account_id`, `merchant_id`, `card_id`, `device_id`, `location_id`). 2. `fraud_alert
- 1. Initial Setup & Discovery
- 2. Schema Exploration & Data Querying
- 3. Data Consolidation & JSON Creation
- 4. Archiving & Alerting
- Key Considerations
What does the fraud-investigation-data-consolidator skill do?
Investigates a suspicious transaction by gathering all related data from a BigQuery analytics dataset, consolidating it into a structured JSON format, and triggering alert workflows.
How do I install it?
Run `npx skills add majiayu000/claude-skill-registry --skill fraud-investigation-data-consolidator --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From majiayu000/claude-skill-registry, a repository with 534 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.