Mcp Airflow Postgres

Created By

gavinHuanga year 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.

y-cli 🚀A Tiny Terminal Chat App for AI Models with MCP Client Support

CursorThe AI Code Editor

Refact.aiOpen-source AI Agent for VS Code and JetBrains that autonomously solves coding tasks end-to-end.

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

WindsurfThe new purpose-built IDE to harness magic

ChatWiseThe second fastest AI chatbot™

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

MCP ConnectEnables cloud-based AI services to access local Stdio based MCP servers via HTTP requests

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

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