This topic describes how to connect to and access OceanBase AI Database. Currently, you can connect to OceanBase AI Database by using a client, GUI, driver, ORM framework, or connection pool.
Choose a client
You can use any of the following clients to connect to OceanBase AI Database:
MySQL client (mysql)
The mysql client is a command-line client for MySQL databases. You must install it separately.
After connecting to OceanBase AI Database, you can run MySQL O&M commands and execute SQL statements on the mysql command line to perform the following tasks:
Compute, store, and print query results.
Create database objects, check and modify object definitions.
Perform database management and modify parameters.
For more information about how to connect to OceanBase AI Database by using the mysql client, see Connect to OceanBase AI Database by using the MySQL client.
OceanBase Client (OBClient)
OBClient is an interactive query tool that supports batch processing. It must be installed separately. OBClient provides a command-line user interface and acts as the client when it is connected to a database. It can connect to OceanBase AI Database.
When you run OBClient, you must specify the connection information of the OceanBase AI Database tenant. After you connect to OceanBase AI Database, you can use OBClient to run database commands (including common MySQL commands), SQL statements, and PL statements to perform the following tasks:
Compute, store, and print query results.
Create database objects, check and modify object definitions.
Develop and run batch processing scripts.
Perform database management and modify parameters.
For more information about how to connect to an OceanBase AI Database tenant by using OBClient, see Connect to OceanBase AI Database by using OBClient.
OceanBase Developer Center (ODC)
OceanBase Developer Center (ODC) is an enterprise-level database development platform tailored for OceanBase AI Database.
ODC supports connecting to OceanBase AI Database and provides database developers with features such as daily development operations, WebSQL, SQL diagnostics, session management, and data import and export.
For more information about how to connect to OceanBase AI Database by using ODC, see Connect to OceanBase AI Database by using ODC.
Choose a GUI client
DBeaver
DBeaver is a general-purpose database client tool. It connects to databases using the JDBC drivers provided by each database and supports common relational databases, non-relational databases, distributed databases, and more.
For more information, see Connect to OceanBase AI Database by using DBeaver.
Navicat
Similar to DBeaver, Navicat is also a general-purpose database client tool. It connects to databases using the JDBC drivers provided by each database and supports common relational databases, non-relational databases, distributed databases, and more.
For more information, see Connect to OceanBase AI Database by using Navicat.
Choose a driver or ORM framework
OceanBase AI Database supports connections through drivers or ORM frameworks, providing flexible access solutions for different programming languages and development scenarios. For more information, see Connect via driver or ORM framework.
Connection pools
OceanBase AI Database supports multiple connection pool implementations. You can choose the one that suits your business requirements.
- Connect to OceanBase AI Database by Using a Tomcat Connection Pool
- Connect to OceanBase AI Database by Using a C3P0 Connection Pool
- Connect to OceanBase AI Database by Using a Proxool Connection Pool
- Connect to OceanBase AI Database by Using HikariCP Connection Pool
- Connect to OceanBase AI Database by using a DBCP connection pool
- Connect to OceanBase AI Database by using Commons Pool
- Connect to OceanBase AI Database by Using a Druid Connection Pool