DocsConnectors

Mysql

Mysql logo

Mysql

Connect your Mysql data to Airweave

Overview

The Mysql connector allows you to sync data from Mysql into Airweave, making it available for search and retrieval by your agents.

Configuration

MySQLSource

MySQL source implementation.

This source connects to a MySQL database and generates entities for each table in the specified schemas. It uses database introspection to:

  1. Discover tables and their structures
  2. Create appropriate entity classes dynamically
  3. Generate entities for each table’s data
View Source Code

Explore the Mysql connector implementation

Authentication

This connector uses a custom authentication configuration class: MySQLAuthConfig.

Authentication Configuration

MySQL authentication configuration.

host
strRequired

The host of the MySQL database

port
intRequired

The port of the MySQL database

database
strRequired

The name of the MySQL database

user
strRequired

The username for the MySQL database

password
strRequired

The password for the MySQL database

schema
strDefaults to public

The schema of the MySQL database

tables
strDefaults to *

Comma separated list of tables to sync. For example, ‘users,orders’. For all tables, use ’*’