This topic describes a compatibility test for DataGrip 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

MySQL JDBC Driver DataGrip
mysql-connector-java-8.0.15. Download DataGrip.

Test scope

  • Test connectivityTest connectivity
  • List databasesList databases
  • Create a tableCreate a table
  • List all tablesList all tables
  • Query the schema of a tableList all tables
  • Write data to a tableWrite data to a table
  • Query the data of a tableQuery the data of a table
  • Create a viewCreate a view
  • Query a viewQuery a view