dsp-multi-asset-importer

Name: dsp-multi-asset-importer
Availability: InStock
Author: Mosaic-agent

Backfill and validate historical DSP Multi Asset holdings into market_data.mf_holdings.

36|7|Updated Feb 22, 2026

Search Tags:#validation #dsp #backfill #holdings #import #clickhouse #finance-data

Ready to run

npx skills add https://github.com/Mosaic-agent/Mosaic-fund-agent --skill dsp-multi-asset-importer

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dsp-multi-asset-importer
Source: https://github.com/Mosaic-agent/Mosaic-fund-agent/tree/main/.gravity/skills/dsp-multi-asset-importer
Command: npx skills add https://github.com/Mosaic-agent/Mosaic-fund-agent --skill dsp-multi-asset-importer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Historically, DSP Multi Asset allocations required manual backfills and validation to populate market_data.mf_holdings. This skill automates the 31-month historical backfill (Sep 2023 – Mar 2026) for the DSP fund and provides checks to ensure month coverage and data integrity.

Core Features & Use Cases

31-month historical backfill for market_data.mf_holdings with fund_code DSP_MULTI_ASSET
Month-by-month validation and coverage checks to identify missing or inconsistent months
Re-import workflows for specific months and dry-run validation before writes
Quick audit queries to inspect latest holdings, top allocations, and asset mix

Quick Start

Run the DSP backfill for all 31 months and verify month coverage

Frequently Asked Questions about dsp-multi-asset-importer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I backfill historical DSP Multi Asset holdings into ClickHouse?▼

To backfill historical DSP Multi Asset holdings into ClickHouse, run the import_dsp_history.py script, which automates the 31-month historical data population and validation for the market_data.mf_holdings table. It handles fund_code DSP_MULTI_ASSET coverage from Sep 2023 through Mar 2026.

What is the best way to validate month coverage for DSP fund holdings in ClickHouse?▼

Validating month coverage for DSP fund holdings in ClickHouse is handled by built-in validation checks within the backfill script. These checks identify missing or inconsistent months in the market_data.mf_holdings table to ensure complete historical data integrity for the DSP_MULTI_ASSET fund.

Can I re-import specific months of DSP holdings data without overwriting the entire dataset?▼

Yes, you can re-import specific months of DSP holdings data without a full overwrite. The script supports targeted re-import workflows and dry-run validation, allowing you to verify data for individual months before performing write operations to the ClickHouse database.

Do I need a specific database setup to import DSP history into market_data.mf_holdings?▼

Yes, importing DSP history into market_data.mf_holdings requires read and write access to a ClickHouse database. You also need the import_dsp_history.py script to execute the backfill, re-import, and verification workflows for the fund allocations.

How do I audit asset allocations and top holdings for the DSP Multi Asset fund?▼

Auditing asset allocations and top holdings for the DSP Multi Asset fund is done using quick audit queries provided by the skill. These queries inspect the latest holdings data in ClickHouse to review the asset mix and verify the fund's current allocation distribution.