MySQL

Connect a MySQL Database to Wobby

Connect MySQL to Wobby

To connect your MySQL database to Wobby, follow these steps:

  • Create a read-only user account.

  • Grant access to the necessary databases and tables.

  • Set up the connection in the Wobby interface.

⚠️ Wobby’s agents only run read-only queries on your data. No write or administrative privileges are required.


1. Create a Read-Only User in MySQL

Create a dedicated MySQL user that Wobby will use to query your data. This user should be restricted to only what’s necessary for analysis.

-- Replace with your secure username and password
CREATE USER 'wobby_user'@'%' IDENTIFIED BY 'your_secure_password';

-- Grant usage access (no database access yet)
GRANT USAGE ON *.* TO 'wobby_user'@'%';

✅ Use a strong password and avoid reusing credentials across systems.


2. Grant Read-Only Access to Data

Decide which databases and tables Wobby should access, typically your reporting or analytics schemas.

-- Replace `your_database` and `your_table` with actual names
GRANT SELECT ON your_database.* TO 'wobby_user'@'%';

🔐 This provides Wobby read-only access to all tables in the specified database. If you want finer control, you can grant access on a per-table basis:

 SELECT ON your_database.sales_data TO 'wobby_user'@'%';
GRANT SELECT ON your_database.customer_summary TO 'wobby_user'@'%';

✅ For multi-schema environments, repeat the grant process for each schema or table Wobby needs.


  • Restrict Host Access: For added security, limit login access to specific IP ranges if your MySQL server supports it.

  • Limit Resource Usage: You can apply resource limits (like MAX_QUERIES_PER_HOUR) on the user if needed.


4. Set Up the Connection in Wobby

  1. Go to Wobby → Data Sources.

  2. Click New MySQL Connection.

  3. Fill in the following details:

    • Host: your MySQL server hostname or IP address

    • Port: default is 3306 unless changed

    • Database: the default database Wobby should use

    • Username: wobby_user

    • Password: the secure password you set

    • SSL: enable if your MySQL instance requires encrypted connections

  4. Test the connection and click Save.

📂 Wobby only queries the data the user can see—if the user doesn’t have access, Wobby won’t either.


That’s It!

Wobby is now connected to MySQL. You can start asking questions in natural language—no dashboards, no SQL—just insights.

Last updated

Was this helpful?