Subscribe to download
SQLWorkbench - In-game SQLite & MySQL database viewer

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[github.com] installed.

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

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

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

• 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[ace.c9.io], and works offline without a need for JavaScript CDNs

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

https://github.com/WilliamVenner/SQLWorkbench