datagen-securities-settlements

Generate multi-market securities settlement data with fail tracking for PostgreSQL and MongoDB.

Updated Mar 28, 2026

Search Tags:#cross-database #data-generation #synthetic-data #settlements #securities #fails

Ready to run

npx skills add https://github.com/sandalsoft/agent-skills --skill datagen-securities-settlements

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: datagen-securities-settlements
Source: https://github.com/sandalsoft/agent-skills/tree/main/datagen-securities-settlements
Command: npx skills add https://github.com/sandalsoft/agent-skills --skill datagen-securities-settlements

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2-binary, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

Generates realistic, multi-market securities settlement data focusing on settlement fails, aging, and resolution processes to support testing, analytics, and regulatory simulations.

Core Features & Use Cases

Generates PostgreSQL-ready core settlement data plus MongoDB-backed fail tracking and statistics, covering US (T+1), JP (T+2), and EU (T+2) markets.
Models 5 fail categories with aging buckets, resolution methods, and regulatory threshold tracking, plus detailed penalties.
Ensures referential integrity, realistic identifiers (CUSIP/ISIN), business-day calendars, and cross-database references for integrated analytics.

Quick Start

Run the master generator to produce PostgreSQL CSVs and MongoDB JSON fails data for all markets.

Frequently Asked Questions about datagen-securities-settlements

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

FAQPage Schema

How do I generate synthetic securities settlement data with multi-market fails for testing?▼

Generate synthetic securities settlement data with multi-market fails by running the master generator to produce PostgreSQL CSVs and MongoDB JSON fails data covering US T+1, Japan T+2, and Europe T+2 settlement cycles. It models 5 fail categories with aging buckets, resolution methods, and regulatory threshold tracking.

What is the best way to simulate securities settlement fails across different market cycles?▼

Simulate securities settlement fails across market cycles using a hybrid PostgreSQL and MongoDB architecture with an 8-core schema. This approach models US T+1, Japan T+2, and Europe T+2 cycles, ensuring referential integrity and realistic CUSIP/ISIN identifiers for comprehensive fail tracking.

Can I configure fail rates and track aging buckets when generating settlement data?▼

You can configure fail rates and track aging buckets during settlement data generation. The generator models 5 fail categories with detailed aging buckets, resolution methods, regulatory threshold tracking, and penalties to support analytics and regulatory simulations.

Does this synthetic data generation approach work with PostgreSQL and MongoDB for cross-database analytics?▼

This synthetic data generation approach works with PostgreSQL and MongoDB for cross-database analytics. It generates PostgreSQL-ready core settlement data and MongoDB-backed fail tracking statistics, maintaining cross-database references for integrated analytics and referential integrity.

Do I need to install psycopg2 to generate settlement data with this hybrid database architecture?▼

You need to install psycopg2-binary to generate settlement data with this hybrid database architecture. It is the required dependency for connecting to PostgreSQL and producing the core settlement CSVs alongside MongoDB JSON fails data.

What settlement fails data limitations should I consider for regulatory simulations?▼

Consider that settlement fails data for regulatory simulations relies on synthetic generation with configurable fail rates rather than real market data. It covers 5 fail categories and business-day calendars but requires validation against actual regulatory thresholds for production compliance testing.