Overview
What is airy?
Airy is an AI-powered tool that enables natural language interaction with databases via a terminal or as an MCP server. It generates SQL queries based on user prompts and requires an OpenRouter API key for AI inference.
How to use airy?
Install airy using Cargo (cargo install airy) or download from GitHub Releases. To run as an MCP server, execute airy --mysql-url <URL> mcp --sse (or --postgres-url) and optionally set the port with --port. For terminal chat mode, use airy chat with the appropriate database URL and OpenRouter API key.
Key features of airy
- Chat with databases directly from the terminal.
- Generate SQL queries from natural language.
- Operate as an MCP server via SSE transport.
- Supports MySQL and PostgreSQL databases.
- Configurable AI model via OpenRouter API.
- Customizable max tokens for AI responses.
Use cases of airy
- Developers quickly query databases without writing raw SQL.
- Non-technical users interact with data using natural language.
- Integration with MCP-compatible clients for automated data access.
- Debugging and exploring database schemas during development.
FAQ from airy
What databases does airy support?
Airy currently works with MySQL and PostgreSQL databases, specified via --mysql-url or --postgres-url options.
How do I install airy?
You can install airy using Cargo (cargo install airy) or download prebuilt binaries from the GitHub Releases page.
What AI model does airy use by default?
The default model is mistralai/devstral-small:free via OpenRouter, but you can choose any supported OpenRouter model using the --model option.
Do I need an API key to use airy?
Yes, an OpenRouter API key is required. Set it via the --openrouter-api-key option or the OPENROUTER_API_KEY environment variable.
How do I run airy as an MCP server with SSE?
Run `airy --mysql-url m
