mcpField
R
ramp-mcp: A Ramp MCP server

ramp-mcp: A Ramp MCP server

Local
github.com/ramp-publicFinance34Updated 84w ago

About ramp-mcp: A Ramp MCP server

ramp-mcp is an MCP server for retrieving and analyzing data from the Ramp Developer API. It runs a simple ETL pipeline into an ephemeral in-memory SQLite database so an LLM can query the data, and defaults to the demo environment.

Key features

  1. 01Loads Ramp data into an in-memory SQLite database
  2. 02Runs SQL queries and clears tables
  3. 03Fetches categories and currencies
  4. 04Loads transactions, bills, vendors and other scoped data
  5. 05Defaults to demo environment, switchable by variable

Use cases

  1. 01Letting an LLM analyze Ramp transactions and reimbursements
  2. 02Querying bills and vendor records with SQL
  3. 03Filtering large datasets before analysis to reduce token use

MCP support

This project is an MCP server that exposes database, fetch and load tools for accessing Ramp data to MCP clients.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

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 [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:

{
  "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.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.