DuckDB Helper – SQL over CSV, JSON, Parquet, Excel, SQLite
Pricing
$0.01 / query over input file(s) or a chained dataset
Run a DuckDB SQL query over remote or local input files (CSV, JSON/NDJSON, Parquet, Excel, Avro, SQLite, and more) and push the results to a dataset.
You can access the DuckDB Helper – SQL over CSV, JSON, Parquet, Excel, SQLite programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.
{ "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=rl1987/duckdb-wrapper", "--header", "Authorization: Bearer <YOUR_API_TOKEN>" ] } }}Get a ready-to-use configuration for your MCP client with the DuckDB Helper - SQL Over CSV, JSON, Parquet Actor preconfigured at mcp.apify.com?tools=rl1987/duckdb-wrapper .
You can connect to the Apify MCP Server using clients like Tester MCP Client, or any other MCP client of your choice.
If you want to learn more about our Apify MCP implementation, check out our MCP documentation. To learn more about the Model Context Protocol in general, refer to the official MCP documentation or read our blog post.