Schema Commander v0.2.0

Schema Commander 0.2.0

This release is about databases: twelve more kinds can be connected.

New databases

Database	What works	Checked against
Oracle	run, browse, details with DDL, table view, edit rows, search (pure Rust driver, no Instant Client)	a real server
DuckDB	built in: a file or :memory:, Parquet, CSV and JSON without extensions	inside the tests
ClickHouse	read and analyse over HTTP	a real server
YugabyteDB	recognised behind PostgreSQL's protocol, like CockroachDB and TimescaleDB	a real server
Trino / Presto	read and analyse over HTTP, one profile per catalog	real servers
libSQL / Turso	everything a SQLite file does, but the copy as a backup	a real server
Firebird	run, cancel, browse, details, edit rows, search (pure Rust driver)	a real server
BigQuery	read and run with the key file of a service account	the emulator only, not Google
Cloudflare D1	read and run over Cloudflare's REST API	not run against Cloudflare
Snowflake	read and run over its SQL API, with a token or a key pair	not run against Snowflake
Db2 (LUW)	read and run, every statement committed as it ran (pure Rust driver, no IBM client)	never run against a server

The last four are written from the documentation of their service. Treat them as a first cut and please
report what does not work.

Things to know

• Plans, the server monitor, rights and structure editing are not there yet for the new databases.
• Rows are edited only where the database has transactions and keys that hold: not in ClickHouse, Trino,
  BigQuery, D1, Snowflake, and not yet in Db2.
• Db2 without TLS sends the password the way the server asks for it – usually in clear. Use TLS (port 50001)
  or an SSH tunnel across networks you do not trust.
• Snowflake uses the default warehouse and role of the user; transactions, USE and ALTER SESSION are
  refused, because its SQL API keeps no session.
• An assistant connected over MCP gets no query run on DuckDB, BigQuery, Snowflake and Db2.

Also

• A product site (site/).
• Building from source now needs Rust 1.98.1 or newer.

The packages are not signed: macOS warns through Gatekeeper (right click → Open), Windows through
SmartScreen. SHA256SUMS.txt holds the checksums.

Schema Commander v0.1.0

Unsigned preview build unless noted. Release notes: generate with pnpm release:notes (docs/release.md) and paste here before publishing.