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
ODOO-MCP-SERVER

2 months ago
BETTERCLAW

22 days ago
PISS

3 months ago
ONTHEIA

2 months ago
ENTRANS

a month ago
KERNELGEN

3 months ago
LIVONIAN

5 days ago
STATIONONE

2 months ago
MCP-OAUTH2-PROXY

10 days ago
KTA-ORACLE

2 months ago