Resource icon

Addon skript-db (Updated) 1.3.9

  • Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

Contributors
btk5h (Bryan Terce), FranKusmiruk, Govindas, TPGamesNL
Supported Minecraft Versions
  1. 1.9
  2. 1.10
  3. 1.11
  4. 1.12
  5. 1.13
  6. 1.14
  7. 1.15
  8. 1.16
  9. 1.17
  10. 1.18
  11. 1.19
Code:
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, refer to gitea for changelog and more syntaxes.
Documentation/Source - Releases

Quickstart (MySQL example, but you can also use SQLite/MariaDB/PostgreSQL)
Code:
on script load:
  set {-sql} to the database "mysql://localhost:3306/mydatabase?user=admin&password=12345&useSSL=false"

Code:
command /dbtest:
  trigger:
    execute "select * from table" in {-sql} and store the result in {_output::*}
    send "First entry in column: %{_output::columnname::1}%"
Code:
command /insertmyprofile:
   trigger:
    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}

Support
You can receive support by creating an issue at the git repository, alternatively you can receive live chat support in my Matrix chatroom.
  • Like
Reactions: pesekjan
Author
Govindas
Downloads
18,715
Views
18,715
First release
Last update
Rating
4.60 star(s) 5 ratings

Latest updates

  1. 1.3.9

    I had forgotten to post multiple new updates, so I am posting 1.3.9 now. refer to...
  2. 1.3.4

    Updated dependencies for security and performance improvement, expect better performance. I...
  3. Skript 2.6 support

    This update fixes Skript 2.6 support! Thanks to TPGamesNL for help.

Latest reviews

Hello,
sadly Skript-DB is not working with the newest Version of Skript.
Could you update it maybe?

Only works at 2.7.2 Version of Skript.
Best addon to work with relational DBMS. Thank you for support this addon
Govindas
Govindas
Thank you for the review :)
This plugin is excellent, and I hope it will continue to be updated in the future!
Govindas
Govindas
Thank you for the review, I will continue updating it whenever anything breaks as my network depends on it.
Love your addon. Using it daily :)
Keep up the work please <3
Govindas
Govindas
I am glad my addon is useful to you, thank you for the review!
Thanks for your effort to keep that addon alive! :)
Govindas
Govindas
Thank you for the review!