MySQL & MariaDB

Connect Querri to your MySQL or MariaDB database to analyze data using natural language. Once connected, simply ask questions—Querri handles all the SQL for you.

Overview

The MySQL connector supports:

• MySQL 5.7+: All modern MySQL versions
• MySQL 8.0+: Full support including new features
• MariaDB 10.x: All MariaDB versions
• AWS RDS MySQL: Managed MySQL on AWS
• Azure Database for MySQL: Managed MySQL on Azure
• Google Cloud SQL for MySQL: Managed MySQL on GCP

Setup

Prerequisites

• MySQL or MariaDB database server
• Database credentials with appropriate permissions
• Network access to the database

IP Whitelisting

Important: For cloud-hosted databases or databases behind firewalls, whitelist the following IP address:

18.189.33.77

This is Querri’s outbound IP address. Add this to your database firewall rules or security group.

Creating the Connector

1. Navigate to Connectors

   • Go to Settings → Connectors
   • Click “Add Connector”

2. Select MySQL

   • Choose “MySQL” from the database connectors

3. Configure Connection

Host: your-database-host.com
Port: 3306 (default MySQL port)
Database: your_database_name
Username: your_username
Password: your_password

Optional Settings:

• SSL: Enable for encrypted connections
• Charset: Default is utf8mb4
• Connection Timeout: Default is 30 seconds

4. Test Connection

   • Click “Test Connection” to verify
   • If successful, click “Save”

5. Start Analyzing

   • Tables appear in your Library
   • Create a project from any table
   • Ask questions in natural language

Network Configuration

AWS RDS Security Groups

Add inbound rule:

Type: MySQL/Aurora
Protocol: TCP
Port: 3306
Source: 18.189.33.77/32
Description: Querri Access

Azure MySQL Firewall

Add firewall rule:

Rule Name: Querri
Start IP: 18.189.33.77
End IP: 18.189.33.77

Google Cloud SQL

Add authorized network:

Name: Querri
Network: 18.189.33.77/32

Database User Setup

Read-Only User (Recommended)

Create a dedicated read-only user for Querri:

-- Create user
CREATE USER 'querri_readonly'@'%'
IDENTIFIED BY 'secure_password_here';

-- Grant read permissions
GRANT SELECT ON your_database.* TO 'querri_readonly'@'%';

-- Apply changes
FLUSH PRIVILEGES;

Restricting Access to Specific Tables

For tighter security, grant access only to specific tables:

-- Create user
CREATE USER 'querri_readonly'@'%' IDENTIFIED BY 'secure_password_here';

-- Grant access to specific tables only
GRANT SELECT ON your_database.orders TO 'querri_readonly'@'%';
GRANT SELECT ON your_database.customers TO 'querri_readonly'@'%';
GRANT SELECT ON your_database.products TO 'querri_readonly'@'%';

FLUSH PRIVILEGES;

See Database Best Practices for detailed guidance on creating analytics views and restricting access.

Verify User Permissions

-- Show user grants
SHOW GRANTS FOR 'querri_readonly'@'%';

Sync Scheduling

MySQL data can be kept up to date with scheduled syncs. Go to Settings → Connectors, select your MySQL connector, and open the Schedule tab.

Both full and incremental syncs are supported. For incremental sync, specify a cursor column (e.g., updated_at or created_at) that reliably updates when rows change. Tables without a suitable cursor column will use full sync.

See the Sync Scheduling guide for complete setup instructions.

Troubleshooting

Connection Refused

Problem: Can’t connect to MySQL server

Solutions:

1. Verify IP 18.189.33.77 is whitelisted
2. Check MySQL is running: systemctl status mysql
3. Verify bind-address allows remote connections
4. Check firewall rules
5. Verify host and port are correct

Access Denied

Problem: Access denied for user

Solutions:

1. Double-check username and password
2. Verify user exists: SELECT user, host FROM mysql.user;
3. Check user permissions: SHOW GRANTS FOR 'username'@'host';
4. Ensure user is created with correct host (% for any host)
5. Run FLUSH PRIVILEGES; after grant changes

Unknown Database

Problem: Unknown database error

Solutions:

1. Verify database name is correct
2. List databases: SHOW DATABASES;
3. Ensure user has access to database
4. Check for typos in database name

Too Many Connections

Problem: Too many connections error

Solutions:

1. Check current connections: SHOW PROCESSLIST;
2. Increase max_connections: SET GLOBAL max_connections = 200;
3. Close idle connections
4. Optimize connection pooling settings

Security Best Practices

Use Read-Only Credentials

Create dedicated read-only users for analytics to prevent accidental data modification.

Enable SSL

For production databases, enable SSL:

-- Require SSL for user
ALTER USER 'querri_readonly'@'%' REQUIRE SSL;
FLUSH PRIVILEGES;

In connector settings:

SSL: Enabled

Restrict Host Access

Limit user to Querri’s IP:

-- Instead of '%', use specific IP
CREATE USER 'querri_readonly'@'18.189.33.77'
IDENTIFIED BY 'password';

MySQL vs MariaDB

The connector works with both. Note these differences:

MySQL 8.0 Features

• Window functions
• CTEs (WITH clause)
• JSON functions
• Better optimizer

MariaDB Features

• Sequence support
• System-versioned tables
• Different JSON implementation

MySQL Versions

Tested and supported:

• MySQL 8.0.x ✓
• MySQL 5.7.x ✓
• MySQL 5.6.x ✓ (limited support)
• MariaDB 10.11.x ✓
• MariaDB 10.6.x ✓
• MariaDB 10.5.x ✓
• MariaDB 10.4.x ✓

Next Steps

• Database Best Practices — Create analytics views and optimize for natural language queries
• Data Connectors Overview — See all available connectors
• Managing Connections — Edit and monitor your connectors