MCP server for the Green Longhorn family office. Provides tools for querying grant transaction data from Beloved In Christ Foundation (BiC), a Green Longhorn subsidiary, and Green Longhorn flight planning/analysis capabilities.
MCP endpoint: /{guid}/mcp
Requires MCP_GUID environment variable
Check endpoint status →(Shows your configured endpoint URL)
Web UI coming soon. For now, use ChatGPT Desktop or Cursor to interact with the MCP server.
list_transactionsSearch and filter grant transactions with advanced filtering, sorting, and grouping options.
Filters: search_term, charity, year, min_year, max_year, min_amount, max_amount, category, grant_status, is_beloved
Options: sort_by, sort_order, group_by, fields
list_granteesList all unique grantees (charities) with summary data including name, EIN, most recent grant note, transaction count, and total amount.
Filters: search_term, year, category, is_beloved
Sort: name, ein, recent_date, total_amount (asc/desc)
Use for: Top grantees queries, largest recipients, grantee rankings
show_granteeShow detailed information about a specific grantee including metadata and all transaction history.
Required: charity (exact name)
Optional: ein (to disambiguate)
Returns: Metadata, yearly totals, status breakdown, all transactions
aggregate_transactionsAggregate grant transactions by category, grantee, year, international status, is_beloved, or status. Returns summary statistics (count and total_amount) for each group.
Required: group_by (category, grantee, year, international, is_beloved, or status)
Filters: year, min_year, max_year, min_amount, max_amount, category, charity, is_beloved
Use for: Category breakdowns, yearly totals, top grantees by amount, status breakdowns
get_flightsSearch and filter flight records with optional filters. Returns both individual flight records and summary statistics (totals, averages, counts). Use this as the primary query tool for flight-related questions.
Filters: departure_airport, arrival_airport, aircraft_requested, aircraft_actual, contract, min_date, max_date, year, month, min_cost, max_cost, min_hours, max_hours, min_passengers, max_passengers, passenger_name, is_bic
Sort: Date, Total Cost, Hours Flown, Passengers (asc/desc)
Returns: Individual flights + summary statistics
list_aircraftList all unique aircraft types (both requested and actual) with flight counts. Use this to discover available aircraft types for filtering in get_flights.
list_airport_codesList all unique airport codes (departure and arrival) with flight counts. Use this to discover airport codes for filtering in get_flights (e.g., find "MMSD" for Cabo).
list_passengersList all unique passengers with flight counts. Use this to discover passenger names for filtering in get_flights.
estimate_routeEstimate flight distance and time between any two airports using ICAO codes. Uses great circle distance calculations with routing adjustments for international flights.
Required: departure_airport, arrival_airport (ICAO codes)
Optional: aircraft_type (small, mid, large)
Use for: Estimating potential flight scenarios even when no actual flight data exists
set_flight_bic_flagSet or unset the BiC (Beloved In Christ Foundation, a Green Longhorn subsidiary) activity flag for a specific flight with an activity description. Flights flagged as BiC are related to BiC foundation activity (visiting grantees or doing foundation work).
Required: flight_id (e.g., "19795780-1")
Optional: activity_description (if provided, flags as BiC activity; if omitted, removes flag)
Note: This is a write operation (not read-only)