# Information Schema ALL\_PLUGINS Table

## Description

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `ALL_PLUGINS` table contains information about [server plugins](/docs/server/reference/plugins.md), whether installed or not.

It contains the following columns:

<table data-header-hidden="false" data-header-sticky><thead><tr><th>Column</th><th>Description</th></tr></thead><tbody><tr><td>PLUGIN_NAME</td><td>Name of the plugin.</td></tr><tr><td>PLUGIN_VERSION</td><td>Version from the plugin's general type descriptor.</td></tr><tr><td>PLUGIN_STATUS</td><td>Plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETED or NOT INSTALLED.</td></tr><tr><td>PLUGIN_TYPE</td><td>Plugin type; STORAGE ENGINE, INFORMATION_SCHEMA, AUTHENTICATION, REPLICATION, DAEMON or AUDIT.</td></tr><tr><td>PLUGIN_TYPE_VERSION</td><td>Version from the plugin's type-specific descriptor.</td></tr><tr><td>PLUGIN_LIBRARY</td><td>Plugin's shared object file name, located in the directory specified by the <a href="/pages/xrSGScA0IcbzH0p9P6k8#plugin_dir">plugin_dir</a> system variable, and used by the <a href="/pages/SKUQBnv7kLk3GoYGF4HQ">INSTALL PLUGIN</a> and <a href="/pages/3F4i3fyYrxH3kzKTSLQ2">UNINSTALL PLUGIN</a> statements. NULL if the plugin is complied in and cannot be uninstalled.</td></tr><tr><td>PLUGIN_LIBRARY_VERSION</td><td>Version from the plugin's API interface.</td></tr><tr><td>PLUGIN_AUTHOR</td><td>Author of the plugin.</td></tr><tr><td>PLUGIN_DESCRIPTION</td><td>Description.</td></tr><tr><td>PLUGIN_LICENSE</td><td>Plugin's licence.</td></tr><tr><td>LOAD_OPTION</td><td>How the plugin was loaded; one of OFF, ON, FORCE or FORCE_PLUS_PERMANENT. See <a href="/pages/supdhvkisHlRkiVk4061#installing-plugins">Installing Plugins</a>.</td></tr><tr><td>PLUGIN_MATURITY</td><td>Plugin's maturity level; one of Unknown, Experimental, Alpha, Beta,'Gamma, and Stable.</td></tr><tr><td>PLUGIN_AUTH_VERSION</td><td>Plugin's version as determined by the plugin author. An example would be '0.99 beta 1'.</td></tr></tbody></table>

It provides a superset of the information shown by the [SHOW PLUGINS SONAME](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-plugins-soname.md) statement, as well as the [information\_schema.PLUGINS](/docs/server/reference/system-tables/information-schema/information-schema-tables/plugins-table-information-schema.md) table. For specific information about storage engines (a particular type of plugin), see the [Information Schema ENGINES table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-engines-table.md) and the [SHOW ENGINES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-engines.md) statement.

The table is not a standard Information Schema table, and is a MariaDB extension.

## Example

```sql
SELECT * FROM information_schema.all_plugins\G
*************************** 1. row ***************************
           PLUGIN_NAME: binlog
        PLUGIN_VERSION: 1.0
         PLUGIN_STATUS: ACTIVE
           PLUGIN_TYPE: STORAGE ENGINE
   PLUGIN_TYPE_VERSION: 100314.0
        PLUGIN_LIBRARY: NULL
PLUGIN_LIBRARY_VERSION: NULL
         PLUGIN_AUTHOR: MySQL AB
    PLUGIN_DESCRIPTION: This is a pseudo storage engine to represent the binlog in a transaction
        PLUGIN_LICENSE: GPL
           LOAD_OPTION: FORCE
       PLUGIN_MATURITY: Stable
   PLUGIN_AUTH_VERSION: 1.0
*************************** 2. row ***************************
           PLUGIN_NAME: mysql_native_password
        PLUGIN_VERSION: 1.0
         PLUGIN_STATUS: ACTIVE
           PLUGIN_TYPE: AUTHENTICATION
   PLUGIN_TYPE_VERSION: 2.1
        PLUGIN_LIBRARY: NULL
PLUGIN_LIBRARY_VERSION: NULL
         PLUGIN_AUTHOR: R.J.Silk, Sergei Golubchik
    PLUGIN_DESCRIPTION: Native MySQL authentication
        PLUGIN_LICENSE: GPL
           LOAD_OPTION: FORCE
       PLUGIN_MATURITY: Stable
   PLUGIN_AUTH_VERSION: 1.0
*************************** 3. row ***************************
           PLUGIN_NAME: mysql_old_password
        PLUGIN_VERSION: 1.0
         PLUGIN_STATUS: ACTIVE
           PLUGIN_TYPE: AUTHENTICATION
   PLUGIN_TYPE_VERSION: 2.1
        PLUGIN_LIBRARY: NULL
PLUGIN_LIBRARY_VERSION: NULL
         PLUGIN_AUTHOR: R.J.Silk, Sergei Golubchik
    PLUGIN_DESCRIPTION: Old MySQL-4.0 authentication
        PLUGIN_LICENSE: GPL
           LOAD_OPTION: FORCE
       PLUGIN_MATURITY: Stable
   PLUGIN_AUTH_VERSION: 1.0
...
*************************** 104. row ***************************
           PLUGIN_NAME: WSREP_MEMBERSHIP
        PLUGIN_VERSION: 1.0
         PLUGIN_STATUS: NOT INSTALLED
           PLUGIN_TYPE: INFORMATION SCHEMA
   PLUGIN_TYPE_VERSION: 100314.0
        PLUGIN_LIBRARY: wsrep_info.so
PLUGIN_LIBRARY_VERSION: 1.13
         PLUGIN_AUTHOR: Nirbhay Choubey
    PLUGIN_DESCRIPTION: Information about group members
        PLUGIN_LICENSE: GPL
           LOAD_OPTION: OFF
       PLUGIN_MATURITY: Stable
   PLUGIN_AUTH_VERSION: 1.0
*************************** 105. row ***************************
           PLUGIN_NAME: WSREP_STATUS
        PLUGIN_VERSION: 1.0
         PLUGIN_STATUS: NOT INSTALLED
           PLUGIN_TYPE: INFORMATION SCHEMA
   PLUGIN_TYPE_VERSION: 100314.0
        PLUGIN_LIBRARY: wsrep_info.so
PLUGIN_LIBRARY_VERSION: 1.13
         PLUGIN_AUTHOR: Nirbhay Choubey
    PLUGIN_DESCRIPTION: Group view information
        PLUGIN_LICENSE: GPL
           LOAD_OPTION: OFF
       PLUGIN_MATURITY: Stable
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/all-plugins-table-information-schema.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.