How to Use the ToolJet MCP in OpenAI Agents SDK

Q: What is the best practice for querying data using ToolJet and OpenAI Agents SDK?

Always start by listing the tables. Call listtables first to confirm the exact table name, then use that information in your querytable call. This minimizes guesswork for the agent.

Q: Does ToolJet support transactional updates with OpenAI Agents SDK?

The server provides explicit tools like insertrow. You manage the transaction logic within the agent's workflow, calling these tools in sequence to ensure all steps complete successfully or fail cleanly.

Manage database actions and automate workflows with the OpenAI Agents SDK.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect ToolJet MCP to OpenAI Agents SDK

Create your Vinkius account to connect ToolJet to OpenAI Agents SDK and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup ToolJet with OpenAI Agents SDK

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Query ToolJet Database Tables

Need to pull specific records? Just call `query_table` and get a direct result set. The agent handles complex filtering, letting you select exactly what you need from the database. It's perfect for initial data gathering. You can check schemas using `list_tables` first, making sure your query targets the right source before running a SELECT statement.

Insert New Records into ToolJet

When an action completes successfully, you don't want to just print it—you gotta write it somewhere. Use `insert_row` to put structured data right back into the database table. The agent takes your validated output and commits it as a new record, treating the database like another endpoint in your production stack.

Automate Processes with Workflows

The process doesn't stop at the database. `trigger_workflow` lets you kick off an entire backend process just by calling a tool. It's like hitting a button on a complex CI/CD pipeline. You use this when data changes require more than just reading or writing—it needs external systems to react, and your agent handles that handoff.

Setup guide

Set up ToolJet MCP in OpenAI Agents SDK

Prerequisites

Python 3.10+ installed
openai-agents package (pip install openai-agents)
Active Vinkius subscription with a valid endpoint token

1

Install the SDK

Run pip install openai-agents to install the OpenAI Agents SDK. The MCP integration is built-in — no extra dependencies needed.
2

Connect via SSE transport

Use MCPServerSse with your Vinkius endpoint URL. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. The SDK auto-discovers all ToolJet tools at runtime.
3

Create your Agent

Pass the MCP to Agent(mcp_servers=[server]). The agent receives ToolJet tools as native definitions — JSON schemas resolve automatically.
4

Run the agent

Call Runner.run(agent, prompt) to execute. The agent invokes the appropriate ToolJet tools and returns structured results. Copy the full example on the right to get started.

agent.py

import asyncio
from agents import Agent, Runner
from agents.mcp import MCPServerSse

async def main():
    async with MCPServerSse(
        url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    ) as server:
        agent = Agent(
            name="ToolJet Agent",
            instructions="You have access to ToolJet tools.",
            mcp_servers=[server],
        )
        result = await Runner.run(agent, "List recent transactions")
        print(result.final_output)

asyncio.run(main())

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by ToolJet. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect ToolJet now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about ToolJet MCP in OpenAI Agents SDK

The agents auto-discover the available tools, making it straightforward. You define guardrails around your agent's actions, ensuring that any call to `query_table` or `insert_row` adheres to defined safety constraints before execution.

Yes. The MCP Server architecture means your agent can interact with this database server, while also potentially calling other external APIs or specialized agents you've built into the system.

Always start by listing the tables. Call `list_tables` first to confirm the exact table name, then use that information in your `query_table` call. This minimizes guesswork for the agent.

The server provides explicit tools like `insert_row`. You manage the transaction logic within the agent's workflow, calling these tools in sequence to ensure all steps complete successfully or fail cleanly.

This server manages structured relational data stored in a database table, allowing operations like reading rows and inserting new records based on defined schema types.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript