Repository navigation
Database Manager
The Database Manager page lets you browse the AzerothCore MySQL databases, run read-only queries, and trigger database backups.
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, … |
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
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, orALTER. OnlySELECTqueries are executed.
Results are returned as a JSON array of row objects.
-- 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;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
| 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 |
"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.1inside the Docker container (network_mode: hostensures 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.).