Create, update, delete, and query Plugins.

Table Specific Information

Select

The connector uses the WordPress API to process supported filters. The connector processes other filters client-side within the connector.

• Plugin supports the '=' operator.
• Status supports the '=' operator.
• Context supports the '=' operator.

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'

Insert

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

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

Update

To update the Plugin, you must specify the Plugin column.

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

Delete

To delete a Plugin, you must specify the Plugin column.

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

Columns

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.

Pseudo-Columns

Name	Type	Description
Slug	String	WordPress.org plugin directory slug. This column is only required for INSERT 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.