Ramp MCP
What is Ramp MCP
ramp-mcp is a Model Context Protocol server designed for retrieving and analyzing data or executing tasks with Ramp using its Developer API. The server incorporates an ETL pipeline and an in-memory SQLite database to efficiently handle requests while working within token and input size constraints.
Use cases
This server can be utilized to manipulate and analyze various types of financial data, such as transactions, reimbursements, bills, and locations. It is particularly useful for integrating Ramp data into other applications or analytical processes that require real-time access to financial information.
How to use
To run the ramp-mcp server, users must set their Ramp client credentials, specify the environment (either demo or production), and define the required scopes when starting the server through the command line. Additionally, configuration for integration with Claude Desktop can be set up via a JSON configuration file.
Key features
Key features of ramp-mcp include an in-memory database for rapid data processing, tools for fetching and managing data directly from Ramp, and a user-friendly setup that includes easy-to-follow instructions on configuring both the server and integration with external applications like Claude Desktop.
Where to use
ramp-mcp can be used in development environments where quick and efficient access to financial data is needed, such as in analytics platforms, integration projects, or during financial audits. It is suited for developers and analysts looking to leverage Ramp’s capabilities for enhanced data processing and analysis.
Overview
What is Ramp MCP
ramp-mcp is a Model Context Protocol server designed for retrieving and analyzing data or executing tasks with Ramp using its Developer API. The server incorporates an ETL pipeline and an in-memory SQLite database to efficiently handle requests while working within token and input size constraints.
Use cases
This server can be utilized to manipulate and analyze various types of financial data, such as transactions, reimbursements, bills, and locations. It is particularly useful for integrating Ramp data into other applications or analytical processes that require real-time access to financial information.
How to use
To run the ramp-mcp server, users must set their Ramp client credentials, specify the environment (either demo or production), and define the required scopes when starting the server through the command line. Additionally, configuration for integration with Claude Desktop can be set up via a JSON configuration file.
Key features
Key features of ramp-mcp include an in-memory database for rapid data processing, tools for fetching and managing data directly from Ramp, and a user-friendly setup that includes easy-to-follow instructions on configuring both the server and integration with external applications like Claude Desktop.
Where to use
ramp-mcp can be used in development environments where quick and efficient access to financial data is needed, such as in analytics platforms, integration projects, or during financial audits. It is suited for developers and analysts looking to leverage Ramp’s capabilities for enhanced data processing and analysis.
Content
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.
process_dataexecute_queryclear_table
Fetch tools
Tools that can be used to fetch data directly
get_ramp_categoriesget_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
- Create a new client from the Ramp developer page (Profile on top right > Developer > Create app)
- Grant the scopes you wish (based on tools) to the client and enable client credentials (Click on App > Grant Types / Scopes)
- Include the client ID and secret in the config file as well as the scopes you wish to use
Local Setup
- Clone this Github repo via
git clone [email protected]:ramp/ramp-mcp.gitor equivalent - 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.