Agentic Data Engineering Resources

Resource

What Is Agent Tool Calling?

Learn how agent tool calling lets LLMs execute external functions. Covers implementation, security, and production best practices.

Pedro Lopez

March 6, 2026

Last updated November 5, 2026

Summarize with AI:

Agent tool calling lets large language models request execution of external functions during inference. The model analyzes a user's request, decides which tools are needed, generates structured parameters, and feeds results back into its reasoning process. This turns LLMs from text generators into AI agents that can query databases, call APIs, search documents, and trigger actions in external systems.

The model never touches your systems directly. It outputs structured JSON specifying which function to call and with what arguments, and your application code handles actual execution. This separation makes tool calling viable for production applications where agents need access to customer data, internal systems, and third-party services.

TL;DR

Agent tool calling lets LLMs request execution of external functions by generating structured JSON output. Your application code handles actual execution. This maintains a security boundary between the model and your systems.
Implementation requires JSON schema definitions for each tool, an execution loop with state management, parameter validation before execution, and detailed tool descriptions the model uses to decide when and how to invoke each function.
Security demands include prompt injection defense, OAuth 2.0/2.1 scoped tokens, Row-Level Security (RLS) at the database layer, tool-level authorization, and Human-in-the-Loop approval for high-risk operations.
Production challenges center on schema validation failures, infinite loops, context window overflow, network timeouts, and insufficient observability into agent decision-making across multi-step workflows.

Why Does Agent Tool Calling Matter for Production Applications?

A customer support agent that can only generate helpful text isn't particularly valuable. One that can check order status in your database, retrieve shipping information from your logistics provider, and update ticket status in your CRM handles the same workload that previously required a human for every request. Tool calling lets agents act on real systems, not just describe what actions could be taken.

This matters at the infrastructure level because tool calling abstracts agent integration complexity into schema definitions that models interpret autonomously. You define what a tool does once, and the agent figures out when and how to use it across different user requests. As your agent connects to more systems, you add schemas. You don't rewrite orchestration logic. For teams building agents across multiple SaaS tools, the quality of data access through tool calls determines whether the agent produces accurate or hallucinated responses.

How Does Agent Tool Calling Work?

You define available tools using JSON schemas describing each function's purpose, parameters, and constraints. The model receives these schemas in its system prompt alongside the user's query, then performs semantic matching to decide whether external functions are needed.

When the model determines a tool is appropriate, it includes a structured JSON tool call in its response. It may also include ordinary text alongside the tool call. For OpenAI's API, this appears as a tool_calls object containing the function name and arguments. For Anthropic's Claude, it's a tool_use content block with similar structure.

Your application code receives this request, validates it, executes the function, and passes results back to the model as a new message in the conversation context. The model then decides whether to generate text, invoke another tool, or request clarification. This loop continues until the model has enough information to produce a final response.

Consider a request like "Book me a flight to Paris next week." The agent calls a calendar API for availability, a flight search API with date and destination parameters, presents options, and requests a booking tool call only after user confirmation. Your application layer handles all the API interactions.

The tradeoff is latency and cost. Each tool call adds an API round-trip plus an additional LLM inference to process the result and decide next steps. An agent that chains five tool calls incurs five times the inference cost and five sequential network round-trips. For production systems, this means you need to think carefully about which tools to expose and where to cache results.

How traditional API integrations compare

	Traditional API integrations	Agent tool calling
Workflow design	You code every path explicitly during development	The agent decides at runtime which tools to invoke and in what order
Adding integrations	Write connection code, auth handling, error logic, and orchestration for each new source	Write one more schema definition; the agent reuses the same decision-making process
Scaling complexity	Linear growth in maintenance burden with each integration	Flat; new tools don't increase orchestration complexity
Flexibility	Handles only scenarios you anticipated during development	Constructs workflows autonomously for unanticipated queries

What Are Real-World Use Cases for Agent Tool Calling?

Knowledge retrieval

Tool calling becomes especially important when agents need to retrieve context from your own systems. Most teams start with RAG pipelines, but more advanced architectures like Agentic RAG use tool calling to let the agent decide what to retrieve and when. When an employee asks "What's our policy on remote work?" the agent invokes a vector database search tool, retrieves matching documents, and synthesizes a response with citations. If the initial results are incomplete, the agent makes follow-up retrieval calls.

Multi-system workflows

A customer asks your support agent about a delayed shipment. The agent calls your order management API for fulfillment status, queries your shipping provider's tracking endpoint, checks your billing system for payment holds, and synthesizes a response with an estimated resolution time. Each tool call builds on what previous calls returned, and the agent determines the sequence based on what it learns at each step.

Developer tooling and CI/CD

Engineering teams use tool calling to connect agents to development infrastructure. An agent monitoring a deployment pipeline can query your CI system for build status, pull error logs from your observability platform, and search recent commits for related changes. The agent handles cross-system correlation that would otherwise require an engineer to switch across four dashboards.

How Do You Implement Agent Tool Calling?

Defining tool schemas

OpenAI uses a tools parameter with JSON Schema specifications, where each tool uses a parameters key to define inputs. Anthropic uses a different structure with input_schema instead. This incompatibility requires schema translation when migrating between platforms. Each tool needs a name, description, and parameters/input_schema object defining expected inputs.

Schema quality impacts agent performance more than most teams expect. Clear descriptions and well-defined parameters lead to better tool selection accuracy and more reliable parameter extraction. The tradeoff is flexibility: overly strict schemas reject valid edge-case inputs, while loose schemas let the model generate parameters that pass validation but produce unexpected results. Start strict and loosen constraints based on what you observe in production.

Building the execution loop

The execution loop requires careful state management across conversation context, tool calls made, results returned, and the agent's reasoning. Each iteration adds structured messages to context, with OpenAI using tool_calls objects and Anthropic using content blocks with tool_use elements. LangChain's agent_scratchpad takes this approach, maintaining a growing message list that captures user input, tool calls, results, and intermediate reasoning. The full history passes to the LLM on each invocation, so the model can reference previous calls.

Teams building these workflows often rely on an Agent SDK to standardize execution patterns, state handling, and tool interactions across environments.

Validating parameters before execution

Parameter validation must happen before execution as a critical security layer. Models sometimes generate invalid parameters, even when you define schemas. Implement validation using libraries like Pydantic in Python or JSON Schema validators in JavaScript. Validate types, check required fields, enforce constraints, and return structured errors when validation fails. The agent can often correct mistakes if you provide clear error messages.

Writing detailed tool descriptions

Tool descriptions deserve significant attention because the model uses them to decide when and how to use each tool. Instead of "Gets customer data," write "Retrieves customer profile including name, email, order history, and account status. Requires customer email or ID. Returns null if customer not found." Include format examples, explicit constraints, and return value descriptions.

What Should You Handle Before Going to Production?

Prompt injection and authentication

Prompt injection is a critical agent security vulnerability where attackers embed malicious instructions in data the agent processes. This can cause unintended tool execution or information leakage. Defending against it requires multiple layers. Validate inputs before they reach the model, isolate system prompts from user-provided content, and monitor for suspicious tool call sequences.

Treat agents as delegated actors using OAuth 2.0/2.1 tokens scoped to user access rights. Store credentials in secure vaults with agents retrieving tokens at runtime. This keeps the agent's access aligned with what each specific user is authorized to do.

Row-level security and access control

Enforce RLS at the database layer. Database-native Row-Level Security automatically filters data based on authenticated user context, which prevents unauthorized access even if prompt injection compromises the agent. This matters most for agents operating across multi-tenant environments where one user's query should never surface another user's data.

Restrict which agents can invoke which tools at the execution layer. For high-risk operations, implement Human-in-the-Loop approval where the agent prepares the call but pauses for user confirmation. This adds latency, so be selective about which operations require it. Log every tool call with full context to reconstruct incidents and satisfy compliance requirements.

Schema validation and tool selection failures

Even with well-defined schemas, agents occasionally generate malformed parameters or choose the wrong tool. These failures become more frequent under edge-case inputs or ambiguous queries. Return structured error messages that explain what went wrong, because agents can often self-correct on retry with clear feedback.

Infinite loops

Prevent infinite loops by implementing maximum iteration limits per tool and requiring state changes between iterations. If the agent calls the same tool repeatedly with identical parameters, force re-evaluation or fail the workflow.

Context overflow

Context overflow occurs when conversation history exceeds the model's context window, truncating earlier tool calls. Implement context summarization to compress older history while preserving essential facts. For extended workflows, use external storage to maintain execution state and selectively inject relevant portions into each model call.

Network failures

Network timeouts and API failures will happen in production. Implement retry logic with exponential backoff for transient failures and circuit breakers for consistently failing tools. Set reasonable timeout thresholds for each tool type and provide fallback responses when tools are unavailable.

Observability gaps

Debugging agent decisions requires observability beyond traditional application monitoring. Standard monitoring checks whether a service is up. Agent observability traces how the agent reasons, which tools it calls, and how its state changes during a task. Implement distributed tracing to capture every LLM call, tool invocation, and decision point so you can reconstruct why an agent produced a given output.

What's the Right Approach for Production Agent Tool Calling?

Tool calling reliability depends on what happens outside the model. Validation, security, observability, and failure handling all live in your application layer. Getting these right separates agents that work in staging from agents that hold up under real user traffic.

The harder problem is the data layer underneath your tools. Every SaaS tool has unique authentication, rate limits, and schema changes. Building those connections consumes engineering time that should go toward agent logic, For Developers, and context engineering.

Airbyte's agentic platform gives you governed agent connectors with permission-aware access, continuous data updates through incremental sync and Change Data Capture (CDC), and unified handling of structured and unstructured data. Airbyte's agentic platform also includes Context Store, which helps agents retrieve the right context from business systems through a search-optimized layer built for production data access.

Get a demo or try Airbyte's agentic platform.

Frequently Asked Questions

What's the difference between function calling and tool calling?

Most engineers use these terms interchangeably. "Function calling" was OpenAI's original terminology, while "tool calling" is now the more common industry term. Both describe models generating structured requests for external function execution.

Can agents execute tools in parallel or only sequentially?

Many frameworks support both modes. Parallel execution runs independent tools simultaneously for faster results but increases state management complexity. Sequential execution processes tools one at a time, which simplifies reasoning chains but adds latency.

How do you prevent agents from calling expensive or dangerous tools incorrectly?

Layer your defenses. Schema validation catches malformed parameters. Tool-level authorization restricts which agents can invoke which functions, while database-native RLS prevents data leakage. Human-in-the-Loop approval gates high-risk operations, and rate limiting with circuit breakers adds additional protection.

What happens when a tool call fails or times out?

Your execution layer should catch failures and return structured error messages to the agent. Implement retry logic with exponential backoff for transient failures and circuit breakers for consistently failing tools. The agent can often route around failures if you give it clear error context about what went wrong.

Do you need different observability tools for agents versus traditional applications?

Yes. Agent systems require distributed tracing that captures the full reasoning chain. You need to see which tools were considered, which were called, what parameters were generated, and how results influenced the next decision. Traditional monitoring tracks request/response metrics but misses the agent's decision-making process.