# ToolJet MCP

> ToolJet allows your AI agent to become a backend developer for your own systems. It connects directly to internal databases so you can run SQL queries, insert records, or trigger complex business workflows—all through natural language conversation. Stop leaving the chat window to manage data; start doing it right where you are.

## Overview
- **Category:** developer-tools
- **Price:** Free
- **Tags:** low-code, internal-tools, sql-query, workflow-automation, database-management, business-logic

## Description

This MCP lets any AI client connect to your private ToolJet database and automation layer. You don't have to write code or navigate a clunky UI just to check an order status or update a customer record. Instead, you tell your agent what you need—like 'Show me all pending orders for last week'—and it handles the structured interaction with your data tables. The system executes the query and hands back clean results instantly. It also lets you kick off full business processes by triggering specific workflows, passing custom details like user IDs or product codes when needed. Because Vinkius manages this catalog connection, you get access to all these capabilities from one place, letting your agent actually perform actions on behalf of your business.

## Tools

### insert_row
Adds a completely new row of data into any specified ToolJet Database table.

### list_tables
Retrieves a list of all available tables within the connected ToolJet database for discovery.

### query_table
Executes specific SQL SELECT queries against your data to retrieve filtered records and generate insights.

### trigger_workflow
Initiates a complex ToolJet Workflow process by sending a webhook payload, starting automated business logic.

## Prompt Examples

**Prompt:** 
```
List all the tables available in my ToolJet Database.
```

**Response:** 
```
I've retrieved the tables for your workspace. You have 3 tables: 'inventory', 'orders', and 'customers'.
```

**Prompt:** 
```
Run a query to find all orders with a status of 'pending' in organization 'org_123'.
```

**Response:** 
```
Executing `query_table`... I found 2 pending orders: Order #501 (Total: $120) and Order #505 (Total: $45).
```

**Prompt:** 
```
Trigger the workflow 'wf_987' with the payload {"user_id": "123", "action": "reset"}.
```

**Response:** 
```
The workflow 'wf_987' has been triggered successfully. The response from ToolJet indicates the process has started.
```

## Capabilities

### Discover available data tables
You can ask the agent what database tables exist without knowing their names.

### Run selective data queries
The agent executes SQL SELECT statements to filter, sort, and retrieve specific records from your tables.

### Add new structured data entries
You can instruct the agent to insert brand-new rows of information into a database table using JSON details.

### Automate business processes
The agent triggers complex, multi-step workflows within ToolJet by sending a simple webhook call.

## Use Cases

### Investigating a delayed payment status
An operations manager needs to know why an order is stuck. They ask their agent, 'What are the details for pending orders in organization X?' The agent uses `query_table` and returns exactly two records with notes on the delay.

### Onboarding a new user's account data
A developer needs to manually create test accounts. They tell their agent, 'Insert a new user for Jane Doe with department Marketing.' The agent uses `insert_row` and guarantees the record is structured correctly.

### Running an end-of-month reconciliation
A data analyst needs to check if all regional dashboards are up to date. They ask their agent, 'List all available tables' first, then run a targeted `query_table` across inventory and orders to spot discrepancies.

### Resetting a client's access after departure
An ops team member needs to execute a complex off-boarding procedure. They ask their agent to 'Trigger the full user deactivation workflow for ID 501.' The agent uses `trigger_workflow` and confirms the process started successfully.

## Benefits

- Stop switching contexts. You can run complex reports or check specific records using `query_table` right inside your chat window, eliminating the need to open a separate SQL client.
- Handle routine data entry immediately. Instead of filling out a web form, you just ask your agent to use `insert_row`, providing structured JSON details for instant record creation.
- Automate entire processes from conversation. Use `trigger_workflow` to kick off complex backend logic—like sending an onboarding email or updating inventory—with a single command.
- Quickly map your data structure using `list_tables`. This lets you understand exactly what's in the database before writing any query, saving hours of guesswork.
- The whole thing works natively across multiple platforms. You connect once to Vinkius and get this powerful database access no matter which AI client you prefer.

## How It Works

The bottom line is you get structured, automated access to your business logic without writing boilerplate code.

1. First, subscribe to this MCP and provide your unique ToolJet API Key (and optional self-host URL).
2. Next, tell your AI agent what you need done—for example, 'Get me all users who signed up last month' or 'Reset the billing status for user 123'.
3. The system converts that request into a database query or workflow trigger and returns the resulting data or confirmation message to your chat.

## Frequently Asked Questions

**How does the ToolJet MCP handle sensitive data?**
The connection requires you to provide an API key for controlled access. The agent only executes commands (like `query_table` or `insert_row`) based on your explicit prompt, ensuring all operations are tracked and constrained by your setup.

**Does the ToolJet MCP support complex filters?**
Yes. When you use `query_table`, the agent generates structured SQL that supports advanced filtering, joining tables (if necessary), and sorting data to get precise results.

**Can I use this MCP if my ToolJet instance is self-hosted?**
Absolutely. The setup process allows you to provide an optional Host URL, making it compatible with your private or self-managed instances.

**What types of workflows can the ToolJet MCP trigger?**
The `trigger_workflow` tool executes any workflow defined within your ToolJet environment. These processes are limited only by the logic and steps you've built into ToolJet itself.

**Is the ToolJet MCP just for reading data?**
No, it’s far more powerful than that. You can read using `query_table`, write using `insert_row`, and automate processes using `trigger_workflow`.