ramp-mcp: A Ramp MCP server

ramp-mcp: A Ramp MCP server

By ramp-public GitHub

ramp-mcp

Overview

what is ramp-mcp?

Ramp-mcp is a Model Context Protocol server designed for retrieving and analyzing data or running tasks for Ramp using the Developer API. It implements an ETL pipeline and an ephemeral SQLite database for analysis by a language model.

how to use ramp-mcp?

To use ramp-mcp, set up a Ramp client, clone the GitHub repository, and run the server from your CLI with the necessary environment variables and scopes.

key features of ramp-mcp?

  • Implements a simple ETL pipeline for data processing.
  • Supports an ephemeral SQLite database for in-memory analysis.
  • Provides various tools for data fetching, processing, and loading.

use cases of ramp-mcp?

  1. Analyzing financial transactions and reimbursements.
  2. Fetching and processing large datasets for reporting.
  3. Integrating with other applications via the Ramp Developer API.

FAQ from ramp-mcp?

  • What is the purpose of ramp-mcp?

It serves as a server for data retrieval and analysis using the Ramp Developer API.

  • How do I set up ramp-mcp?

Follow the setup instructions in the documentation to create a client and run the server.

  • Can I use ramp-mcp for large datasets?

Yes, but be cautious of API limitations and ensure to keep responses concise to avoid timeouts.

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.

  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.

ToolScope
load_transactionstransactions:read
load_reimbursementsreimbursements:read
load_billsbills:read
load_locationslocations:read
load_departmentsdepartments:read
load_bank_accountsbank_accounts:read
load_vendorsvendors:read
load_vendor_bank_accountsvendors:read
load_entitiesentities:read
load_spend_limitslimits:read
load_spend_programsspend_programs:read
load_usersusers: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 git@github.com: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:

{
  "mcpServers": {
    "ramp-mcp": {
      "command": "uv",
      "args": [
        "--directory",
        "/<ABSOLUTE-PATH-TO>/ramp-mcp", // make sure to update this path
        "run",
        "ramp-mcp",
        "-s",
        "transactions:read,reimbursements:read"
      ],
      "env": {
        "RAMP_CLIENT_ID": "<CLIENT_ID>",
        "RAMP_CLIENT_SECRET": "<CLIENT_SECRET>",
        "RAMP_ENV": "<demo|qa|prd>"
      }
    }
  }
}

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

License

Copyright (c) 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.

No tools information available.
No content found.