Mcp Airflow Postgres

创建者

gavinHuanga year ago

Operate airflow's postgresql directly

概览

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.

服务器配置

{
  "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"
      }
    }
  }
}

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.

EXPLYT

Continue⏩ Create, share, and use custom AI code assistants with our open-source IDE extensions and hub of models, rules, prompts, docs, and other building blocks

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.

LutraLutra is the first MCP compatible client built for everyone

WindsurfThe new purpose-built IDE to harness magic

ChatWiseThe second fastest AI chatbot™

CursorThe AI Code Editor

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

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

DeepChatYour AI Partner on Desktop