Skip to main content
QueryBox supports MySQL databases through a native driver plugin. Connect to local or remote MySQL servers using basic authentication or custom connection strings.

​
Connection Methods

Configure your MySQL connection using individual parameters:
​
host
string
required
MySQL server hostname or IP addressDefault: 127.0.0.1
​
port
number
MySQL server portDefault: 3306
​
user
string
Database usernameDefault: root
​
password
string
Database password
​
database
string
Database name to connect to
​
tls
string
TLS mode for secure connectionsOptions: skip-verify, true, false, preferredDefault: skip-verify
​
params
string
Additional connection parametersExample: charset=utf8&parseTime=true

​
Connection String Examples

​
Local Development

root:@tcp(127.0.0.1:3306)/mydb

​
Remote Server with TLS

user:pass@tcp(mysql.example.com:3306)/production?tls=true

​
Custom Charset and Timezone

app_user:secret@tcp(10.0.1.5:3306)/app_db?charset=utf8mb4&parseTime=true&loc=UTC

​
Supported Features

SQL Queries

Execute SELECT, INSERT, UPDATE, DELETE statements

Query Explanation

Analyze query execution plans with EXPLAIN

Database Browser

Browse databases, tables, and schemas visually

DDL Operations

Create and drop databases and tables

​
Capabilities

  • Query Execution: Run arbitrary SQL queries and view results
  • Explain Query: Prefix queries with EXPLAIN to analyze execution plans
  • Connection Tree: Browse all databases and tables with expandable tree view
  • DDL Actions: Create/drop databases and tables directly from the UI
  • TLS Support: Connect securely using embedded root certificates

​
Notes

The MySQL driver automatically applies a 5-second connection timeout to prevent hanging connections.
When using tls=skip-verify, certificate validation is bypassed. Use tls=true for production environments with valid certificates.

​
Plugin Information

  • Version: 0.1.0
  • License: GPL-2.0
  • Author: Oracle
  • Tags: sql, relational