What is Ramp Mcp

ramp_mcp is a Model Context Protocol server designed for retrieving and analyzing data or executing tasks for Ramp using the Developer API. It features an ETL pipeline and an ephemeral SQLite database for efficient data processing.

Use cases

Use cases for ramp_mcp include analyzing financial transactions, managing reimbursements, querying various data categories, and integrating with other applications for enhanced data handling.

How to use

To use ramp_mcp, set up your Ramp client with the necessary scopes and start the server with CLI arguments. You can utilize various tools for data processing, fetching, and loading based on your requirements.

Key features

Key features of ramp_mcp include an in-memory SQLite database, a simple ETL pipeline, tools for data processing and querying, and the ability to fetch and load data directly to the server.

Where to use

ramp_mcp can be used in fields such as data analysis, financial reporting, and application development where efficient data retrieval and processing are required.

ramp-mcp: A Ramp MCP server

Overview

A Model Context Protocol server for retrieving and analyzing data or running tasks for Ramp using Developer API. In order to get around token and input size limitations, this server implements a simple ETL pipeline + ephemeral sqlite database in memory for analysis by an LLM. All requests are made to demo by default, but can be changed by setting RAMP_ENV=prd. Large datasets may not be processable due to API and/or your MCP client limitations.

Tools

Database tools

Tools that can be used to setup, process, query, and delete an ephemeral database in memory.

1. process_data
2. execute_query
3. clear_table

Fetch tools

Tools that can be used to fetch data directly

1. get_ramp_categories
2. get_currencies

Load tools

Loads data to server which the client can fetch. Based on the tools you wish to use, ensure to enable those scopes on your
Ramp client and include the scopes when starting the server as a CLI argument.

Tool	Scope
load_transactions	transactions:read
load_reimbursements	reimbursements:read
load_bills	bills:read
load_locations	locations:read
load_departments	departments:read
load_bank_accounts	bank_accounts:read
load_vendors	vendors:read
load_vendor_bank_accounts	vendors:read
load_entities	entities:read
load_spend_limits	limits:read
load_spend_programs	spend_programs:read
load_users	users:read

For large datasets, it is recommended to explicitly prompt Claude not to use REPL and to keep responses concise to avoid timeout or excessive token usage.

Setup

Ramp Setup

1. Create a new client from the Ramp developer page (Profile on top right > Developer > Create app)
2. Grant the scopes you wish (based on tools) to the client and enable client credentials (Click on App > Grant Types / Scopes)
3. Include the client ID and secret in the config file as well as the scopes you wish to use

Local Setup

1. Clone this Github repo via git clone [email protected]:ramp/ramp-mcp.git or equivalent
2. Install uv

Usage

Run the MCP server from your CLI with:

RAMP_CLIENT_ID=... RAMP_CLIENT_SECRET=... RAMP_ENV=<demo|prd> uv run ramp-mcp -s <COMMA-SEPARATED-SCOPES>

Configuration

Usage with Claude Desktop

Add this to your claude_desktop_config.json:

If this file doesn’t exist yet, create one in /<ABSOLUTE-PATH-TO>/Library/Application Support/Claude/

License

Copyright © 2025, Ramp Business Corporation
All rights reserved.
This source code is licensed under the MIT License found in the LICENSE file in the root directory of this source tree.