Airy MCP Server

Airy is an MCP (Model Context Protocol) server that bridges conversational AI assistants with relational databases. By exposing a lightweight HTTP endpoint and optional Server‑Sent Events stream, it allows models such as Claude to query, analyze, and manipulate data without leaving the chat context. This eliminates the need for custom database connectors or manual SQL generation, giving developers a single, consistent interface to talk to MySQL or PostgreSQL from any tool that understands MCP.

The core problem Airy solves is the friction between natural‑language interfaces and structured data stores. Developers often need to translate user intent into SQL, handle authentication, manage connection pools, and format results. Airy abstracts all of that: you point it at a database URL, configure an OpenRouter model, and the server handles query generation, execution, and result formatting. This makes it especially valuable for rapid prototyping, data‑driven chatbots, or internal knowledge bases where non‑technical users can ask questions that the AI turns into precise queries.

Key capabilities include:

• SQL generation and execution – The server forwards user prompts to an LLM, receives a generated query, runs it against the target database, and streams back results.
• SSE streaming – When launched with , Airy emits partial responses as Server‑Sent Events, enabling real‑time updates in web UIs or terminal clients.
• Multi‑database support – It accepts both MySQL and PostgreSQL URLs, automatically handling connection details.
• MCP compliance – By following the Model Context Protocol spec, Airy can be discovered and interacted with by any MCP‑aware client, including the official tool.

Typical use cases involve building data‑centric conversational agents: an HR assistant that can answer employee queries, a sales dashboard bot that pulls real‑time metrics, or an internal analytics tool where users can ask questions in plain English and receive tables or visual summaries. Because Airy runs as a standalone server, it can be deployed behind existing authentication layers or integrated into larger micro‑service architectures.

Airy’s standout advantage is its zero‑code integration path. Developers need only provide a database URL and an OpenRouter key; the server handles all LLM interactions, query safety checks, and result serialization. This dramatically reduces boilerplate, speeds up iteration, and ensures that database access remains secure and auditable through the MCP interface.