What is the AI Assistant integration in wpDataTables

You have a CSV of quarterly sales sitting in your downloads folder, and instead of opening WordPress and walking through the table wizard, you ask Claude Desktop to build the table for you; it uploads the file, creates the wpDataTable, and hands back the shortcode. That is what the AI Assistant integration makes possible.

wpDataTables registers its core actions through the WordPress Abilities API and exposes them over a dedicated MCP endpoint, so an external, MCP-compatible AI client can discover and call them. This is not a built-in chat interface inside wpDataTables; there is no AI panel in the plugin and nothing to enable. The integration is the bridge, and the assistant lives outside WordPress.

This is not a built-in AI chat interface inside wpDataTables. The integration lets external MCP-compatible AI clients, like Claude Desktop, connect to your site and interact with your tables through standardized, permission-checked actions.

Table of Contents

What is the WordPress Abilities API?

The WordPress Abilities API is a WordPress project that lets plugins describe what they can do in a machine-readable way, so an AI system can discover those capabilities instead of resorting to browser automation or direct database access.

wpDataTables registers its table, chart, media, and settings actions in that registry, and each one carries its own input schema and permission check. The Abilities API describes and exposes the capability; wpDataTables still runs all of the underlying logic, validation, and licensing rules.

For technical information about the project, refer to the WordPress Abilities API repository.

What is the MCP adapter and how does wpDataTables use it?

The MCP adapter connects the Abilities API to the Model Context Protocol, translating registered abilities into tools that an AI client can call. wpDataTables registers its own MCP server on top of that adapter and exposes it at /wp-json/mcp/wpdatatables-mcp-server, which is the endpoint an MCP client connects to.

There is no Enable button; once your site meets the requirements, the server registers itself and the abilities become discoverable. For implementation details, refer to the WordPress MCP adapter repository.

Which actions can an AI assistant perform?

A connected assistant can call 23 wpDataTables actions, grouped below by what they do. Only these actions are exposed through the integration, and each one runs through its own permission and license checks.

Discovery and reading

List all wpDataTables tables on the site
Get the full configuration of a table, including columns and types
Get row data from a table, with sorting, search, and column filters
List raw database tables on a connection
Describe the schema of a single database table
Get system info: version, detected license tier, integrations, chart engines, and connections
Get the changelog for the installed version
Get the license matrix showing which actions are available on this site

Creating tables

Create a Simple table with its own cells, styling, and merged cells
Create a live table from a CSV, Excel, JSON, nested JSON, XML, or Google Sheets source
Import a CSV, Excel, or Google Sheet once into MySQL as an editable table
Create a table from a SQL SELECT query

Editing tables

Edit a table, routing automatically between Simple and standard tables
Update display and behavior settings such as sorting, filtering, pagination, and column labels
Update the styling, cells, and layout of a Simple table

Charts

List all wpDataCharts
Get the full configuration of a chart
Create a chart from an existing table
Edit an existing chart, except for its engine

Media and files

List the WordPress media library
Download an image from a URL into the media library
Upload a data file (CSV, Excel, JSON, XML) to use as a table source

Settings

Read or update global wpDataTables settings

MCP client showing the list of wpDataTables tools available to the assistant

Can an AI assistant delete my tables or edit my data rows?

No. There is no delete action of any kind in the integration; an assistant cannot remove a table, a chart, or a row, and there is no ability that deletes anything on your site. Row-level data editing is also outside the integration for database-backed tables, so an assistant cannot insert, update, or delete records in your MySQL data.

The one exception is Simple tables, whose cell contents are part of the table definition itself and can therefore be changed through the Simple table editing actions. Everything else an assistant changes is table and chart configuration, media library files, or global plugin settings.

Because the assistant can create tables, upload files, and change global settings, including custom CSS and custom JavaScript, only connect it using an account you would trust with full administrator access to the site.

Can an AI assistant run SQL queries against my database?

Only read-only SELECT queries, and only as the input to creating a table. There is no free-standing query action that returns arbitrary results to the assistant; SQL is accepted by the create a table from a SQL query action, which validates the statement and then builds a wpDataTable from it.

The validation parses the query and rejects INSERT, UPDATE, DELETE, DROP, TRUNCATE, CREATE, and ALTER, along with UNION queries and multiple statements chained with a semicolon. Subqueries and derived tables in FROM are also rejected, since wpDataTables does not support them.

To explore data without creating anything, the assistant reads existing tables instead, using the table data action with its search, column filter, and sorting parameters.

Can an AI assistant export my table data?

There is no export action that produces a file or a download. An assistant can, however, read the contents of a table and then write that data out on its own side, for example into a CSV or a spreadsheet on your computer.

For tables that do not use server-side processing, the table data action returns the full dataset in a single call; for server-side tables, it returns up to 500 rows per page, and the assistant is expected to narrow the result with search and column filters rather than page through every row. The practical effect is that an assistant can assemble an export, but wpDataTables itself is not generating an export file for it.

Which actions require a paid license?

Most actions work on any installation, including the free version, while a few follow the same license rules as the equivalent feature in the wpDataTables back end. A license-limited action still appears in the assistant’s tool list; it returns an error explaining the required tier the first time the assistant actually calls it.

Starter and above: creating a live table from a Google Sheets source
Standard and above: importing a CSV, Excel, or Google Sheet into MySQL
Standard and above: creating charts with the Highcharts or ApexCharts engines; Google Charts and Chart.js work on any tier
Standard and above: SQL queries and database discovery against a separate database connection; the WordPress database works on any tier

You do not have to work this out by hand. Ask the assistant to check the license matrix, and it will report which actions are fully supported on your specific installation and which integration files are missing.

What permissions does an AI assistant have?

The integration is administrator-only. Every one of the 23 actions, including the read-only ones, checks for the manage_options capability, so an Editor, Author, or Subscriber account cannot use the assistant to read your tables at all, let alone change them.

This is stricter than the wpDataTables back end, where lower roles can be granted access to tables; the AI integration does not offer a read-only mode for non-administrators. Requests that carry no valid credentials are rejected outright and return no data.

A connected assistant therefore has the full access of the administrator account it authenticates as, which is why the account you choose for the connection matters.

Does this integration change how I manage tables?

No. There are no changes to the table wizard, the table configuration screens, table rendering, or the query engine, and no AI chat interface is added anywhere in wpDataTables.

Tables and charts an assistant creates appear in the back end exactly as if you had built them yourself, and you can open and edit them normally. The integration only adds a second way to reach the same underlying actions.

What do I need to use this integration?

You need WordPress 6.9 or newer, since that is the version that ships the Abilities API; on older versions, wpDataTables shows an admin notice, and the MCP server does not register at all. You also need an administrator account, a WordPress application password generated from that account, and an MCP-compatible AI client such as Claude Desktop, Claude Code, or Cursor.

Nothing needs to be switched on inside wpDataTables. For the full setup, including the client configuration and troubleshooting, refer to the connecting an AI assistant to wpDataTables documentation.

Who is this integration for?

The AI Assistant integration is aimed at developers, agencies, and advanced users who want to build or manage tables from an AI client rather than from the WordPress back end. Most wpDataTables users never need to configure it, since everything it exposes is already available in the plugin’s own interface.

It becomes worthwhile when you are creating tables in bulk, working from data files that live on your computer, or building automations around wpDataTables as part of a larger workflow.