Mcp Airflow Postgres

Created By
gavinHuanga year 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?

  1. Monitoring and querying failed DAG runs in Airflow.
  2. Executing custom SQL queries for data analysis.
  3. 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"
      }
    }
  }
}
Project Info
Created At
a year ago
Updated At
a year ago
Author Name
gavinHuang
Star
-

Recommend Clients

View All
VIDEO-TO-CLAUDE

12 days ago
BUNDLIST

a month ago
ONTHEIA

a month ago
ENTRANS

19 days ago
SUPERNORMAL

2 months ago
SPECMEM

4 months ago
RAGEMP-SERVER

2 months ago
SOCIAL-API.AI

a month ago