mcpField
A
airy

airy

Local
github.com/tinrabDatabases5Updated 73w ago
Repository

About airy

airy is a terminal-based database tool for chatting with a database and generating SQL. It can also run as an MCP server, including over SSE.

Key features

  1. 01Chat with a database in the terminal
  2. 02Generate SQL queries
  3. 03Run as an MCP server

Use cases

  1. 01Ask questions about a database from the terminal
  2. 02Generate SQL while working with database data
  3. 03Expose database interaction through MCP

MCP support

airy can run as an MCP server. Its SSE mode listens on a configurable port and can be tested with the MCP Inspector.

#rust#ai#mcp#mcp-server

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

airy

Crates.io Version

An AI tool for interacting with databases.

terminal example

Features:

  • Chat with your database in terminal.
  • Generate SQL queries.
  • Run as a MCP server.

Installation

Download from GitHub Releases.

Install using Cargo.

$ cargo install airy

Help

Usage: airy [OPTIONS] <COMMAND>

Commands:
  chat
  mcp
  help  Print this message or the help of the given subcommand(s)

Options:
      --openrouter-api-key <OPENROUTER_API_KEY>
          OpenRouter API Key [env: OPENROUTER_API_KEY=]
      --openrouter-base-url <OPENROUTER_BASE_URL>
          OpenRouter Base URL [env: OPENROUTER_BASE_URL=] [default: https://openrouter.ai/api/v1]
      --model <MODEL>
          OpenRouter model ID [env: MODEL=] [default: mistralai/devstral-small:free]
      --max-tokens <MAX_TOKENS>
          Max tokens [default: 1024]
      --mysql-url <MYSQL_URL>
          MySQL URL [env: MYSQL_URL=]
      --postgres-url <POSTGRES_URL>
          PostgreSQL URL [env: POSTGRES_URL=]
  -h, --help
          Print help
  -V, --version
          Print version

Usage: airy mcp [OPTIONS]

Options:
      --sse          Run as a server using SSE
      --port <PORT>  Set the Port [default: 8080]
  -h, --help         Print help

Development

Set up the dev environment.

$ just mysql-download-data # downloads test data

$ just docker-up # starts Docker containers
$ just migrate up # runs migrations to the latest version

$ just mysql-load-data # loads data into the database

Run chat.

$ OPENROUTER_API_KEY=[..] cargo run -- --mysql-url "mysql://employee:[email protected]:3306/employee" chat

You can also provide OPENROUTER_API_KEY, MYSQL_URL and other arguments as environment variables.

Run MCP server with server-sent events.

$ cargo run -- --mysql-url "mysql://employee:[email protected]:3306/employee" mcp --sse

You can test the MCP server with @modelcontextprotocol/inspector by connecting to http://localhost:8080/sse.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.