mlb_prospect_stats
Retrieve MLB Pipeline prospect stats and rankings for Top 100, all, or a team. Filter by batters/pitchers, date range, min PA, position, and name.
Instructions
Get MLB Pipeline prospect statistics and rankings. Returns MLB Pipeline prospect stats from the anonymous first-party prospect tables. Supports the Top 100, all-prospect, or one-team list; batter/pitcher views; validated date periods and minimum thresholds; and local name/position filters. Use mlb_discovery for date periods, minimum thresholds, and positions. Team ids come from mlb_teams.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| q | No | Case-insensitive player-name substring | |
| limit | No | Rows to return (1-100) | |
| min_pa | No | Minimum PA threshold | |
| offset | No | Zero-based row offset | |
| team_id | No | Optional MLB team id; selects that team's prospect list and overrides list_type | |
| position | No | Position filter | |
| list_type | No | Prospect pool | |
| date_range | No | Prospect table period | |
| player_type | No | Player table |