Data Pipeline Connector

Unified query interface across CSV files, PostgreSQL databases, and REST APIs with cross-source SQL joins powered by embedded DuckDB.

Connects multiple data source types — CSV/JSON files, PostgreSQL databases, and REST API endpoints — into a single query interface powered by an embedded DuckDB engine. Supports cross-source SQL joins (e.g., joining a CSV against a Postgres table) without requiring an external query service. Includes auto schema detection, REST response caching with configurable TTL, type normalization across sources, and a read-only mode that rejects non-SELECT statements. All queries run locally in-process.