Agoda Open-Sources Zero-Code API Tool
Agoda has open-sourced APIAgent, a tool that converts any REST or GraphQL API into a managed Microservices Control Plane (MCP) server without custom code. The technology is designed to lower the barrier for integrating diverse data sources into applications. The goal is to allow developers to focus on application logic rather than backend data plumbing, as reported by InfoQ.
- The core technology stack for APIAgent includes FastMCP for the server layer, the OpenAI Agents SDK for orchestrating language model interactions, and DuckDB for in-memory SQL post-processing. - A key feature is its use of DuckDB to manage large API responses; it can filter, aggregate, and join data with SQL before sending a concise result to the language model, a method Agoda engineers consider safer than allowing arbitrary code execution. - The tool addresses what Agoda calls the "integration tax," which is the significant effort required for developers to write, deploy, and maintain a separate Microservices Control Plane (MCP) server for every internal API they want to connect to an AI agent. - APIAgent functions by automatically introspecting an API's schema, using OpenAPI specifications for REST APIs or the schema definition for GraphQL to understand how to structure queries without manual mapping. - For security, the tool operates in a read-only mode by default, blocking any data modification requests (like POST, PUT, DELETE) unless specific mutation paths are explicitly whitelisted in the configuration. - A single deployed instance of APIAgent can serve multiple different APIs simultaneously, with the agent logic distinguishing between them based on request headers, making it appear as though each API has its own dedicated server. - This project is part of Agoda's broader engagement with open-source software; the company also uses and contributes to other well-known developer tools like Grafana and has open-sourced other projects, including a Kubernetes tool for macOS.