Skip to main content
Glama

WRDS Research for Claude

Ask Claude in plain English whether data exists on WRDS, and have it pull it for you.

"Do we have P&L data for European companies 2004–2022 by country and industry? If so, export it."

Claude searches the WRDS catalog, tells you what's available (source, firms, years, countries), then queries or exports the data — with the WRDS AI policy enforced.

Not affiliated with WRDS or the Wharton School. You need your own WRDS account; you only see the libraries your institution subscribes to.

Before you start: the WRDS AI policy

  • Row-level data may only be sent to a protected AI tool (vendor contractually doesn't train on it). Check that your Claude plan qualifies (Team / Enterprise / API usually do; ask your WRDS representative if unsure).

  • Only these sources are AI-allowed: CRSP, S&P (Compustat, Capital IQ), LSEG (Worldscope, Datastream, I/B/E/S), MSCI, Audit Analytics, Revelio, WRDS-created data.

  • For every other library the server returns metadata and counts only; exports are saved to disk without a preview.

Related MCP server: Compass MCP Server

Install

Requires uv (brew install uv on macOS, or see the uv docs).

1. Save your WRDS login (once, in a terminal — the password is typed there, never into Claude):

uvx --from git+https://github.com/hosseinzk/wrds-mcp wrds-mcp-setup

It asks for your WRDS username and password, tests the connection (approve the Duo push if one arrives) and saves them to ~/.pgpass (Windows: %APPDATA%\postgresql\pgpass.conf).

2a. Claude Code — install the plugin (MCP server + a research skill):

/plugin marketplace add hosseinzk/wrds-mcp
/plugin install wrds@wrds-tools

Restart Claude Code, then ask "Which WRDS databases do I have access to?"

2b. Claude Desktop / other MCP clients — install the server and add it to your MCP config (Claude Desktop: Settings → Developer → Edit config):

uv tool install git+https://github.com/hosseinzk/wrds-mcp
{ "mcpServers": { "wrds": { "command": "wrds-mcp" } } }

Exports and the query log go to ~/wrds-data (set WRDS_OUTPUT_DIR to change it).

Tools

Tool

What it does

list_libraries

Libraries your account can access, vendor, AI-allowed flag, sample/trial flag

search_catalog

Search table/column names and descriptions across all libraries

list_tables, describe_table

Tables, approximate row counts, columns and descriptions

check_availability

Single-row counts / year ranges on any library (numbers only for non-AI-allowed ones)

query

Read-only SELECT, up to 500 rows, AI-allowed sources only

export_query

Full result to CSV / Parquet / Excel in your output folder

Every query is logged to <output folder>/logs/queries.log. Connections are read-only.

Examples

  • "Which databases do I have access to? Which are full and which are just samples?"

  • "Is quarterly R&D spending available for Tesla 2015–2024?"

  • "Export annual revenue, EBIT and net income for all German and French listed firms 2010–2022, with GICS sector."

  • "Median EBITDA margin by country and GICS sector for Europe, 2004–2022, in EUR."

Available Tools

7 tools
check_availabilityA

Run an aggregate-only availability check (counts, distinct counts, min/max years) on any accessible library, including ones where row-level data is not AI-allowed. The query must return a single summary row, e.g. SELECT count(*), count(distinct gvkey), min(fyear), max(fyear) FROM comp.g_funda WHERE ...

Inputs: sql (required). Returns: result

describe_tableB

Show columns, types and WRDS column descriptions (where available) for a table.

Inputs: table (required), library (required). Returns: result

export_queryA

Run a read-only SELECT with no row limit and save it to the output folder (default ~/wrds-data). fmt: csv, parquet or xlsx. Returns the path, row count and columns; a 5-row preview is included only for AI-allowed sources.

Inputs: sql (required), filename (required), fmt. Returns: result

list_librariesA

List WRDS libraries this account can access, with the vendor and whether data rows may be returned to the AI under the WRDS AI policy. Optional substring filter.

Inputs: contains. Returns: result

list_tablesB

List tables in a WRDS library with approximate row counts.

Inputs: library (required). Returns: result

queryA

Run a read-only SELECT and return up to limit rows (max 500) as CSV. Only allowed when every referenced library is AI-allowed under the WRDS policy.

Inputs: sql (required), limit. Returns: result

search_catalogB

Search table names, column names and column descriptions across all accessible libraries for a keyword (e.g. 'revenue', 'nace', 'sic', 'orbis'). Use this first to answer 'is X available?' questions.

Inputs: keyword (required), max_results, library_contains. Returns: result

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.7/5.0

    Scored across 7 tools

    Disambiguation5/5

    The tools are clearly divided into metadata discovery (list_libraries, list_tables, describe_table, search_catalog) and data access (check_availability, query, export_query). Within each group, purposes are distinct, with check_availability explicitly aggregate-only and query/export_query differentiated by output destination and row limits. No two tools appear to do the same thing.

    Naming Consistency4/5

    All tool names use snake_case, and most follow a verb_noun pattern (e.g., list_libraries, describe_table, export_query). The tool 'query' is a lone verb without a noun, a minor deviation from the otherwise consistent pattern.

    Tool Count5/5

    Seven tools is well-scoped for a read-only data access server, covering discovery and retrieval without bloat. Each tool earns its place and none feel redundant.

    Completeness5/5

    The set covers the full read-only data lifecycle: discovering libraries, tables, and columns; searching across catalogs; checking availability under AI policy; and running bounded or unbounded queries. No obvious gaps exist for the stated domain.

    Maintenance

    ActivitySlowing
    ResponsivenessOutdated data

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides database access capabilities to Claude with support for both SQLite and SQL Server databases. It enables users to manage schemas, execute SQL queries, and export results through natural language interaction.
      782 npm
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      Enables Claude to run SQL queries against Infor Compass (Data Fabric) directly from chat, with automatic export of large result sets to Excel.
      2
      MIT
    • F
      license
      Not graded
      quality
      D
      maintenance
      Enables safe, read-only interaction with Google BigQuery through Claude, with layered guardrails preventing dangerous or expensive queries. Exposes tools for listing datasets, tables, estimating costs, and running queries.
      -
    • A
      license
      Not graded
      quality
      C
      maintenance
      Enables Claude to translate natural-language business questions into safe, read-only SQL queries by exposing tools for listing tables, inspecting schemas, and executing row-capped SELECT statements against PostgreSQL.
      MIT