ramp_mcp

ramp_mcp

18
research_and_datadatabases

This project is a Model Context Protocol server designed for data retrieval and analysis tasks utilizing Ramp's Developer API. It features tools for database handling, data fetching, and loading specific data types, using an in-memory SQLite database for efficient processing.

Overview

A Model Context Protocol server for data retrieval and analysis tasks for Ramp using its Developer API. The server includes an ETL pipeline and an in-memory ephemeral SQLite database for data processing. Tools are available for database operations, data fetching, and loading various types of data such as transactions, reimbursements, bills, and more. The default environment is set to demo but can be changed to production via configuration.

Tools

  • Database tools: Setup, process, query, and clear ephemeral database.
  • Fetch tools: Fetch Ramp categories and currencies.
  • Load tools: Load various data types with appropriate scopes.

Setup

  1. Create a new client on Ramp's developer page and grant necessary scopes.
  2. Clone the repository and install uv for running the server.

Usage

Run the MCP server using CLI with the necessary environment variables and scopes.

Configuration

Configure Claude Desktop with specific commands and arguments to use the server efficiently.