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
TRACE-MCP

3 months ago
ODOO-MCP-SERVER

4 months ago
Chain.Love MCP
@Chain.Love

## Overview ### what is Chain.Love MCP? Chain.Love MCP is a hosted remote MCP server and gateway for AI agents. It provides a single endpoint for discovering and comparing Web3 infrastructure services across 50+ blockchain networks, including RPCs, indexing, oracles, storage, compute, and developer tools. ### how to use Chain.Love MCP? To use Chain.Love MCP, add the hosted endpoint to your MCP client and connect to `https://app.chain.love/mcp` over Streamable HTTP. For public use cases, the basic MCP server URL is enough. For private downstream MCPs, add credentials only when required using `x-chainlove-cred-<credentialKey>` headers. ### key features of Chain.Love MCP? - Hosted remote MCP gateway for AI agents - Single endpoint for Web3 infrastructure discovery across 50+ blockchain networks - Aggregates infrastructure options across RPCs, indexing, oracles, storage, compute, and developer tools - Streamable HTTP transport - Public documentation and onboarding resources available online ### use cases of Chain.Love MCP? - Discovering and comparing Web3 infrastructure providers across many blockchain networks - Finding RPC, indexing, oracle, storage, compute, and developer tooling options through one MCP server - Giving AI agents a single hosted integration surface for Web3 infrastructure discovery - Reducing the need to integrate many separate provider-specific endpoints ### FAQ from Chain.Love MCP? - Can Chain.Love MCP be used as a hosted remote MCP server? Yes. Chain.Love MCP is designed to be consumed as a hosted remote MCP endpoint at `https://app.chain.love/mcp`. - Does Chain.Love MCP require credentials? Not always. Some downstream integrations may require credentials, which can be passed using `x-chainlove-cred-<credentialKey>` headers when needed. - How do I know which credential header to use? You can check the open-source Chain.Love registry at `https://github.com/Chain-Love/chain-love/blob/main/references/offers/mcpservers.csv` or browse `https://app.chain.love/toolbox/mcpservers` and look for the relevant `credentialKey` value. - Where can I learn more? Landing page: `https://www.chain.love/mcp-gateway` Documentation: `https://chain-love.gitbook.io/mcp-module`

3 months ago
MCP-OAUTH2-PROXY

2 months ago
VIDEO-TO-CLAUDE

2 months ago
CAPTAIN-CLAW

a month ago
AGENT

a month ago
SOCIAL-API.AI

3 months ago
CONTENTDRIPS-MCP

14 days ago
SUPERNORMAL

3 months ago