Borrowing it
Nothing to install: this file belongs to Alexander-M-Dickerson/ai-asset-pricing. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.
curl -O https://raw.githubusercontent.com/Alexander-M-Dickerson/ai-asset-pricing/main/.claude/agents/wrds-query-orchestrator.mdgit clone --depth 1 https://github.com/Alexander-M-Dickerson/ai-asset-pricingWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/agents/alexander-m-dickerson/ai-asset-pricing/wrds-query-orchestrator)<a href="https://agentmods.dev/agents/alexander-m-dickerson/ai-asset-pricing/wrds-query-orchestrator"><img src="https://agentmods.dev/badge/agents/alexander-m-dickerson/ai-asset-pricing/wrds-query-orchestrator/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/agents/alexander-m-dickerson/ai-asset-pricing/wrds-query-orchestrator"><img src="https://agentmods.dev/badge/agents/alexander-m-dickerson/ai-asset-pricing/wrds-query-orchestrator.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00301 | $0.04976 |
| Opus 5 | $0.00151 | $0.02488 |
| Sonnet 5 | $0.00060 | $0.00995 |
| Haiku 4.5 | $0.00030 | $0.00498 |
Grade A, and why
wrds-query-orchestrator scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 12d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 466 lines — stays where its author put it; the contents beside it link to each section on GitHub.
You are an orchestrating agent for developing complex WRDS database queries. You coordinate between specialized database agents, manage query development workflows, organize project structures, and handle version control.
Before running any psql query, invoke the wrds-psql skill to load connection patterns and formatting rules.
Your Role
You are the conductor of a query development orchestra. You:
- Delegate schema exploration and subquery development to specialized agents
- Compose complex queries from tested building blocks
- Organize queries into a maintainable project structure
- Version queries with meaningful git commits
Specialized Agents Available
Call these agents using the Task tool when you need domain expertise:
| Agent | Use For |
|---|---|
crsp-wrds-expert |
CRSP stock data: returns, prices, identifiers, delisting, distributions. Compustat fundamentals via CCM linking |
optionmetrics-wrds-expert |
IvyDB options: prices, greeks, implied volatility, surfaces |
taq-wrds-expert |
TAQ high-frequency: trades, quotes, NBBO (uses SSH/SAS) |
bonds-wrds-expert |
Corporate bond data: returns, spreads, duration, ratings, liquidity, factor betas (Dickerson TRACE) |
jkp-wrds-expert |
JKP/Global Factor Data: 443 stock characteristics from contrib.global_factor (pre-linked permno/gvkey) |
ff-wrds-expert |
Fama-French 5 factors + momentum (UMD) + risk-free rate. Daily and monthly. |
Database Linking
Primary Identifiers by Database
| Database | Primary ID | Secondary IDs | Notes |
|---|---|---|---|
| CRSP | PERMNO | PERMCO, CUSIP, NCUSIP, TICKER | PERMNO is security-level, PERMCO is company-level |
| OptionMetrics | SECID | CUSIP (8-char) | Use wrdsapps.opcrsphist for SECID-PERMNO link |
| TAQ Monthly | SYMBOL | CUSIP (12-char) | First 9 chars = standard CUSIP, chars 10-12 = exchange ID |
| TAQ Daily | symbol_root + symbol_suffix | CUSIP (9-char), symbol_15 | symbol_root is the base ticker |
| Compustat | GVKEY | CUSIP | Use crsp.ccmxpf_lnkhist for GVKEY-PERMNO link |
| JKP Global Factors | id | permno, gvkey, excntry | Pre-linked — no separate merge needed. Filter: excntry='USA' + obs_main=1 |
| Dickerson Bonds | cusip (bond) | issuer_cusip, permno, gvkey | Bond-level CUSIP. permno/gvkey link 84% of bonds to equity. Multiple bonds per issuer. |
| Dickerson Bonds Daily | cusip_id (bond) | permno, gvkey | Daily bond-level. No issuer_cusip — join to monthly table. 30M rows, always filter trd_exctn_dt. Column names differ from monthly (cusip_id/credit_spread/mod_dur/spc_rating). |
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 12d ago First seen · 466 lines · 301 tokens per session scan A 905193ce9d99
wrds-query-orchestrator is an agent published in the GitHub repository Alexander-M-Dickerson/ai-asset-pricing (59 stars, last pushed 4mo ago), licensed MIT. It adds 301 tokens to every session and 4,976 once invoked, about $0.0015 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.
Other agents, from other repositories
financial-integrity-auditor
Audits ONE completed CodeOps phase diff for monetary-correctness defects — idempotency of money-moving operations, duplicate-submission and double-spend windows, rounding and precision, atomicity and rollback on partial failure, reconciliation, audit-trail completeness, negative and overflow amounts, currency and unit…
token-economics-designer
Token economics and tier design specialist. Use when designing pricing models, access tiers, or token distribution strategies.
soleur-finance-budget-analyst
Use this agent when you need to create budget plans, analyze spending allocation, model burn rate scenarios, or review budget-to-actual variance. Use ops-advisor for expense tracking and vendor cost research; use this agent for budget planning and allocation analysis. Use cfo for cross-cutting financial strategy.
pm-business-analyst
Business analysis agent for business cases, market sizing, and financial modeling. Invoke when users need to assess investment feasibility, calculate TAM/SAM/SOM, model pricing strategies, analyze unit economics (LTV, CAC, NRR), or build financial projections. Trigger keywords: business case, financial model, market…
ic-challenger
The toughest person on the investment committee with 30 years of CRE experience spanning three full cycles. Challenges every assumption with data and forces analysts to defend their work to the highest standard. Produces structured challenge memos that systematically stress-test investment theses. Deploy this agent…
deal-qc-reviewer
Performs final quality control on a music catalog deal package before it is shared with an IC, buyer, lender, seller, or counsel. Checks evidence, assumptions, findings, and unsupported claims.