dbsectrainer avatar

Mcp Data Pipeline Connector

dbsectrainer/mcp-data-pipeline-connector

Gives Claude SQL access to CSV files, Postgres databases, and REST APIs through an embedded DuckDB engine. The standout feature is cross-source joins: you can write a single SELECT statement that joins a local CSV against a Postgres table and a REST endpoint response without shuffling data between tools. Exposes seven tools covering connection management, schema inspection, query execution, and health checks. Ships with a 1000-row result cap and read-only mode by default. REST responses are cached for five minutes to avoid redundant calls. If you're asking questions that span multiple data sources or want one server instead of three separate connectors, this replaces the usual per-source setup. Configuration lives in a YAML file with environment variable support for credentials.

tools
7
auth
Secret needed
transport
STDIO
env var
1
last updated
Nov 4, 2026

Tools

7 tools

Public tool metadata for what this MCP can expose to an agent.

connect_source

No parameter schema in public metadata yet.

list_sources

No parameter schema in public metadata yet.

list_tables

No parameter schema in public metadata yet.

get_schema

No parameter schema in public metadata yet.

query

No parameter schema in public metadata yet.

transform

No parameter schema in public metadata yet.

check_health

No parameter schema in public metadata yet.

Sponsors

Configuration

YOUR_API_KEY*secret

Your API key for the service

Readme

MCP Data Pipeline Connector

npm mcp-data-pipeline-connector package

One MCP server for all your data sources — with cross-source SQL joins and no external query service. DuckDB runs embedded in-process, so you can join a CSV file against a Postgres table against a REST API response in a single query, entirely on your machine. Agents work with your data without needing source-specific knowledge or multiple MCP server configs.

Tool reference | Configuration | Contributing | Troubleshooting

Key features


View the full README on GitHub

Details

Repository
github.com/dbsectrainer/mcp-data-pipeline-connector
Categories
Sales & Marketing, Databases, Automation & Workflows, Data & Analytics
Package
mcp-data-pipeline-connector
Transport
STDIO
Auth
Required
Registry
MCP registry, active

More from dbsectrainer

Related Sales & Marketing MCP servers

View all
1bnmbnmai avatarApollo Intelligence Networkbnmbnmai/mcp-proxy54 AI agent tools: OSINT, intel feeds, DeFi, crypto, weather, DNS, proxies. x402 micropayments.0stars
2br0ski777 avatarSEO Page Analyzerbr0ski777/seo-analyzer-x402SEO audit any URL: meta tags, headings, links, images, Schema.org, score 0-100. x402.0stars
3br0ski777 avatarTechnology Stack Detection APIbr0ski777/tech-enrichment-x402Detect 50+ technologies on any website: CMS, frameworks, analytics, CDN. x402.0stars
4centrify-internal avatarHubSpot Integrations MCPcentrify-internal/hubspot-mcp-serverMCP server for the HubSpot Integrations Center HubDB: search and retrieve integration data.0stars
5company-gibraltar avatarCompany Gicompany-gibraltar/company-gi-mcpGibraltar company tools: corporate tax, compliance deadlines, and PDF form generation.0stars
6company-gibraltar avatarCompany Gibraltarcompany-gibraltar/company-gibraltar-mcpGibraltar company tools: corporate tax, compliance deadlines, and PDF form generation.0stars