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

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

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

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

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

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.

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

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

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.

CursorThe AI Code Editor

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

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