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.


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?