kangarko/database
projects/chatcontrol/skills/database/SKILL.md
Troubleshooting database connections, encoding, migration, and data persistence
data-ai
Updated Apr 18, 2026
$ install --global
skillsauthnpx skillsauth add kangarko/ai-support databaseInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 18, 2026, 7:27 AM17.2s1 file scanned
SKILL.md
- name:
- database
- description:
- Troubleshooting database connections, encoding, migration, and data persistence
Database Troubleshooting
Diagnostic Flow — "Database error / data lost"
- Check
database.ymlType/Host/Database/User/Password - For MySQL: database must exist (created manually), user needs full permissions
- Check console for connection errors or slow warnings
Common Mistakes
- MySQL must use
utf8mb4_unicode_520_cicollation — other collations break unicode/emoji characters. CheckcharacterEncoding=UTF-8in connection string - Connections >100ms are logged as warnings — causes proxy server-switch delays. Co-locate MySQL server or switch to SQLite for single-server setups
CLEAR_DATA_IF_INACTIVEsilently purges data — players who haven't been online for the configured period lose all data (tags, channels, ignore lists, etc.). Users report "player data disappeared" — check this setting- Nick column is indexed for
/realnamelookups — database-level optimization. Not user-facing but relevant for slow/realnamequeries - Migrator auto-migrates SQLite→MySQL on startup — changing Type from
localtoremotetriggers automatic migration. Monitor console for progress - Multiple PlayerCache entries = bug indicator — if console logs warn about duplicate PlayerCache entries, it indicates a synchronization bug
Related Skills
kangarko/snowmen
development
VerifiedTrustedCommunity
Troubleshooting snowman protection, Psycho hostile snowmen, and mob transformation
SKILL.mdUpdated Apr 18, 2026
kangarko/snow-weather
data-ai
VerifiedTrustedCommunity
Troubleshooting snow particles, terrain generation, weather control, and performance issues
SKILL.mdUpdated Apr 18, 2026
kangarko/commands
tools
VerifiedTrustedCommunity
Troubleshooting Winter commands and platform compatibility
SKILL.mdUpdated Apr 18, 2026
kangarko/chests
content-media
VerifiedTrustedCommunity
Troubleshooting Gift, Dated, and Timed chest issues
SKILL.mdUpdated Apr 18, 2026