Mcp Airflow Postgres

Created By

gavinHuang9 months ago

Operate airflow's postgresql directly

# airflow

# database

Overview Content Tools Comments

Content

MCP Airflow Database

A Model Context Protocol (MCP) server for interacting with Airflow databases.

Setup with Poetry

Prerequisites

Python 3.8 or higher
Poetry installed on your system

Installation

Clone this repository:

git clone <your-repository-url>
cd mcp-airflow-db

Install dependencies with Poetry:
```
poetry install
```
Configure your environment: Create a .env file with your database connection string:
```
DATABASE_URL=postgresql://airflow:airflow123@localhost:5432/airflow
```

Running the MCP Server

Run the server with Poetry:

poetry run python src/server.py

Or activate the Poetry environment first:

poetry shell
python src/server.py

Using with Smithery

This MCP can be used with Smithery directly as configured in the smithery.yaml file. Make sure to provide the DATABASE_URL configuration when starting the server.

Available Tools

failed_runs: Query failed Airflow DAG runs within a specified time period.
query: Execute SQL queries directly against the Airflow database.

License

[Your License]

Server Config

{
  "mcpServers": {
    "mcp-airflow-postgres": {
      "command": "uvx",
      "args": [
        "--from",
        "D:\\GPT\\mcp-airflow-postgres",
        "mcp-airflow-postgres"
      ],
      "env": {
        "DATABASE_URL": "postgresql://airflow:airflow123@localhost:5432/airflow"
      }
    }
  }
}

Recommend Clients

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

Cherry Studio🍒 Cherry Studio is a desktop client that supports for multiple LLM providers.

ZedCode at the speed of thought – Zed is a high-performance, multiplayer code editor from the creators of Atom and Tree-sitter.

Cline – #1 on OpenRouterAutonomous coding agent right in your IDE, capable of creating/editing files, executing commands, using the browser, and more with your permission every step of the way.

HyperChatHyperChat is a Chat client that strives for openness, utilizing APIs from various LLMs to achieve the best Chat experience, as well as implementing productivity tools through the MCP protocol.

chatmcpChatMCP is an AI chat client implementing the Model Context Protocol (MCP).

WindsurfThe new purpose-built IDE to harness magic

Roo Code (prev. Roo Cline)Roo Code (prev. Roo Cline) gives you a whole dev team of AI agents in your code editor.

Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.

LutraLutra is the first MCP compatible client built for everyone

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code