How to find Confluence plugins through a SQL query in the Database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Looking for a SQL query to get a list of all the user-installed plugins
Environment
Confluence Server and Datacenter
Solution
Run the following query against your Confluence database:
Postgres
SELECT filename, pluginkey FROM plugindata;
MySQL
SELECT FILENAME, PLUGINKEY FROM PLUGINDATA;- Pluginkey refers to the full plugin name;
- Filename helps you to check the version of your plugin;
Last modified on Jun 22, 2023
Powered by Confluence and Scroll Viewport.