ramp-mcp: A Ramp MCP server

What is ramp-mcp?

A Model Context Protocol server for retrieving and analyzing data or running tasks for Ramp using the Ramp Developer API. It implements a simple ETL pipeline with an ephemeral SQLite database in memory to overcome token and input size limitations for LLM analysis. All requests default to the demo environment but can be changed to production by setting RAMP_ENV=prd.

How to use ramp-mcp?

Clone the repository, install uv, then run the server from the CLI with environment variables RAMP_CLIENT_ID, RAMP_CLIENT_SECRET, and optionally RAMP_ENV, plus the -s flag for comma-separated API scopes. For example:
RAMP_CLIENT_ID=... RAMP_CLIENT_SECRET=... RAMP_ENV=<demo|prd> uv run ramp-mcp -s transactions:read,reimbursements:read
Then load data using available load_* tools before querying the ephemeral database with process_data, execute_query, or clear_table.

Key features of ramp-mcp

• ETL pipeline + ephemeral SQLite database for efficient LLM analysis.
• Database tools: process_data, execute_query, clear_table.
• Direct fetch tools: get_ramp_categories, get_currencies.
• Load tools for transactions, reimbursements, bills, locations, departments, etc.
• All data requests are scoped to the API permissions you grant.

Use cases of ramp-mcp

• Analyze Ramp transaction data without hitting API token limits.
• Run natural language queries against an ephemeral database of loaded Ramp entities.
• Automate reconciliation or spending analysis for departments and categories.
• Load and query vendor, bank account, or spend program data for reporting.