wrds-schema

Pre-loads WRDS schema knowledge for CRSP, OptionMetrics, Compustat, and TAQ.

58|10|Updated Apr 2, 2026
One-click install
npx skills add https://github.com/Alexander-M-Dickerson/ai-asset-pricing --skill wrds-schema
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: wrds-schema
Source: https://github.com/Alexander-M-Dickerson/ai-asset-pricing/tree/main/.claude/skills/wrds-schema
Command: npx skills add https://github.com/Alexander-M-Dickerson/ai-asset-pricing --skill wrds-schema

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Pre-load WRDS schema knowledge (table names, column names, join keys, data types, and common gotchas) so you can write correct queries without exploratory round-trips.

Core Features & Use Cases

  • Pre-loads schema knowledge for CRSP, OptionMetrics, Compustat, TAQ, and global factor schemas at session start.
  • Provides a concise per-database schema reference for quick, reliable query construction.
  • Reduces exploratory round-trips and prevents common gotchas when joining WRDS tables across databases.

Quick Start

Invoke this skill at session start to load WRDS schemas in parallel and obtain a concise schema reference for query construction.

Frequently Asked Questions about wrds-schema

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

FAQPage Schema
How do I find the correct table and column names for WRDS Compustat and CRSP queries?

To find correct WRDS schema details, you need a reference for table names, column names, join keys, and data types. Pre-loading this schema knowledge for CRSP and Compustat prevents incorrect SQL and eliminates exploratory round-trips.

What is the best way to avoid common gotchas when joining WRDS tables across databases?

To avoid common gotchas when joining WRDS tables across databases, use a pre-loaded schema reference. It identifies table names, column names, join keys, data types, and common pitfalls to ensure correct SQL query construction.

Does this approach support schema discovery for OptionMetrics and TAQ databases?

Yes, schema discovery supports OptionMetrics and TAQ databases. It dispatches parallel specialist agents to pre-load schema knowledge, providing a concise reference for quick and correct query construction across these specific databases.

How do I load WRDS schemas at session start for fast SQL development?

To load WRDS schemas for fast SQL development, invoke the schema pre-loader at session start. It dispatches parallel specialist agents to identify schemas and provides a concise reference for immediate and correct query construction.

Why does my WRDS SQL query keep failing due to incorrect data types or join keys?

Your WRDS SQL query fails due to incorrect data types or join keys because the schema is not pre-loaded. Identifying table names, column names, join keys, and data types beforehand prevents these common gotchas and ensures correct query development.