FabricSQLWhitelister: MySQL Whitelist Sync for Servers

FabricSQLWhitelister moves your Minecraft whitelist into a MySQL database for centralized, multi-server control. Learn how to install it for Minecraft today.

FabricSQLWhitelister

Managing a whitelist across several Minecraft servers can quickly turn into a headache. Every server keeps its own whitelist.json, and keeping those files in sync is a manual chore. FabricSQLWhitelister solves that problem by replacing the flat-file whitelist with a MySQL database, giving you one central source of truth for who is allowed to join. Whether you run a small private SMP or a network of survival worlds, this mod is worth a closer look.

What FabricSQLWhitelister Actually Does

At its core, the mod overrides the vanilla whitelist system and reads player permissions from a MySQL table instead of the local JSON file. When a player tries to connect, the server checks the database rather than the file on disk. That means you can update access in one place and have every connected server respect the change immediately, without copying files around or restarting anything.

The mod is built for the Fabric loader and targets Minecraft 1.18.x. It requires Fabric API and Fabric Loader version 0.12.8 or newer. The author has mentioned that backports to 1.16.5 and 1.17.1 could arrive later as long-term support builds, so players on older versions should keep an eye on future updates. It has been tested primarily against MariaDB, though it should behave correctly with any conventional MySQL server.

Why Use a Database-Backed Whitelist

  • Centralized control: one table governs access across every server pointed at the same database.
  • No file syncing: no more copying whitelist.json between machines or worrying about stale copies.
  • Instant updates: adding or removing a player takes effect right away.
  • Integration friendly: because UUIDs are stored dehyphenated, it is straightforward to build companion tools that read and write the same table.

A Note on UUID Storage

If you plan to write your own application alongside the mod, keep in mind that player UUIDs are saved without hyphens. This mirrors how Mojang's REST API returns identifiers and makes it easier to develop external apps that integrate with the whitelist. It is a small detail, but one that saves a lot of debugging time.

How to Install FabricSQLWhitelister for Minecraft

Setup is straightforward, though the first boot behaves in a way that surprises new users. Follow these steps and you will be running in minutes.

  1. Install Fabric Loader 0.12.8 or newer and place Fabric API in your server's mods folder.
  2. Add the mod jar to the same folder, then start the server once. A crash on this first launch is expected, because the configuration file does not exist yet.
  3. Open the generated whitelist.toml and enter your MySQL host, port, database name, username, and password.
  4. In server.properties, set white-list=true.
  5. Restart the server. If the credentials are correct, it will start cleanly and connect to the database.

From there, manage access with the familiar /whitelist add <player> and /whitelist remove <player> commands. The difference is that every change now lands in your database instead of a local file. If you are searching for a reliable place to grab the jar, a download FabricSQLWhitelister package from a trusted mod repository is the safest route, and always match the build to your server's Minecraft version.

One behavior to be aware of: at present, the mod overrides the ability for opped players to bypass the whitelist. Operators who are not listed in the database will be turned away like anyone else, so add your admin accounts before you lock things down. The author has hinted this may change in a future patch.

Streamlining the Setup

If you would rather skip manual jar juggling, the foxygame.net launcher offers a curated add-on catalog where FabricSQLWhitelister can be installed with a single click, and it keeps version compatibility in check so your server mods stay aligned after updates.

Final Thoughts

FabricSQLWhitelister is a focused utility that does one job well: it moves whitelist management out of scattered JSON files and into a database you can query, back up, and share. For Fabric servers on Minecraft 1.18.x that already run MySQL for other plugins, it fits naturally into the existing stack. Set it up once, point your servers at the same database, and whitelist administration becomes a single, consistent task instead of a recurring chore.

===ARTICLE===