Skip to main content
Point the connection at a frontend’s MySQL port, 9030, not the 8030 HTTP port. The StarRocks driver is a plugin that installs the first time you pick StarRocks, and is built from the MySQL driver. It confirms the server is StarRocks with SELECT current_version(); a MySQL server saved under this type fails at connect and asks for the type to be changed. No minimum StarRocks version is enforced.

​
Quick setup

A single-node cluster in Docker:
Connect as root with an empty password once the frontend reports ready, about a minute after start.

​
Connection settings

Host, user, password and SSH tunnels work as on MySQL.

​
Connection URL

The path is the Database field, so it takes catalog.database too. Copy Connection String gives the same form.

​
Catalogs and databases

Catalogs fill the database level and each catalog’s databases fill the schema level, so the sidebar shows default_catalog and every external catalog, with their databases beneath. Cmd+K switches catalog, and the database picker switches database within it. The Database field takes the same two levels. Write glue_iceberg.sales to open on database sales in catalog glue_iceberg, or glue_iceberg. to open the catalog with no database selected. A name with no dot is a database of default_catalog, as in other StarRocks clients. Leave the field empty to start in default_catalog. Materialized views in default_catalog list apart from views, and open on their CREATE MATERIALIZED VIEW. The sidebar hides _statistics_, information_schema and sys.

​
Editing rows

What a save can do depends on the table’s key model. Edits save one statement at a time with no transaction. A match on every column leaves out ARRAY, MAP, STRUCT, JSON, BITMAP, HLL, PERCENTILE, BINARY and VARBINARY columns, and compares FLOAT columns as text. A delete from a duplicate key table reports 0 rows even when it removes some, so a delete matched on every column is not checked against the row count. To change a row the server refuses to update, delete it and insert it again in the SQL editor. JSON and VARIANT columns read as text in the grid and the inspector.

​
Limitations

  • No indexes, foreign keys, triggers, routines, events or partitions. The Structure tab shows columns, with key columns marked, and does not edit them.
  • No Create Database, Drop Database, renames or import. Create catalogs and databases in the SQL editor.
  • The table info panel shows row counts and sizes for default_catalog tables only. An external catalog’s tables show none.
  • EXPLAIN ANALYZE is not in the plan menu. Run it in the SQL editor; its report carries terminal color codes.
  • No Users & Roles, Server Dashboard or Table Maintenance.
  • Not available on iPhone and iPad.
  • MySQL, for connection fields, SSL/TLS, and troubleshooting
  • Trino, which browses catalogs the same way
  • SSH Tunneling