Skip to main content

MCP Airflow Database

A Model Context Protocol (MCP) server for interacting with Airflow databases.

Setup with Poetry

Prerequisites

  • Python 3.8 or higher
  • Poetry installed on your system

Installation

  1. Clone this repository:

    git clone <your-repository-url>
    cd mcp-airflow-db
    
  2. Install dependencies with Poetry:

    poetry install
    
  3. Configure your environment: Create a .env file with your database connection string:

    DATABASE_URL=postgresql://airflow:airflow123@localhost:5432/airflow
    

Running the MCP Server

Run the server with Poetry:

poetry run python src/server.py

Or activate the Poetry environment first:

poetry shell
python src/server.py

Using with Smithery

This MCP can be used with Smithery directly as configured in the smithery.yaml file. Make sure to provide the DATABASE_URL configuration when starting the server.

Available Tools

  • failed_runs: Query failed Airflow DAG runs within a specified time period.
  • query: Execute SQL queries directly against the Airflow database.

License

[Your License]

Metadata

Release files for mcp-airflow-postgres 0.1.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for mcp-airflow-postgres 0.1.3
File Size Uploaded Provenance Actions
mcp_airflow_postgres-0.1.3.tar.gz 33.3 kB Without provenance Details for mcp_airflow_postgres-0.1.3.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for mcp-airflow-postgres 0.1.3
File Interpreter ABI Platform Actions
mcp_airflow_postgres-0.1.3-py3-none-any.whl Python 3 none any Details for mcp_airflow_postgres-0.1.3-py3-none-any.whl

Total release size: 37.5 kB

Release files / mcp_airflow_postgres-0.1.3.tar.gz

Download URL mcp_airflow_postgres-0.1.3.tar.gz
Size 33.3 kB
Tags Source
SHA-256 checksum
How to use checksums
117182834c98e0b9403975b2f560db8150285d6d6c2c29251d4bfc71b744180c
BLAKE2b-256 checksum
How to use checksums
9e97fcaf803f74ee054b362506ed1259c01ec2ea979db658ba064fc839e24182
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.1.0 CPython/3.12.9

Release files / mcp_airflow_postgres-0.1.3-py3-none-any.whl

Download URL mcp_airflow_postgres-0.1.3-py3-none-any.whl
Size 4.2 kB
Tags Python 3
SHA-256 checksum
How to use checksums
07cf32ae0f8e1050c1d20e04f915451c21b90f81b29d09303171940d13a53c8b
BLAKE2b-256 checksum
How to use checksums
f721bde08dba7ab2a2784426fd524cc65a220c02b0a65f5431266f838f582b14
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.1.0 CPython/3.12.9

Security for mcp-airflow-postgres 0.1.3

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page