Database

Before a connection string is found, the page looks like this:

Connection

K3 Studio reads mysql_connection_string from any .cfg in the folder (example files are checked last) and connects read-only by default. Queries go through a small mysql2 helper that runs with bun.

What you can do

• Schema tree of every table, with search
• Each table has Data and Structure tabs, a WHERE filter and paging
• SQL box: Ctrl+Enter runs it
• Results grid with sortable columns, Explain and Copy CSV
• Recent queries
• Safe mode: writes need the Writes switch turned on, and then a confirm for each statement

SQL everywhere

The SQL box is colored like a .sql file and suggests tables, columns and keywords as you type (Tab takes one).

.sql files are highlighted, and completion knows your schema (tables, columns, keywords). This works in the Database SQL box and inside MySQL.query / oxmysql strings in both Lua and TypeScript.