MySQL

Install dependencies for Ibis’s MySQL dialect:

pip install 'ibis-framework[mysql]'

Create a client by passing a connection string or individual parameters to ibis.mysql.connect():

con = ibis.mysql.connect(url='mysql+pymysql://ibis:ibis@mysql/ibis_testing')
con = ibis.mysql.connect(
    user='ibis',
    password='ibis',
    host='mysql',
    database='ibis_testing',
)

API

The MySQL client is accessible through the ibis.mysql namespace.

Use ibis.mysql.connect with a SQLAlchemy-compatible connection string to create a client.

Backend.connect([host, user, password, ...])

Create an Ibis client located at user:password`@`host:port connected to a MySQL database named database.

Backend.database([name])

Return a Database object for the name database.

Backend.list_databases([like])

List databases in the current server.

Backend.list_tables([like, database])

Return the list of table names in the current database.

Backend.table(name[, database, schema])

Create a table expression that references a particular a table called name in a MySQL database called database.