Mcp Airflow Postgres

Created By

gavinHuang7 months ago

Operate airflow's postgresql directly

Overview

What is MCP Airflow Postgres?

MCP Airflow Postgres is a Model Context Protocol (MCP) server designed for interacting with Airflow databases, specifically using PostgreSQL.

How to use MCP Airflow Postgres?

To use MCP Airflow Postgres, clone the repository, install dependencies using Poetry, configure your environment with the database connection string, and run the server.

Key features of MCP Airflow Postgres?

Direct interaction with Airflow's PostgreSQL database.
Tools for querying failed Airflow DAG runs.
Ability to execute SQL queries directly against the Airflow database.

Use cases of MCP Airflow Postgres?

Monitoring and querying failed DAG runs in Airflow.
Executing custom SQL queries for data analysis.
Integrating with other tools like Smithery for enhanced functionality.

FAQ from MCP Airflow Postgres?

What are the prerequisites for using MCP Airflow Postgres?

You need Python 3.8 or higher and Poetry installed on your system.

How do I configure the database connection?

Create a .env file with your database connection string in the format: DATABASE_URL=postgresql://user:password@host:port/database.

Can I use this with other tools?

Yes, it can be used with Smithery as configured in the smithery.yaml file.

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.

LutraLutra is the first MCP compatible client built for everyone

CursorThe AI Code Editor

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

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

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

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

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.

ChatWiseThe second fastest AI chatbot™

BACHAI-TWITTER-API45Twitter的一些api mcp

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 .