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.

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.

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

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 .

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

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

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

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

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

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

SOCIAL-API.AI