JDBC Driver for WordPress

Build 23.0.8839


Create, update, delete, and query Plugins.

Table Specific Information


The driver uses the WordPress API to process supported filters. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.

  • Plugin supports the '='.
  • Status supports the '='.
  • Context supports the '='.
The following queries are processed server side.
SELECT * FROM Plugins WHERE Plugin='hello-dolly/hello'
SELECT * FROM Plugins WHERE Status='inactive'
SELECT * FROM Plugins WHERE Context='edit'


To insert into Plugin, you must specify the Slug column.

INSERT INTO Plugins (Slug, Status) VALUES ('hello-dolly', 'active')


To update the Plugin you must specify the Plugin column.

UPDATE Plugins SET Status = 'inactive' WHERE Plugin = 'hello-dolly/hello'


To delete a Plugin you must specify the Plugin column.

DELETE FROM Plugins WHERE Plugin = 'hello-dolly/hello'


Name Type ReadOnly Description
Plugin [KEY] String True

The plugin file.

Name String True

The plugin name.

Author String True

The plugin author.

DescriptionRaw String True

The plugin description.

DescriptionRendered String True

The plugin description.

NetworkOnly Boolean True

Whether the plugin can only be activated network-wide.

RequiresPhp String True

Minimum required version of PHP.

RequiresWp String True

Minimum required version of WordPress.

Status String False

The plugin activation status.

The allowed values are inactive, active.

TextDomain String True

The plugin's text domain.

Version String True

The plugin version number.

AuthorUri String True

Plugin author's website address.

PluginUri String True

The plugin's website address.


Name Type Description
Slug String

WordPress.org plugin directory slug. This column is required for Insert only and it is not included in the Select response.

Context String

Scope under which the request is made; determines fields present in response.

The allowed values are view, edit, embed.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839