Schema Browsing

tonic inspect gives terminal and editor clients a shared metadata surface.

List Containers

tonic inspect catalogs --target warehouse
tonic inspect namespaces --target warehouse --context catalog=ANALYTICS

Postgres and Snowflake expose catalogs and namespaces. MySQL collapses database and schema into one catalog-like scope. SQLite exposes attached database names as namespaces such as main and temp.

List Objects

tonic inspect tables \
  --target warehouse \
  --context catalog=ANALYTICS \
  --context namespace=PUBLIC

tonic inspect views --target warehouse --all

--all lists across accessible namespaces in the effective catalog. It cannot be combined with an explicit namespace context.

Inspect A Table Or View

tonic inspect columns daily_sales --target warehouse --format table
tonic inspect view-definition daily_sales_view --target warehouse --format text
tonic inspect ddl daily_sales --target warehouse --type table --format text

DDL support is backend-specific. Snowflake supports catalog, namespace, table, and view DDL; MySQL and SQLite support table and view DDL; Postgres DDL inspection is not currently implemented.

Refresh Stale Metadata

tonic inspect tables --target warehouse --refresh

Use --refresh after schema changes or when you need live metadata instead of the cached value.