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
-
Clone this repository:
git clone <your-repository-url> cd mcp-airflow-db
-
Install dependencies with Poetry:
poetry install
-
Configure your environment: Create a
.envfile 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)
| 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)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| 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.