smart_load_multiple_csv_files · Duckdb MCP: Risk & Policy

WHAT IT DOES

What smart_load_multiple_csv_files does on Duckdb

AI agents use smart_load_multiple_csv_files to create or update resources in Duckdb — usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Duckdb environment.

WHY IT NEEDS A POLICY

Why smart_load_multiple_csv_files needs a policy

This tool creates new tables in the DuckDB database by loading multiple CSV files, which is a reversible write operation (tables can be dropped later). The 'intelligent naming' aspect introduces some risk as it may overwrite existing tables with auto-generated names, but there is no explicit indication of irreversible deletion.

From the tool's definition Load multiple CSV files and intelligently name the tables based on content analysis

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

smart_load_multiple_csv_files Rate-limited

smart_load_multiple_csv_files stays usable, but capped — an agent stuck in a loop can't make hundreds of changes a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "smart_load_multiple_csv_files": {
      "limits": [
        {
          "counter": "smart_load_multiple_csv_files_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL →

Instant setup, no code required.

PolicyLayer is an MCP gateway: every tool call is checked against your rule before it reaches Duckdb, so you can run agents against it safely.

FAQ

Questions about smart_load_multiple_csv_files

What does the smart_load_multiple_csv_files tool do? +

Load multiple CSV files and intelligently name the tables based on content analysis. It is categorised as a Write tool in the Duckdb MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on smart_load_multiple_csv_files? +

Register the Duckdb MCP server in PolicyLayer and add a rule for smart_load_multiple_csv_files: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Duckdb. Nothing to install.

What risk level is smart_load_multiple_csv_files? +

smart_load_multiple_csv_files is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit smart_load_multiple_csv_files? +

Yes. Add a rate_limit block to the smart_load_multiple_csv_files rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block smart_load_multiple_csv_files completely? +

Set action: deny in the PolicyLayer policy for smart_load_multiple_csv_files. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides smart_load_multiple_csv_files? +

smart_load_multiple_csv_files is provided by the Duckdb MCP server (synehq/mcp-server-duckdb). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.