Mcp Airflow Postgres

Created By

gavinHuang7 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.

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

CursorThe AI Code Editor

DeepChatYour AI Partner on Desktop

MCP PlaygroundCall MCP Server Tools Online

A Sleek AI Assistant & MCP Client5ire is a cross-platform desktop AI assistant, MCP client. It compatible with major service providers, supports local knowledge base and tools via model context protocol servers .

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

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.

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

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

ChatWiseThe second fastest AI chatbot™