MotionQL
Google Cloud Spanner

Cloud Spanner, interleaved tables and all

Instances, databases and interleaved tables in the tree, grid edits as mutations, query plans and profiles, and query, transaction and lock statistics from SPANNER_SYS.

  • Cloud Spanner (GoogleSQL)
  • Cloud Spanner (PostgreSQL dialect)
GoogleSQL and PostgreSQL dialect

What you get for Google Cloud Spanner

Schema as Spanner sees it

Interleaved tables with their parent and ON DELETE action, interleaved indexes, views, change streams and sequences, with DDL from getDatabaseDdl.

Edits as mutations

Grid edits become update, insert and delete mutations with a check that the key still matches one row.

Plans and profiles

Explain uses query mode PLAN and Explain Analyze PROFILE, with full scans flagged.

Insights

Query, transaction and lock statistics and the oldest active queries from SPANNER_SYS, with Cancel query.

Same app, same habits

And everything every connection gets

Each database keeps its own tools, and shares one workspace with the others.

Features to look at next

Also in analytics and warehouses: ClickHouse, Snowflake, Google BigQuery.

Your next query deserves a better IDE.

Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.