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?

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 .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

US Government Open Data MCP

@Lzinga

MCP server with 188 tools for 36 U.S. government APIs. Access Treasury, FRED, Congress, FDA, CDC, FEC, lobbying disclosures, SEC, USGS, and many more. Cross-references data automatically across sources. 18 APIs need no key.

3 months ago

LYRIA3-AI

Advanced multimodal AI music generator with realistic vocals and pro-level arrangements.

2 months ago

IMAGE-TO-IMAGE-AI

@Claude

Image to Image AI is an AI image and video platform that lets you transform reference images or generate new ones from text. Upload one or several images, add a prompt, and get high-quality outputs in multiple aspect ratios (1:1, 16:9, 9:16, etc.) and resolutions (1K, 2K, 4K). It runs on AI Best and supports 9+ models including Nano Banana, Nano Banana Pro, GPT-4o Image, Flux Kontext, and video models like Veo. Use it for product shots, social content, concept art, or marketing—with sharper 2K imagery, 4K scaling, better text in images, and consistent characters.

3 months ago

VIBE-PROSPECTING

3 months ago

MCP-BUNDLES

2 months ago

CHATATP

@Samuel Obinna Chimdi

4 months ago

KTA-ORACLE

2 months ago

MODELSCOPE---MODELSCOPE-PLATFORM-MCP-SERVICES

4 months ago

Stitch Mcp App UI

An interactive MCP App that brings Google Stitch design tools directly into AI assistants like Claude Code, Claude Desktop, and ChatGPT. Browse projects, view screen designs, extract design tokens, and generate new screens — all within your chat interface. Built with the MCP Apps (ext-apps) extension, which renders interactive React UI inside MCP host sandboxed iframes.

4 months ago

NANA-BANANA-PRO

3 months ago

LINKAGOGO-MCP---BOOKMARK-MANAGER

@Henry van den Broek

Manage your LinkaGoGo bookmarks through any AI assistant that supports the Model Context Protocol (MCP). Search, add, organize, tag, move, and export bookmarks conversationally — 16 tools for full bookmark and folder management. Connect via Claude.ai, Claude Desktop, or any MCP-compatible client.

2 months ago

Mcpwner

@Pigyon

MCPwner is a Model Context Protocol (MCP) server that integrates security testing tools into LLM-driven workflows. It provides a unified interface for secret scanning, static analysis (SAST), software composition analysis (SCA), and vulnerability research including 0-day discovery. Instead of manually chaining tools and pasting outputs into your LLM, MCPwner standardizes and streams results directly into the model's working context. This enables continuous reasoning, correlation, and attack path discovery across the entire security research lifecycle - from identifying known vulnerabilities to uncovering novel attack vectors.

3 months ago

NANA-BANANA

Fast, intuitive AI image generation platform for everyday creative inspiration.

2 months ago

4 months ago

3 months ago

Persistent semantic memory for Claude Code, chats AND code. 74+ MCP tools, local pgvector embeddings, codebase indexing with 14 language extractors, multi-agent team coordination. Self-hosted, zero cloud dependency.

4 months ago

MIPLER-SHOPIFY-REPORTS

2 months ago

NANA-BANANA-PRO

Premium AI image suite offering advanced fine-tuning and professional editing tools.

2 months ago

ECHONOVA-AI

Experimental AI audio platform for ambient soundscapes and innovative sound design.

2 months ago

SILVIA-MCP

a month ago

Zed

@zed-industries

Code at the speed of thought – Zed is a high-performance, multiplayer code editor from the creators of Atom and Tree-sitter.

Rust

a year ago

Airtable User Mcp

@Automations-Project

Community Internal MCP server for Airtable - 30 tools for schema inspection, field CRUD (formula, rollup, lookup, count), view configuration, formula validation, and extension management. Not affiliated with Airtable Inc.

2 months ago

PIXMAGIC

Creative AI art engine designed for unique style transfers and instant visual magic.

2 months ago

STATIONONE

@Kochava

StationOne is a local-first, model-agnostic AI client and orchestration layer that enables users to build, run, and manage agentic workflows across multiple LLMs and MCP connectors. It provides a unified workspace for integrating AI models, tools, and data sources through the Model Context Protocol (MCP), allowing agents to securely interact with external services like APIs, databases, and SaaS platforms. With support for custom agents, pre-prompt templates, and a curated MCP marketplace, StationOne acts as a central hub for deploying scalable, context-aware AI automation across personal and enterprise environments.

a month ago

MCPBundles

@tonylewislondon

Studio is where you run MCP tools in the browser against real credentials -- see inputs, outputs, and errors before you trust an agent. Enable bundles in your workspace, then add your Hub or per-bundle streamable HTTP URL in Cursor, Claude, ChatGPT, or VS Code. Workspace-scoped credentials; optional mcpbundles CLI on PyPI.

2 months ago

RAGEMP-SERVER

2 months ago

NANA-BANANA-PRO

3 months ago

Burnish — Swagger UI for MCP

@danfking

Explorer-first MCP client that renders any MCP server's tools as interactive UI — no LLM required, no tool-calling loop. Point it at any MCP server over stdio or SSE and get cards, tables, charts, forms, pipelines, and dashboards auto-generated from your tool outputs. Install with `npx burnish -- <your-mcp-server>`.

2 months ago

Continue

@continuedev

⏩ Create, share, and use custom AI code assistants with our open-source IDE extensions and hub of models, rules, prompts, docs, and other building blocks

TypeScript

a year ago

ENTRANS

23 days ago