Skip to main content
Documentation menu
LPC Pro · Configuration

Database

Documents LPC Pro 4.0.0 · mirrored from the product wiki, updated 2026-02-07 · GitBook version

LPC Pro stores player data, mutes, warnings, reputation, chat logs, and more in a database. Configuration is in database.yml.

SQLite (Default)

SQLite requires zero configuration. Data is stored in a local lpcpro.db file inside the plugin folder.

type: local

This is the recommended option for single servers.

MySQL / MariaDB

For larger servers or BungeeCord/Velocity networks, use a remote MySQL/MariaDB database:

type: remote

host: localhost:3306
database: lpcpro
username: your_username
password: your_password

Requirements

  • MySQL 8.0+ or MariaDB 10.3+
  • Collation: utf8mb4_unicode_520_ci (required for emoji and unicode support)

Creating the Database

CREATE DATABASE lpcpro
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_520_ci;

LPC Pro will automatically create all required tables on startup.

Connection String

For advanced users, you can customize the JDBC connection string:

jdbc:{driver}://{host}/{database}?autoReconnect=true&characterEncoding=UTF-8&tcpKeepAlive=true&useSSL=false

LPC Pro uses HikariCP for connection pooling, which handles reconnection automatically.

database.yml does not support reloading. Any changes require a full server restart.

Data Stored

The following data is persisted in the database:

Table Purpose
lpcpro_channels Custom chat channel definitions
lpcpro_player_channels Channel membership and modes
lpcpro_ignored_players Player ignore lists
lpcpro_mutes Active and expired mutes
lpcpro_warnings Player warnings
lpcpro_player_notes Staff notes on players
lpcpro_reputation Reputation scores
lpcpro_reputation_log Reputation transaction log
lpcpro_reports Chat reports
lpcpro_polls Poll data
lpcpro_poll_votes Poll vote records
lpcpro_offline_messages Messages for offline players
lpcpro_player_settings Per-player settings (color, toggles)
lpcpro_chat_logs Chat message log
lpcpro_chat_stats Player chat statistics (message counts, mentions, replies)
lpcpro_achievements Unlocked achievements per player
lpcpro_quick_replies Saved quick reply messages
lpcpro_newcomer Newcomer tracking (playtime, message count)
lpcpro_shop_purchases Shop item purchase records
lpcpro_shop_points Player shop currency balances
lpcpro_mail Mail messages between players
lpcpro_player_language Player language preferences for translation

Ready to run it? Get LPC ProAI moderation, MiniMessage, Discord, chat bubbles, games & more — one chat plugin.

Database · LPC Pro Minecraft plugin docs | InfinitePlugins