MariaDB
Connect MariaDB to Wobby
Connect MariaDB to Wobby
To connect your MariaDB instance to Wobby, follow these steps:
Create a dedicated read-only user.
Grant access to the necessary databases or tables.
Optionally configure SSL for secure connections.
Set up the connection in the Wobby interface.
⚠️ Wobby’s agents only run read-only queries on your data. No write or admin permissions are required.
1. Create a Read-Only User in MariaDB
We recommend creating a separate technical user for Wobby with read-only permissions.
sqlKopiërenBewerken-- Replace with your actual database and secure password
CREATE USER 'wobby_user'@'%' IDENTIFIED BY '<your_secure_password>';
-- Grant minimal access to the database
GRANT SELECT ON your_database.* TO 'wobby_user'@'%';
-- Apply changes
FLUSH PRIVILEGES;
✅ This user will only be able to read from the specified database. You can further restrict access to individual tables if needed.
2. Optional: Enable SSL (Recommended)
If your MariaDB instance enforces or supports SSL connections, you can configure Wobby to use SSL parameters.
To enable SSL:
Ensure your MariaDB server is configured with SSL certificates.
Allow SSL for the Wobby user:
sqlKopiërenBewerken-- Enforce SSL for the user (optional)
REQUIRE SSL;
In the Wobby interface, enable "Use SSL" and upload the required certificates (CA cert, client cert, client key) if needed.
🔐 SSL is not required by default, but recommended for production environments to secure data in transit.
3. Set Up the Connection in Wobby
Go to Wobby → Data Sources.
Click New MariaDB Connection and fill in the following fields:
Host: Your MariaDB server address
Port: Usually
3306
Database: The name of the database you granted access to
Username:
wobby_user
Password: The one you set earlier
Use SSL: Optional, if your server supports/enforces it
Click Test Connection and then Save.
📂 Wobby will only be able to access the data that wobby_user
has permission to read.
That’s It!
Wobby is now connected to MariaDB and can start analyzing your data using natural language—no dashboards, no SQL, just answers.
Last updated
Was this helpful?