
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 toolsPublic 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*secretYour 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
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