What is MySQL Commands?
MySQL Commands is a lightweight yet powerful plugin that allows you to run any server-side command directly from your MySQL database.
It was built for use with webshops, external integrations, and custom backend systems that need to communicate with your Minecraft server in real time.
How does it work?
This plugin checks a MySQL table for new entries containing commands to be executed.
When it finds a matching row (targeted at a specific player or global), it executes the command from the console, and marks it as done = 1.
✅ Example Use Cases
id - Unique ID of the request
wait_for_player - 1 = wait until player is online, 0 = run anytime
for_uuid - Target player's UUID (can be null if wait_for_player = 0)
for_nick - Target player's name (can be null if wait_for_player = 0)
cmd - Command to execute via console
info - Optional info/description
done - Mark as completed ( done = 1)
done_timestamp - When it was done
timestamp - When the row was created
Configuration options (config.yml)
check-interval: 5 - Interval (in seconds) to check DB for new commands
check-player-by: "UUID" - "UUID" or "NAME" – how to match the player
Commands and permissions
Why use this plugin?
✅ Decouples command control from Minecraft
✅ Ideal for e-commerce / payment gateways
✅ UUID or Name-based execution
✅ Works with offline or online players
✅ Logs executions with timestamps
✅ Lightweight & easy to configure
✅ Supports modern MySQL security options (SSL & public key retrieval)
✅ Fully compatible with MySQL 8+ authentication methods
Minecraft servers using this plugin
play.aestros.cz
![[IMG]](//proxy.spigotmc.org/5f0c9c1482aae9385326f9b5576f0c0b76cda4f1/68747470733a2f2f6d636170692e75732f7365727665722f696d6167653f69703d706c61792e61657374726f732e637a267468656d653d6c69676874)
MySQL Commands is a lightweight yet powerful plugin that allows you to run any server-side command directly from your MySQL database.
It was built for use with webshops, external integrations, and custom backend systems that need to communicate with your Minecraft server in real time.
How does it work?
This plugin checks a MySQL table for new entries containing commands to be executed.
When it finds a matching row (targeted at a specific player or global), it executes the command from the console, and marks it as done = 1.
✅ Example Use Cases
- A webshop (e.g. Tebex, own e-shop, etc.) inserts a command into MySQL → the plugin executes it when the player is online
- External systems can reward players, assign ranks, send messages, or execute any command – all through a shared MySQL DB
id - Unique ID of the request
wait_for_player - 1 = wait until player is online, 0 = run anytime
for_uuid - Target player's UUID (can be null if wait_for_player = 0)
for_nick - Target player's name (can be null if wait_for_player = 0)
cmd - Command to execute via console
info - Optional info/description
done - Mark as completed ( done = 1)
done_timestamp - When it was done
timestamp - When the row was created
Configuration options (config.yml)
check-interval: 5 - Interval (in seconds) to check DB for new commands
check-player-by: "UUID" - "UUID" or "NAME" – how to match the player
Commands and permissions
- /mysqlcmds reload | Reloads config file
Permission: mysqlcmds.reload - /mysqlcmds notify | Toggles in-game notifications about executed cmds (for debug/admins)
Permission: mysqlcmds.notify
Why use this plugin?
✅ Decouples command control from Minecraft
✅ Ideal for e-commerce / payment gateways
✅ UUID or Name-based execution
✅ Works with offline or online players
✅ Logs executions with timestamps
✅ Lightweight & easy to configure
✅ Supports modern MySQL security options (SSL & public key retrieval)
✅ Fully compatible with MySQL 8+ authentication methods
Spoiler: Images
Before its done:
![[IMG]](//proxy.spigotmc.org/ce0b89b6d10d875e30efc4bbec76359fb202329c/68747470733a2f2f692e696d6775722e636f6d2f6b784b755642522e706e67)
After command execution:
![[IMG]](//proxy.spigotmc.org/24251bcc587033d1baf847223e683ccb435e0dc4/68747470733a2f2f692e696d6775722e636f6d2f71714f4b627a7a2e706e67)
Notify message (/mysqlcmds notify)
![[IMG]](//proxy.spigotmc.org/1ca7cc03aa524d1687ee8ccee7197fe6c7572170/68747470733a2f2f692e696d6775722e636f6d2f33765267526f462e706e67)
After command execution:
Notify message (/mysqlcmds notify)
Spoiler: SQL
Create table:
Add row:
Code (Text):
CREATE TABLE `mysql_cmds` (
`id` int NOT NULL AUTO_INCREMENT,
`wait_for_player` tinyint(1) NOT NULL DEFAULT '0',
`for_uuid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`for_nick` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`cmd` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`done` tinyint(1) NOT NULL DEFAULT '0',
`done_timestamp` timestamp NULL DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
)
`id` int NOT NULL AUTO_INCREMENT,
`wait_for_player` tinyint(1) NOT NULL DEFAULT '0',
`for_uuid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`for_nick` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`cmd` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
`done` tinyint(1) NOT NULL DEFAULT '0',
`done_timestamp` timestamp NULL DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
)
Code (Text):
INSERT INTO `mysql_cmds` (`id`, `wait_for_player`, `for_uuid`, `for_nick`, `cmd`, `info`, `done`, `done_timestamp`, `timestamp`) VALUES (NULL, '1', '03dea68f-c6ea-462c-91ad-cd56b4dbbb01', 'Dj_Nejk', 'lp user Dj_Nejk parent set vip', 'Set VIP rank', '0', NULL, CURRENT_TIMESTAMP);
Spoiler: config.yml
# ︽︽ If any new settings are added in future updates, they will appear at the top of the configuration file automatically. ︽︽
config-version: 1.12.0
debug: false
# /$$ /$$ /$$$$$$ /$$$$$$ /$$ /$$$$$$ /$$
#| $$$ /$$$ /$$__ $$ /$$__ $$| $$ /$$__ $$ | $$
#| $$$$ /$$$$ /$$ /$$| $$ \__/| $$ \ $$| $$ | $$ \__/ /$$$$$$ /$$$$$$/$$$$ /$$$$$$/$$$$ /$$$$$$ /$$$$$$$ /$$$$$$$ /$$$$$$$
#| $$ $$/$$ $$| $$ | $$| $$$$$$ | $$ | $$| $$ | $$ /$$__ $$| $$_ $$_ $$| $$_ $$_ $$ |____ $$| $$__ $$ /$$__ $$ /$$_____/
#| $$ $$$| $$| $$ | $$ \____ $$| $$ | $$| $$ | $$ | $$ \ $$| $$ \ $$ \ $$| $$ \ $$ \ $$ /$$$$$$$| $$ \ $$| $$ | $$| $$$$$$
#| $$\ $ | $$| $$ | $$ /$$ \ $$| $$/$$ $$| $$ | $$ $$| $$ | $$| $$ | $$ | $$| $$ | $$ | $$ /$$__ $$| $$ | $$| $$ | $$ \____ $$
#| $$ \/ | $$| $$$$$$$| $$$$$$/| $$$$$$/| $$$$$$$$ | $$$$$$/| $$$$$$/| $$ | $$ | $$| $$ | $$ | $$| $$$$$$$| $$ | $$| $$$$$$$ /$$$$$$$/
#|__/ |__/ \____ $$ \______/ \____ $$$|________/ \______/ \______/ |__/ |__/ |__/|__/ |__/ |__/ \_______/|__/ |__/ \_______/|_______/
# /$$ | $$ \__/
# | $$$$$$/
# \______/
# MySQL Commands plugin by DjDevs.eu (@djnejk)
##############################################
# MySQL database connection creditals:
mysql:
host: "localhost" # MySQL server address
port: 3306 # MySQL server port
database: "minecraft" # Database name
username: "root" # Database username
password: "password" # Database password
ssl: false # Enable SSL/TLS encryption for the MySQL connection
allow-public-key-retrieval: false # Allow public key retrieval (required for MySQL 8 with caching_sha2_password when SSL is disabled)
table-name: "mysql_cmds" # Table used to store commands
##############################################
##############################################
# Checking interval for incoming commands:
check-interval: 5 # (Every 5 second)
##############################################
##############################################
# Checking incoming rows in DB for user by UUID or his Name:
check-player-by: "UUID" # (UUID/NAME)
##############################################
##############################################
# Messages:
# Prefix using placeholder {prefix}
prefix: "&8[&4&l{#55ff55}M{#55ff80}y{#55ffaa}S{#55ffd5}Q{#55ffff}L{#ffffff}C{#e3e3e3}m{#c6c6c6}d{#aaaaaa}s&8]"
reload-message: "{prefix} &8» &a✅ MySQL Commands plugin has been reloaded."
nopermission-message: "{prefix} &8» &c❌ You don't have permission."
reload-use-message: "{prefix} &8» &7Usage: &f/mysqlcmds reload"
notify-use-message: "{prefix} &8» &7Usage: &f/mysqlcmds notify"
notify-message: "{prefix} &8» &7Command executed for player &f{player}&7:\n&f{plaincmd}\n&7 " # (Placeholders: {player} - player name, {uuid} - player uuid, {cmd} - command, {plaincmd} - command in plain text => things like &, {#00ff00}, ... will be displayed)
notify-console-message: "Command executed for player {player}: {plaincmd}" # (Placeholders: {player} - player name, {uuid} - player uuid, {plaincmd} - command in plain text => things like &, {#00ff00}, ... will be displayed)
notify-enable: "{prefix} &8» &7Notifications have been &2enabled&7."
notify-disable: "{prefix} &8» &7Notifications have been &4disabled&7."
##############################################
##############################################
# List (local database) of players who receive notifications using /mysqlcmds notify
notify-users: []
##############################################
Code (Text):
# ︽︽ If any new settings are added in future updates, they will appear at the top of the configuration file automatically. ︽︽
config-version: 1.12.0
debug: false
# /$$ /$$ /$$$$$$ /$$$$$$ /$$ /$$$$$$ /$$
#| $$$ /$$$ /$$__ $$ /$$__ $$| $$ /$$__ $$ | $$
#| $$$$ /$$$$ /$$ /$$| $$ \__/| $$ \ $$| $$ | $$ \__/ /$$$$$$ /$$$$$$/$$$$ /$$$$$$/$$$$ /$$$$$$ /$$$$$$$ /$$$$$$$ /$$$$$$$
#| $$ $$/$$ $$| $$ | $$| $$$$$$ | $$ | $$| $$ | $$ /$$__ $$| $$_ $$_ $$| $$_ $$_ $$ |____ $$| $$__ $$ /$$__ $$ /$$_____/
#| $$ $$$| $$| $$ | $$ \____ $$| $$ | $$| $$ | $$ | $$ \ $$| $$ \ $$ \ $$| $$ \ $$ \ $$ /$$$$$$$| $$ \ $$| $$ | $$| $$$$$$
#| $$\ $ | $$| $$ | $$ /$$ \ $$| $$/$$ $$| $$ | $$ $$| $$ | $$| $$ | $$ | $$| $$ | $$ | $$ /$$__ $$| $$ | $$| $$ | $$ \____ $$
#| $$ \/ | $$| $$$$$$$| $$$$$$/| $$$$$$/| $$$$$$$$ | $$$$$$/| $$$$$$/| $$ | $$ | $$| $$ | $$ | $$| $$$$$$$| $$ | $$| $$$$$$$ /$$$$$$$/
#|__/ |__/ \____ $$ \______/ \____ $$$|________/ \______/ \______/ |__/ |__/ |__/|__/ |__/ |__/ \_______/|__/ |__/ \_______/|_______/
# /$$ | $$ \__/
# | $$$$$$/
# \______/
# MySQL Commands plugin by DjDevs.eu (@djnejk)
##############################################
# MySQL database connection creditals:
mysql:
host: "localhost" # MySQL server address
port: 3306 # MySQL server port
database: "minecraft" # Database name
username: "root" # Database username
password: "password" # Database password
ssl: false # Enable SSL/TLS encryption for the MySQL connection
allow-public-key-retrieval: false # Allow public key retrieval (required for MySQL 8 with caching_sha2_password when SSL is disabled)
table-name: "mysql_cmds" # Table used to store commands
##############################################
##############################################
# Checking interval for incoming commands:
check-interval: 5 # (Every 5 second)
##############################################
##############################################
# Checking incoming rows in DB for user by UUID or his Name:
check-player-by: "UUID" # (UUID/NAME)
##############################################
##############################################
# Messages:
# Prefix using placeholder {prefix}
prefix: "&8[&4&l{#55ff55}M{#55ff80}y{#55ffaa}S{#55ffd5}Q{#55ffff}L{#ffffff}C{#e3e3e3}m{#c6c6c6}d{#aaaaaa}s&8]"
reload-message: "{prefix} &8» &a✅ MySQL Commands plugin has been reloaded."
nopermission-message: "{prefix} &8» &c❌ You don't have permission."
reload-use-message: "{prefix} &8» &7Usage: &f/mysqlcmds reload"
notify-use-message: "{prefix} &8» &7Usage: &f/mysqlcmds notify"
notify-message: "{prefix} &8» &7Command executed for player &f{player}&7:\n&f{plaincmd}\n&7 " # (Placeholders: {player} - player name, {uuid} - player uuid, {cmd} - command, {plaincmd} - command in plain text => things like &, {#00ff00}, ... will be displayed)
notify-console-message: "Command executed for player {player}: {plaincmd}" # (Placeholders: {player} - player name, {uuid} - player uuid, {plaincmd} - command in plain text => things like &, {#00ff00}, ... will be displayed)
notify-enable: "{prefix} &8» &7Notifications have been &2enabled&7."
notify-disable: "{prefix} &8» &7Notifications have been &4disabled&7."
##############################################
##############################################
# List (local database) of players who receive notifications using /mysqlcmds notify
notify-users: []
##############################################
Minecraft servers using this plugin
play.aestros.cz
Quick facts
- Edition: Minecraft Java
- File type: .jar
- Minecraft versions listed: 1.21, 26.1
- How to install: Install the matching mod loader (Forge, Fabric or NeoForge) for your Minecraft version. → Download the .jar. → Put it in the .minecraft/mods folder and launch that loader profile.
- Where to get it: Opens on Spigot — not every file is mirrored on our own servers.
Install steps are the general flow for this file type — How to install Minecraft Java mods & modpacks walks through it step by step.
MySQL Commands is a free Minecraft Java mod. Compatible with Minecraft 1.21, 26.1. Downloaded 169 times (via Spigot). Download it and open it directly in the game.