Skip to content

Database Manager

Jacob Bowen edited this page Mar 8, 2026 · 1 revision

Database Manager

The Database Manager page lets you browse the AzerothCore MySQL databases, run read-only queries, and trigger database backups.


Overview

The panel connects to three databases configured in Settings:

Database Purpose
auth Accounts, bans, realm list
world Game data (creatures, quests, items, spells, …)
characters Player characters, items, mail, guilds, …

Table Browser

Select a database from the dropdown and click a table name to browse its rows. The table browser supports:

  • Pagination — navigate large tables page by page
  • Column widths automatically sized to content
  • Row count shown at the top

This uses the endpoint:

GET /api/v1/database/table/{database}/{table_name}?page=1&per_page=50

SQL Query Console

The query console lets you run arbitrary SELECT statements against any of the three databases.

POST /api/v1/database/query

{
  "database": "world",
  "query": "SELECT entry, name, minlevel, maxlevel FROM creature_template LIMIT 20"
}

Safety: The server-side query validator rejects any statement containing INSERT, UPDATE, DELETE, DROP, TRUNCATE, or ALTER. Only SELECT queries are executed.

Results are returned as a JSON array of row objects.

Useful example queries

-- Find all creatures in Stormwind
SELECT guid, id, position_x, position_y, map
FROM creature
WHERE map = 0
LIMIT 100;

-- Find quest by partial name
SELECT ID, LogTitle, LogDescription
FROM quest_template
WHERE LogTitle LIKE '%Defias%';

-- List online characters (from characters DB)
SELECT guid, name, level, race, class, zone
FROM characters
WHERE online = 1;

-- Find all items with "Sword" in the name
SELECT entry, name, Quality, ItemLevel
FROM item_template
WHERE name LIKE '%Sword%'
ORDER BY ItemLevel DESC
LIMIT 50;

Database Backup

Click Backup Now to trigger a mysqldump of all three databases. The backup runs in the background and the result is available in the Backup-Restore page.

POST /api/v1/database/backup

API Endpoints

Method Path Description
GET /api/v1/database/tables/{database} List tables in a database
POST /api/v1/database/query Execute a read-only SQL query
GET /api/v1/database/table/{database}/{table_name} Browse a table with pagination
POST /api/v1/database/backup Trigger a database backup

Troubleshooting

"Connection failed" error

  • Verify MySQL credentials in Settings.
  • Click Test Connection for each database on the Settings page.
  • Make sure MySQL is accessible from 127.0.0.1 inside the Docker container (network_mode: host ensures this).

Query returns empty results

  • Double-check that you are querying the correct database.
  • Note that AzerothCore database names might differ if you customised them during installation (common alternatives: azerothcore_auth, auth, etc.).

Clone this wiki locally