[Release] SQLWorkbench - In-game SQLite & MySQL database viewer

Last read Never

🖥️ SQLWorkbench 🖥️

This tool is an in-game SQLite & MySQL database interface for Garry's Mod.

Using this tool, you can manage your server's local SQLite database (garrysmod/sv.db) and any remote MySQL databases you desire to connect to.

───────────────────────────────────────────────────────────────

Only super admins can use SQLWorkbench.

To connect to MySQL databases, your server must have the MySQLOO module installed.

───────────────────────────────────────────────────────────────

To open the menu, first make sure you are a super admin, and then either:

───────────────────────────────────────────────────────────────

Interface with remote MySQL servers
Interface with server's local SQLite database
Execute SQL queries
SQL beautifier
SQL syntax highlighting
Basic live SQL autocompletion
Supports multiple simultaneous MySQL connections
Tabbed view of each connection
View results of SQL queries
All actions are logged to the server's console
Automatic presets for SELECT, UPDATE, DELETE and INSERT statements
MySQL passwords are Vernam-cipher encrypted before being sent to the server (better than nothing, right?)
MySQL password field is masked unless hovered
Shows query execution times
Menu can be minimized and opened in the same state later on
CREATE TABLE statement retrieval
Icon differentiation for empty tables and populated tables
Table row deletion
Table row updating
Table deletion
Table emptying
Internally uses prepared statements and appropriate escaping to prevent SQL injection
Discards net messages sent by non-super-admins to prevent exploitation
Discards net messages sent by players who do not have the SQLWorkbench menu open to prevent exploitation
Menu elements can be dragged and sized to your liking
Primary key columns are highlighted in yellow
Uses the Ace embedded code editor, and works offline without a need for JavaScript CDNs