# ToolJet MCP for AI Agents AI Agent Connect

> ToolJet MCP lets your AI agent talk directly to your ToolJet workspace. You can query tables, add new records, and kick off workflows without leaving your chat interface. It turns your internal database into a conversational tool for quick data lookups and automated business logic.

## Overview
- **Category:** developer-tools
- **Price:** Free
- **Endpoint:** https://edge.vinkius.com/vk_preview_fZAVtt2HDxWgJpZNaxHskMSVXKTr8FTY7XLkyBKl/ai-agent-connect
- **Tags:** low-code, internal-tools, sql-query, workflow-automation, database-management, business-logic

## Description

ToolJet MCP connects your workspace to any AI agent so you can interact with your internal databases and automate business logic through natural language. Imagine you're an operations lead who needs to check order statuses or update customer records. Usually, that means logging into a dashboard, finding the right page, and clicking through several menus. This connection changes that. You can just ask your AI client to find specific data or tell it to start a new process. Instead of manual navigation, you're just describing the task. You can ask for a list of pending orders or tell the agent to add a new entry to your inventory. It handles the heavy lifting of interacting with your workspace, making your internal tools feel like a natural conversation. It's part of the Vinkius catalog, which makes it easy to plug into your existing setup. Whether you're a dev looking for a quick data check or an analyst verifying records, this connection lets you skip the UI and get straight to the results.

## Tools

### list_tables
See every table in your ToolJet Database. This helps you understand your data structure before running queries.

### query_table
Run SQL SELECT queries on your tables. Use this to filter specific records or pull insights on the fly.

### trigger_workflow
Start a ToolJet Workflow via a Webhook. You can pass custom payloads to kick off automated business processes.

### insert_row
Add a new row to a specific ToolJet Database table. This lets your agent handle data entry tasks based on your instructions.

## Prompt Examples

**Prompt:** 
```
Show me all the tables in my ToolJet workspace.
```

**Response:** 
```
I've checked your ToolJet Database. Here are the tables I can access:

* **inventory**
* **orders**
* **customers**
```

**Prompt:** 
```
Find all orders from last week that are still pending.
```

**Response:** 
```
I've run a query on your orders table. I found 4 pending orders from last week:

| Order ID | Total | Status |
| :--- | :--- | :--- |
| #1024 | $45.00 | Pending |
| #1029 | $120.50 | Pending |
| #1031 | $12.00 | Pending |
| #1035 | $89.99 | Pending |
```

**Prompt:** 
```
Start the 'Daily Cleanup' workflow with the ID 555.
```

**Response:** 
```
I've triggered the 'Daily Cleanup' workflow for you. The system confirmed the process has started successfully.
```

## Capabilities

### See your database tables
List all available tables in your ToolJet Database to understand your data structure.

### Run SQL queries
Execute SELECT queries to filter records and pull specific data points.

### Add new rows
Insert new records into your database tables using structured data.

### Start workflows
Trigger ToolJet Workflows via webhooks with custom payloads.

### Explore data via chat
Ask your agent to find, filter, or update records without leaving the interface.

## Use Cases

### The 'Where is that order?' problem
An ops person asks the agent for pending orders in a specific region. The agent uses query_table and gives a summary.

### The 'Onboarding' task
A manager tells the agent to add a new user to the system. The agent uses insert_row to update the database.

### The 'Alert' trigger
A dev tells the agent to start a cleanup process. The agent uses trigger_workflow to hit the webhook.

### The 'Data Audit'
An analyst asks the agent to list all tables to see what's available. The agent uses list_tables to show the schema.

## Benefits

- Skip the dashboard: Use query_table to get data instantly instead of navigating through complex internal UIs.
- Automated data entry: Use insert_row to let your agent handle repetitive record updates from your chat interface.
- Fast workflow execution: Use trigger_workflow to start business processes without manual clicks or tab switching.
- Better data exploration: Use list_tables to let your agent understand your entire workspace structure at a glance.
- Reduced context switching: Stay in your AI client while performing database operations and workflow triggers.

## How It Works

The bottom line is you get a conversational interface for your ToolJet database and workflows.

1. Subscribe to this Connector and provide your ToolJet API Key.
2. Enter your Host URL if you are using a self-hosted instance.
3. Ask your AI client to query tables, insert rows, or trigger workflows.

## Frequently Asked Questions

**Can the ToolJet MCP query my existing data?**
Yes, it can run SELECT queries to pull specific records or filter data from your tables using natural language.

**How do I use ToolJet MCP to add new records?**
You can just tell your agent to insert a new row, and it will handle the data entry for you based on the details you provide.

**Does the ToolJet MCP support custom workflows?**
Yes, it can trigger any ToolJet Workflow via a webhook, including custom payloads to start automated business processes.

**Is the ToolJet MCP good for data analysis?**
It's great for ad-hoc queries and quick data lookups that would otherwise require manual dashboard navigation.

**Can I use the ToolJet MCP with my own self-hosted ToolJet?**
Yes, you just need to provide your Host URL along with your API Key in the configuration.

**What kind of data can I access with ToolJet MCP?**
You can access any table and data that is currently managed within your ToolJet workspace.

**Can I perform complex SQL joins using this server?**
Yes, the `query_table` tool allows you to execute SQL queries. As long as the tables exist in your ToolJet Database and your organization ID is correct, you can perform SELECT statements including joins and filters.

**How do I trigger a specific automation I built in ToolJet?**
You can use the `trigger_workflow` tool. You will need the `workflow_id` and can optionally provide a JSON `payload` to pass data into the workflow's entry point.

**Can I see the list of all my database tables?**
Absolutely. Use the `list_tables` tool to retrieve a complete list of all tables currently configured in your ToolJet Database workspace.