WoW Server MCP

Read a server config file. Allowed: config.json, worldserver.conf, authserver.conf, my.ini, my.cnf

Write/overwrite entire server config file. Use update_conf_value for single settings.

Get a specific Key=Value setting from a .conf file

Update a specific Key=Value setting in a .conf file in-place. Restart server for changes to take effect.

List all files the MCP server can read/write

Create a new game account with username and password via RA command (.account create). The account can then log in to the game.

Set the GM (Game Master) security level for an account. Levels: 0=Player, 1=Moderator, 2=GameMaster, 3=Admin, 4+=Higher admin levels. Max level is 9.

Change an account's password via RA command.

Modify the Donation Points (DP / Battle Pay balance) for an account. This is the 'dp' column in the auth.account table used for the in-game store.

Add Donation Points (DP) to an account's balance. Use negative values to subtract.

List all game accounts from the auth database. Shows ID, username, GM level, DP, email, and last login.

List all characters belonging to a specific account.

Read the current MCP server config.json (database connection, RA settings, server paths)

Update specific fields in config.json. Pass a JSON object with the fields to update (supports deep merge). Example: {"database": {"password": "newpass"}}

Reset config.json to the default values from example.config.json

Execute a SELECT query on the specified database (auth, characters, or world). Returns rows as JSON. Use parameterized queries with ? placeholders.

Insert a row into a table. Provide the table name, column names, and values.

Update rows in a table. Provide SET clause values and WHERE conditions.

Delete rows from a table. ALWAYS requires a WHERE clause for safety.

Execute raw SQL on a database (for DDL, complex queries, multi-table joins, etc). Use with caution.

Test database connectivity to auth, characters, and world databases

Create a backup of the database(s) using mysqldump. Supports full database backups or specific tables with WHERE clauses (e.g. for backing up a specific account).

Fetch SmartAI rules for a given source (creature / gameobject / quest / etc.) from the `smart_scripts` table, with human-readable event_type and action_type names. Use this BEFORE filing a 'broken gossip / missing menu' bug — SmartAI event 62 (GOSSIP_SELECT) or 64 (GOSSIP_HELLO) handlers on the sour…

Full deep-dive on a creature: template (name, flags, ScriptName, gossip_menu_id), quest starter/ender rows, vendor item count, smart_scripts summary, spawn count, and creature_loot_template summary. Combines ~6-8 queries you'd otherwise run by hand. Use this as the FIRST step when investigating any …

Trace a gossip menu fully: the gossip_menu row (text_id), every option in gossip_menu_option, the existence status of each option's action_menu_id (including magic GOSSIP_OPTION_* sentinels like 1048576 = BATTLEFIELD queue), every NPC that uses this menu (via creature_template.gossip_menu_id), and a…

Generic foreign-key integrity sweep. Finds rows in `source_table.source_column` that point to a value not present in `target_table.target_column`. Use this for systematic bug-hunting: quest_objective→item_template, creature_loot_template→item_template, gossip_menu_option.action_menu_id→gossip_menu, …

Search the configured worldserver core source tree (config.core_source_path) for a ScriptName string. Returns the files + line numbers where the script is registered (and a not-found warning if absent). Use this whenever a creature/gameobject has a non-empty ScriptName before claiming its DB-level b…

Inspect any loot table row (creature_loot_template, gameobject_loot_template, item_loot_template, reference_loot_template, etc.) for an entry, classifying each row as: valid item drop / currency (negative ID) / reference (negative mincountOrRef) / missing item. Use this BEFORE claiming a chest/mob '…

Search NPCs/creatures by name or entry ID in the world database. Returns matching creature templates.

Get full creature template data by entry ID from the world database.

Update specific fields on a creature template. After updating, use RA '.reload creature_template' to apply in-game.

Search quests by name or ID in the world database.

Get full quest data by ID from world database.

Update fields on a quest template. Use RA '.reload quest_template' to apply.

Search items by name or entry ID in the world database.

Get full item data by entry ID.

Update fields on an item template. Use RA '.reload item_template' to apply.

Search gameobjects by name or entry ID in the world database.

Get server uptime and player count via RA '.server info' command.

List currently online players from the characters database.

Get database statistics: table counts, approximate row counts, and database sizes.

List all loot entries for a creature from 'creature_loot_template'. Shows item name, drop chance, and quantity range.

Add an item drop to a creature's loot table ('creature_loot_template'). Use negative chance for quest-only drops.

Remove an item from a creature's loot table ('creature_loot_template').

Find which creatures drop a specific item. Searches 'creature_loot_template' and shows creature names.

Get loot contents of an item (e.g. lockboxes, bags) from 'item_loot_template'.

Search spells by name in the 'spell_dbc' table. Useful when designing quests (spell cast objectives) or assigning auras to NPCs.

List world events from the 'game_event' table (Hallow's End, Brewfest, etc.) with active status.

Search teleport locations from 'game_tele'. Useful for finding coordinates when placing NPCs or testing quests in-game.

Spawn a creature by template entry via RA '.npc add <entry>'. The creature spawns at the position of the GM character currently selected in the worldserver console (RA has no per-call player context). A GM must be in-game at the desired location.

Delete a specific creature spawn by GUID via RA '.npc delete'. The GM must target the creature in-game, or provide the GUID.

List all spawns (instances) of a creature template entry in the world, from the 'creature' table. Shows GUID, map, coordinates, and spawn time.

List all items sold by an NPC vendor. Queries the 'npc_vendor' table.

Add an item to an NPC's vendor list in 'npc_vendor'. Use '.reload npc_vendor' or restart to apply in-game.

Remove an item from an NPC's vendor list in 'npc_vendor'. Reloads the table in-game automatically.

Set the gossip_menu_id on a creature_template. Reloads creature_template in-game.

Search gossip_menu and gossip_menu_option to see what text/options a menu has.

List all waypoints for a creature's movement path from 'waypoint_data'. Path IDs are usually the creature GUID.

Add a waypoint to a creature's movement path in 'waypoint_data'. The path_id is typically the creature's GUID.

Delete all waypoints for a creature path ID from 'waypoint_data'.

Set npcflag on a creature_template (e.g. make it a vendor, quest giver, trainer). Common flags: 1=Gossip, 2=QuestGiver, 16=Trainer, 128=Vendor, 4096=FlightMaster. Values can be combined (bitfield). Reloads template.

Duplicate an existing creature_template with a new entry ID. Great starting point for creating a new NPC based on an existing one.

Start the MySQL server using MySQL.bat. Will report if already running.

Stop the MySQL server process (taskkill). Warning: will forcefully terminate the process.

Restart MySQL server (stop then start). Wait a few seconds between stop and start.

Start the authserver (login server). Will report if already running.

Stop the authserver process.

Restart the authserver (stop then start).

Start the worldserver (game server). Will report if already running.

Stop the worldserver process.

Restart the worldserver (stop then start).

Check if MySQL, authserver, and worldserver processes are currently running. Returns PID if running.

Show which NPCs and game objects offer (start) and finish a given quest. Queries creature_queststarter, creature_questender, gameobject_queststarter, gameobject_questender.

Assign an NPC as the quest starter (giver) for a quest. Inserts into creature_queststarter and reloads.

Assign an NPC as the quest ender (turn-in NPC) for a quest. Inserts into creature_questender and reloads.

Remove an NPC from a quest starter or ender relationship.

Insert a new quest_template row. Creates a basic quest with title, level range, type, and optional reward XP/money. Returns the new quest ID. Use update_quest_template to fine-tune objectives and rewards afterward.

Delete a quest_template by ID and remove all NPC quest relations for it. Use with caution.

Show all reward items, choices, and currencies for a quest from quest_template.

Send a single command to the worldserver via Remote Access (telnet). Examples: '.server info', '.account create test test', '.reload all', '.gm on', '.additem 49623 1', '.teleport <player> <location>', '.ban account <name> <time> <reason>'. The command should include the leading dot.

Send multiple RA commands in sequence. Stops on first error. Useful for bulk operations like reloading multiple tables or creating multiple accounts.

Discover tool that scans the connected world and auth databases to find the correct column names for the current repack/expansion. It uses fuzzy matching and outputs a suggested schema_override.json file that can be used to configure the MCP server for a different WoW patch.