# ramp-mcp

> MCP Server

This repository provides a Model Context Protocol server for Ramp, enabling data retrieval, analysis, and task execution using Ramp's Developer API. It uses an ETL pipeline and in-memory SQLite database

## Overview

- **Category:** Developer Tools
- **Language:** Python
- **Stars:** 34
- **Forks:** 0
- **Owner:** ramp-public
- **GitHub:** https://github.com/ramp-public/ramp-mcp
- **Created:** 2025-03-20T14:26:04+00:00
- **Updated:** 2025-03-28T15:50:34+00:00
- **Source:** https://model-context-protocol.com/servers/ramp-model-context-protocol-server-api

## Setup

## 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`](https://docs.astral.sh/uv/)

## Tools

## Available Tools

1. Database tools (Tools that can be used to setup, process, query, and delete an ephemeral database in memory.)
2. `process_data` (Database tool)
3. `execute_query` (Database tool)
4. `clear_table` (Database tool)
5. Fetch tools (Tools that can be used to fetch data directly)
6. `get_ramp_categories` (Fetch tool)
7. `get_currencies` (Fetch tool)
8. Load tools (Loads data to server which the client can fetch.)
9. `load_transactions` (Load tool)
10. `load_reimbursements` (Load tool)
11. `load_bills` (Load tool)
12. `load_locations` (Load tool)
13. `load_departments` (Load tool)
14. `load_bank_accounts` (Load tool)
15. `load_vendors` (Load tool)
16. `load_vendor_bank_accounts` (Load tool)
17. `load_entities` (Load tool)
18. `load_spend_limits` (Load tool)
19. `load_spend_programs` (Load tool)
20. `load_users` (Load tool)