- Mcp Airflow Postgres
Mcp Airflow Postgres
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?
- 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
.envfile 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.yamlfile.
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
Recommend Clients
View AllVisual Studio Code - Open Source ("Code - OSS")
@microsoft
Visual Studio Code
TypeScript
a year ago
VIDEO-TO-CLAUDE
12 days ago
BUNDLIST
a month ago
ONTHEIA
a month ago
MIPLER---SHOPIFY-REPORTING
2 months ago
ENTRANS
19 days ago
MERMAID-MCP-APP
@Hryhorii Avcharov
4 months ago
MEMESIO-MEME-GENERATOR
3 months ago
SUPERNORMAL
2 months ago
SPECMEM
4 months ago
RAGEMP-SERVER
2 months ago
SOCIAL-API.AI
a month ago