SQLiteConnectMC

Managing data on a Minecraft server often means juggling external tools, manual file edits, or complex plugins that do more than you need. SQLiteConnectMC changes that by giving you a clean, direct bridge between your server and any SQLite database. Whether you want to pull player stats, inspect economy logs, or run custom queries without ever leaving the console, this add-on makes it fast, safe, and surprisingly simple.

What Makes SQLiteConnectMC Stand Out

SQLiteConnectMC is not a bulky all-in-one management suite. It is a focused, lightweight plugin that does one thing exceptionally well: connect your Minecraft server to SQLite databases and let you interact with them in real time. You can execute queries from in-game chat or the server console, switch between multiple database files on the fly, and even spin up a password-protected web panel for remote access. All of this runs asynchronously, so your server’s main tick loop stays smooth even during heavy read operations.

Key Features at a Glance

• In-Game Query Execution: Use /sqlite query <query> to run SQL statements directly from chat or console, with results displayed instantly.
• Multiple Database Support: Configure several SQLite files and switch between them without restarting the server.
• Secure Web Panel: Enable a built-in web interface with login, session cookies, and CSRF protection for remote query access.
• Flexible Mode Switching: Choose CONSOLE_PLAYER, WEB_PANEL, or BOTH in the config to control exactly how users interact with the plugin.
• Configurable Row Limit: Set a default cap of 50 rows or remove the limit entirely by setting query.row-limit to -1.
• Async Performance: All database operations run off the main thread, preventing lag spikes.
• Fail-Safe Defaults: The plugin starts in read-only mode to avoid accidental data changes; you can enable read-write when needed.
• Automatic Config Migration: Older config files are backed up and upgraded seamlessly when you update the plugin.

Supported Platforms and Minecraft Versions

SQLiteConnectMC is built for the Bukkit ecosystem and has been tested on a wide range of server software. It works flawlessly on Bukkit, Spigot, Paper, Purpur, Folia, and Canvas. Any fork derived from these platforms should also be compatible, giving you flexibility no matter which server jar you prefer. The plugin targets modern Minecraft versions, so you can confidently use it on the latest releases without worrying about breaking changes. Always check the official documentation for the most up-to-date version compatibility details.

How to Install SQLiteConnectMC

Getting started with SQLiteConnectMC is straightforward. Follow these steps to have the plugin running in minutes:

1. Download SQLiteConnectMC: Grab the latest jar file from the official plugin page. Make sure you pick the standard release unless you specifically need the SRVBase variant (more on that later).
2. Place the Jar: Drop the downloaded file into your server’s plugins/ folder.
3. Restart the Server: A full restart is required to load the plugin and generate the default configuration.
4. Edit the Config: Open plugins/SQLiteConnectMC/config.yml and add the paths to your SQLite database files under the databases section. The plugin will automatically migrate any older config formats and create a backup.
5. Set Access Mode: Choose CONSOLE_PLAYER, WEB_PANEL, or BOTH depending on how you want to interact with the databases.
6. Create a Web Panel Login (Optional): If you enable the web panel, use /sqlite panel mail add <mail> pass set <pass> to set up credentials.
7. Reload the Plugin: Run /sqlitereload to apply all changes and start the panel if configured.

If you are using a launcher like foxygame.net, adding SQLiteConnectMC to your server is even easier. The launcher’s built-in add-on catalog lets you install SQLiteConnectMC with a single click, and it automatically handles version matching and updates so you never have to worry about compatibility or manual downloads again.

Commands and Permissions

SQLiteConnectMC keeps its command set intuitive. All commands require the sqliteconnectmc.admin permission, which defaults to server operators. Here is the full list:

• /sqlite query <query> – Execute a SQL query on the currently selected database.
• /sqlite list tables – Show all tables in the selected database.
• /sqlite list databases – List all configured database names.
• /sqlite select database <name> – Switch the active database for subsequent queries.
• /sqlite help panel – Display web panel status, URL, and account management commands.
• /sqlite panel mail add <mail> pass set <pass> – Create or reset a web panel login.
• /sqlite help – Show the in-game help menu.
• /sqlitereload – Reload the configuration and reconnect to databases without a full server restart.

Diving Deeper: The Web Panel and Security

One of SQLiteConnectMC’s most powerful features is its built-in web panel. Once enabled, it provides a lightweight, login-protected interface accessible via browser. The panel uses session cookies and CSRF checks to keep unauthorized users out. You can run queries, browse tables, and manage your databases from anywhere, making it perfect for server admins who need remote access without exposing the full console. The panel’s port and binding address are fully configurable, so you can lock it down to localhost or open it to your staff IPs.

Advanced Usage: SRVBase Releases

For users with more technical expertise, SQLiteConnectMC offers SRVBase releases. These are not the typical panel-and-console builds; instead, they expose a PostgreSQL connection and treat each configured database as a schema. This variant is ideal if you need to integrate with external tools that speak PostgreSQL or if you want to layer additional database abstraction on top of your SQLite files. However, it requires a deeper understanding of database management, so it is recommended only for advanced server administrators.

Why SQLiteConnectMC Fits Your Server

Whether you run a small community server or a large network, SQLiteConnectMC for Minecraft fills a niche that few other plugins address. It gives you direct, scriptable access to your data without forcing you to learn complex APIs or install heavy database drivers. The plugin’s asynchronous design means you can run heavy queries without affecting TPS, and the read-only default prevents accidental data corruption. If you ever need to modify data, simply flip the mode in the config and reload.

For those who manage multiple servers, the ability to switch between databases on the fly is a game-changer. You can keep separate SQLite files for different worlds, minigames, or player data stores, and query them all from a single in-game command interface. The web panel adds another layer of convenience, especially when you need to check something quickly from your phone or a remote desktop.

Getting the Most Out of SQLiteConnectMC

To truly unlock the plugin’s potential, consider pairing it with custom scripts or other plugins that generate SQLite data. For example, you could log economy transactions to a database and then use SQLiteConnectMC to generate real-time leaderboards or audit logs. The configurable row limit ensures you never accidentally flood chat with thousands of rows, but you can remove the cap entirely for automated tools that parse the output.

When you download SQLiteConnectMC, always grab the latest stable build to benefit from performance improvements and security patches. The automatic config migration means you can update without losing your settings, and the backup files give you peace of mind if you ever need to roll back.

Final Thoughts

SQLiteConnectMC is a must-have for any server owner who wants to interact with SQLite databases directly from Minecraft. Its clean command set, robust web panel, and broad platform support make it a reliable tool for both casual and advanced use. The plugin respects your server’s performance, keeps your data safe by default, and gives you the flexibility to scale from a single database to a multi-file setup. If you have ever wished you could run a quick SQL query without leaving the game, this is the add-on you have been waiting for.