Contributors:

btk5h (Bryan Terce), FranKusmiruk, Govindas

Supported Minecraft Versions:

• 1.9, 1.10, 1.11, 1.12, 1.13, 1.14, 1.15, 1.16

Code (Text):

1. Awesome direct database access for Skript

What makes skript-db different from other SQL addons?

• Automatic SQL injection protection
• Support for connections to multiple databases
• An amazingly intuitive list variable system for reading query outputs

This is a fork of btk5h's skript-db, with these changes:

• Fixed local variables disappearance in newer Skript versions
• Thread-pool size is now configurable
• SQL driver class used is now configurable
  
• Uses a newer version of HikariCP
• Only meant to be used by newer Minecraft versions (1.8 is not supported, use original for 1.8, no bugs on 1.8)

Documentation/Source - Releases

Quickstart

Code (Text):

1. on script load:
2.   set {-sql} to the database "mysql://localhost:3306/mydatabase?user=admin&password=12345&useSSL=false"

Code (Text):

1. command /dbtest:
2.   trigger:
3.     execute "select * from table" in {-sql} and store the result in {_output::*}
4.     send "First entry in column: %{_output::columnname::1}%"

Code (Text):

1. command /insertmyprofile:
2.    trigger:
3.     execute "INSERT INTO `table` (`uuid`,`name`,`lastjoin`) VALUES (%uuid of player%,%name of player%,%rounded unix timestamp of now%) ON DUPLICATE KEY UPDATE `name`=VALUES(`name`),`lastjoin`=VALUES(`lastjoin`)" in {-sql}