• READ
  • WRITE
  • MAP
  • REVIEW

How to query and update database records with your AI

Connect ToolJet to your AI client once. After that, you can talk to your databases using plain English.

Ask AI about this page

Short answer

Can I use my AI to manage ToolJet data?

Yes. Your AI can find specific rows in your tables and add new entries based on your instructions. You'll get direct access to your data through a few simple commands.

Data outcomes

What your AI accomplishes.

The AI handles the heavy lifting of data movement and retrieval.

READ

Instant data retrieval

Your AI pulls specific rows or entire tables from ToolJet. You get the exact information you asked for without writing SQL.

WRITE

New record creation

Tell your AI what to add, and it inserts a new row into your target table. This makes data entry a conversation.

MAP

Table discovery

The AI identifies which tables are available in your ToolJet environment. It knows where to look before it starts querying.

REVIEW

Human oversight

The AI presents the data it found or the details it plans to insert. You decide if the information is correct before moving forward.

The workflow

What your AI does when <the thing arrives>.

The AI translates your intent into specific database actions.

  1. Find the right table

    The AI looks through your ToolJet workspace to see what data is available to work with.

    list_tables

  2. Locate specific data

    Once it knows the table, the AI searches for the exact rows or values you mentioned.

    query_table

  3. Add new information

    The AI takes the details from your chat and creates a new entry in the database.

    insert_row

  4. Confirm the result

    The AI checks the table again to ensure the query or insertion worked as intended.

    query_table

Try it

Copy these to start.

Use these prompts to test the connection.

Starting points

These are basic examples. Swap out the table names and column details for your own.

ToolJet Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_fZAVtt2HDxWgJpZNaxHskMSVXKTr8FTY7XLkyBKl/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — ToolJet capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "tooljet-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_fZAVtt2HDxWgJpZNaxHskMSVXKTr8FTY7XLkyBKl/mcp"
    }
  }
}
Copy into chat04

  • List all the tables available in ToolJet.

  • Find the user in the 'customers' table with the email 'alex@example.com'.

  • Add a new row to the 'inventory' table for a 'Blue Widget' with a quantity of 50.

  • Show me the last five entries from the 'orders' table.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect ToolJet once, then ask.

Just follow the link to connect your account. Your credentials stay encrypted, and you can start chatting with your data immediately.

Connect ToolJet to your AI

FAQ

How this task behaves.

  • 01

    Can the AI delete records from my ToolJet tables?

    No. The current tools only allow for listing, querying, and inserting data. Deletion is not supported.

  • 02

    Can the AI update existing rows?

    No. The AI can insert new rows, but it cannot modify or update information in rows that already exist.

  • 03

    Does the AI see all my ToolJet data?

    The AI can only see the data in the tables it is permitted to access through the provided tools.

  • 04

    Do I need to write SQL to get data?

    No. You just ask for the data in plain English, and the AI handles the technical side.

  • 05

    Can the AI create new tables?

    No. The AI can only interact with tables that already exist in your ToolJet workspace.

  • More questions about ToolJet? See everything the ToolJet Connector can do

Connect ToolJet to Claude, Cursor, ChatGPT & more