SQLWorkbench - In-game SQLite & MySQL database viewer

🖥️ 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.

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

👉 Requirements 👈

Only super admins can use SQLWorkbench.

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

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

⚙️ Usage ⚙️

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

• Type !sqlworkbench in chat
• Type sqlworkbench in your game's console

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

⚡ Features ⚡

• 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

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

🤖 GitHub 🤖

https://github.com/WilliamVenner/SQLWorkbench