Skip to content
Documentation

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

Section titled “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

Section titled “Setup”

Prerequisites

Section titled “Prerequisites”
  • MySQL or MariaDB database server
  • Database credentials with appropriate permissions
  • Network access to the database

IP Whitelisting

Section titled “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

Section titled “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

  1. Test Connection

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

  2. Start Analyzing

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

Network Configuration

Section titled “Network Configuration”

AWS RDS Security Groups

Section titled “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

Section titled “Azure MySQL Firewall”

Add firewall rule:

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

Google Cloud SQL

Section titled “Google Cloud SQL”

Add authorized network:

Name: Querri
Network: 18.189.33.77/32

Database User Setup

Section titled “Database User Setup”
Section titled “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

Section titled “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

Section titled “Verify User Permissions”
-- Show user grants
SHOW GRANTS FOR 'querri_readonly'@'%';

Troubleshooting

Section titled “Troubleshooting”

Connection Refused

Section titled “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

Section titled “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

Section titled “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

Section titled “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

Section titled “Security Best Practices”

Use Read-Only Credentials

Section titled “Use Read-Only Credentials”

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

Enable SSL

Section titled “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

Section titled “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

Section titled “MySQL vs MariaDB”

The connector works with both. Note these differences:

MySQL 8.0 Features

Section titled “MySQL 8.0 Features”
  • Window functions
  • CTEs (WITH clause)
  • JSON functions
  • Better optimizer

MariaDB Features

Section titled “MariaDB Features”
  • Sequence support
  • System-versioned tables
  • Different JSON implementation

MySQL Versions

Section titled “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

Section titled “Next Steps”