Implements an ephemeral SQLite database in memory for storing and analyzing financial data, with tools for setting up, querying, and managing database tables
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_data
execute_query
clear_table
Fetch tools
Tools that can be used to fetch data directly
get_ramp_categories
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
- 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 git@github.com:ramp/ramp-mcp.git
or equivalent - Install
uv
Usage
Run the MCP server from your CLI with:
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 (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.
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
A Model Context Protocol server that enables access to Ramp financial data through an in-memory database, allowing LLMs to analyze transactions, reimbursements, bills, and other financial information from Ramp's platform.
Related MCP Servers
- AsecurityAlicenseAqualityA Model Context Protocol server that enables LLMs to interact with Salesforce data through SOQL queries, SOSL searches, and various API operations including record management.Last updated -1053PythonMIT License
- AsecurityAlicenseAqualityA Model Context Protocol server that gives LLMs the ability to interact with Ethereum networks, manage wallets, query blockchain data, and execute smart contract operations through a standardized interface.Last updated -313232TypeScriptMIT License
- -security-license-qualityA Model Context Protocol server that enables LLMs to interact with Ramp's financial data by retrieving, analyzing, and running tasks through Ramp's Developer API, using an in-memory SQLite database to overcome token limitations.Last updated -14PythonMIT License
- -securityAlicense-qualityA Model Context Protocol server that enables LLMs to interact with databases (currently MongoDB) through natural language, supporting operations like querying, inserting, deleting documents, and running aggregation pipelines.Last updated -TypeScriptMIT License