This topic describes a compatibility test for DBeaver 6.1.2 Community Edition and AnalyticDB for MySQL, and provides screenshots of test results. Compatibility is tested for a variety of aspects including connectivity, database listing, and table creation.

Test environment

Java MySQL AnalyticDB for MySQL DBeaver
  • java version "1.8.0_161"
  • Java(TM) SE Runtime Environment (build 1.8.0_161-b12)
  • Java HotSpot(TM) 64-Bit Server VM (build 25.161-b12, mixed mode)
mysql Ver5.6.46 for osx10.13 on x86_64 (Homebrew) AnalyticDB for MySQL V3.1.0 and later DBeaver 6.1.2 Community Edition

Test scope

  • Test connectivityConnectivity 1Connectivity 2
  • List databasesList databases
  • Create a tableCreate a table 1Create a table 2
  • List all tablesList all tables
  • Query the schema of a tableQuery the schema of a table 1Query the schema of a table 2
  • Write data to a tableWrite data to a table
  • Query the data of a tableQuery a table 1Query a table 2
  • Create a viewCreate a view
  • Query the structure of a viewQuery the structure of a view 1Query the structure of a view 2
  • Query a viewQuery the data of a viewQuery the data of a view 2