Connect and Query

This page is part of MariaDB's Enterprise Documentation.

Topics on this page:

Overview

Database connections are made using a connector (from an application) or a client (interactively or from scripts).

Clients and connectors listed here are supported under MariaDB Corporation Engineering Policies.

Clients and connectors listed here are compatible with:

MariaDB Connectors are available for many popular programming languages.

Programming Language / Interface	Connector
C	MariaDB Connector/C
C++	MariaDB Connector/C++
Java - JDBC	MariaDB Connector/J
Java - R2DBC	MariaDB Connector/R2DBC
JavaScript	MariaDB Connector/Node.js
ODBC	MariaDB Connector/ODBC
Python	MariaDB Connector/Python

MariaDB Client can be used interactively or within scripts.

MariaDB Client is included with distributions of MariaDB Enterprise.

Compatible third-party clients exist but are not listed here.

Executable Filename	Purpose
`mariadb`, `mysql`	Connect from the command-line

Tools and utilities listed here are included with distributions of MariaDB Enterprise and make a client connection.

Command-Line Executable	Purpose
`mariadb-admin`, `mysqladmin`	Check configuration and current status
`mariadb-backup`, `mariabackup`	Create and restore physical backups (including Aria, InnoDB, MyISAM, MyRocks)
`mariadb-binlog`, `mysqlbinlog`	Read binary logs or relay logs
`mariadb-check`, `mysqlcheck`	Perform table maintenance operations
`mariadb-dump`, `mysqldump`	Create logical backups
`mariadb-import`, `mysqlimport`	Load table data from CSV, TSV, and other text file formats
`mariadb-show`, `mysqlshow`	Display databases, tables, table columns, indexes
`mariadb-slap`, `mysqlslap`	Generate client load for testing

MariaDB Enterprise is accessible from business intelligence (BI) platforms, including:

BI Platform	Detail
Microsoft Power BI	MariaDB Direct Query Adapter for Microsoft Power BI enables Microsoft Power BI Desktop users to remotely connect to and query their MariaDB database, including on MariaDB SkySQL, without downloading the entire data set to their local machine.