Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.bondata.ai/llms.txt

Use this file to discover all available pages before exploring further.

MariaDB is a community-driven, open-source relational database forked from MySQL, offering enhanced performance and additional storage engines. With BonData, you can connect directly to your MariaDB database to read, enrich, and act on your data within Agent workflows.

​
Database Connection

BonData connects directly to your MariaDB database using standard connection credentials. MariaDB is fully compatible with MySQL, so the setup process is similar.

​
Step 1: Prepare Your Database

Ensure your MariaDB server is accessible from BonData’s IP addresses. You may need to:
  1. Configure your firewall to allow connections on port 3306 (or your custom port)
  2. Update the bind-address in your MariaDB configuration if needed
For security, create a dedicated read-only user for BonData: 
-- Create a user for BonData (update 'your_ip' as needed)
CREATE USER 'bondata_user'@'%' IDENTIFIED BY 'your_secure_password';

-- Grant select access on the database
GRANT SELECT ON your_database.* TO 'bondata_user'@'%';

-- Apply the changes
FLUSH PRIVILEGES;

​
Step 3: Gather Connection Details

Collect the following information:
  • Host: Your database server hostname or IP address
  • Port: Usually 3306
  • Database: The name of the database to connect to
  • User: The username created above
  • Password: The password for the user

​
Step 4: Connect in BonData

Enter your connection details in BonData to establish the connection.

​
Required Fields

FieldDescription
HostDatabase server hostname or IP address
PortDatabase server port (default: 3306)
DatabaseName of the database to connect to
UserDatabase username
PasswordDatabase password
BonData supports SSL connections for enhanced security. Contact support if you need to configure SSL certificates.

​
Available Data

Once connected, BonData can sync:
  • Tables - All tables the user has SELECT access to
  • Views - Database views accessible to the user
  • Custom Queries - Run custom SQL queries to extract specific data