Connect to a private mysql instance from your favorite IDE
hoop connect <connection-name>
.Feature | Native | One Off | Description |
---|---|---|---|
TLS Termination Proxy | *partial | The local proxy terminates the connection with TLS, enabling the connection with the remote server to be TLS encrypted. | |
Audit | The gateway stores and audits the queries being issued by the client. | ||
Data Masking (Google DLP) | A policy can be enabled to mask sensitive fields dynamically when performing queries in the database. | ||
Data Masking (MS Presidio) | A policy can be enabled to mask sensitive fields dynamically when performing queries in the database. | ||
Credentials Offload | The user authenticates via SSO instead of using database credentials. | ||
Interactive Access | Interactive access is available when using an IDE or connecting via a terminal to perform analysis exploration. |
Name | Type | Required | Description |
---|---|---|---|
HOST | env-var | yes | The IP or Host of the MySQL server |
PORT | env-var | yes | The port of the MySQL server |
USER | env-var | yes | The user to connect in the MySQL server |
PASS | env-var | yes | The password to connect to the MySQL server |
DB | env-var | yes | The name of the database to connect (Required when using the connection via the command line). |
PRE_SQL_SCRIPT_FILE | filesystem | no | Append a custom SQL script at the beginning of the execution. |
SET NAMES
statement before your query:
--default-character-set
option when creating the connection.
This requires updating the default command attribute:
PRE_SQL_SCRIPT_FILE
environment variable allows you to automatically execute SQL commands at the beginning of each session:
hoophq/hoopdev
imageutf8mb4
- Full UTF-8 support (recommended for most applications)latin1
- Default charset in older MySQL versionsascii
- Basic ASCII character set