--- title: Building Ramp's MCP server | daily.dev description: Ramp built an open-source MCP server that lets LLMs interact with business spend data using natural language. Built with Python's FastMCP library, the server... canonical: https://daily.dev/posts/building-ramp-s-mcp-server-siassyxan twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Building Ramp's MCP server | daily.dev og:description: Ramp built an open-source MCP server that lets LLMs interact with business spend data using natural language. Built with Python's FastMCP library, the server... og:url: https://daily.dev/posts/building-ramp-s-mcp-server-siassyxan og:image: https://api.daily.dev/og/posts/sIaSSyxAn.png og:image:alt: Building Ramp's MCP server og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Building Ramp's MCP server **[Ramp Engineering](https://daily.dev/sources/ramp_eng)** · 6 min read · 0 upvotes · 0 comments ## Summary Ramp built an open-source MCP server that lets LLMs interact with business spend data using natural language. Built with Python's FastMCP library, the server exposes Ramp's developer API as MCP tools. Initial prototyping with Claude Desktop revealed scaling issues with large datasets, which were solved by implementing an in-memory ETL pipeline that loads API data into SQLite, allowing Claude to query data via SQL instead of processing raw JSON. This dramatically improved accuracy and scalability from hundreds to tens of thousands of transactions. The post covers the architecture, tooling design, security considerations (OAuth scopes, audit logging, least privilege), and remaining limitations like API latency and reliability of write tools. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Connecting LLMs to Your Data With Python MCP Servers – Real Python](https://daily.dev/posts/connecting-llms-to-your-data-with-python-mcp-servers-real-python-9wqmzbqae) · Real Python · 2 upvotes · 0 comments - [MCP Servers for Python Devs](https://daily.dev/posts/mcp-servers-for-python-devs-zy6zukegx) · Planet Python · 0 upvotes · 0 comments - [How to Build Your Own MCP Server with Python](https://daily.dev/posts/how-to-build-your-own-mcp-server-with-python-9azzt16xk) · freeCodeCamp · 4 upvotes · 0 comments - [Medium](https://daily.dev/posts/medium-avonr6rrx) · Medium · 0 upvotes · 0 comments --- Tags: [#python](https://daily.dev/tags/python), [#mcp](https://daily.dev/tags/mcp), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/building-ramp-s-mcp-server-siassyxan) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Building Ramp's MCP server","url":"https://daily.dev/posts/building-ramp-s-mcp-server-siassyxan","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/building-ramp-s-mcp-server-siassyxan"},"datePublished":"2026-07-08T19:14:49.170Z","dateModified":"2026-07-08T19:15:57.044Z","description":"Ramp built an open-source MCP server that lets LLMs interact with business spend data using natural language. Built with Python's FastMCP library, the server...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/0a35f01a520a823373531c4e05dac383?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/0a35f01a520a823373531c4e05dac383?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Ramp Engineering","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Ramp Engineering","logo":"https://media.daily.dev/image/upload/s--4x5H_pLU--/f_auto/v1704280953/logos/ramp.jpg","url":"https://daily.dev/sources/ramp_eng"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/building-ramp-s-mcp-server-siassyxan","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"python,mcp,sqlite","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Ramp Engineering","item":"https://daily.dev/sources/ramp_eng"},{"@type":"ListItem","position":3,"name":"Building Ramp's MCP server"}]} ```