Switch the safety mode.

Accepts: "read-only", "write", or "admin". Returns the current mode after setting.

Return the current safety mode without changing it.

Server health check. Returns version and status.

Connect to a database.

Supported DSN formats:

• postgresql://user:pass@host/db

• sqlite:///path/to/file.db (or :memory:)

• mysql://user:pass@host/db

Returns a connection_id used by all other tools.

Execute a SELECT query. Auto-adds LIMIT 1000 if no LIMIT clause present.

Execute INSERT/UPDATE/DELETE statements.

Respects the current safety mode:

• read-only: rejects all writes

• write: allows INSERT/UPDATE/DELETE, blocks DROP/TRUNCATE

• admin: allows everything (destructive ops need a confirmation_token)

List tables, views, and indexes in the database.

Column details for a table: name, type, nullable, default, constraints.

Foreign key relationships. Omit table to show all.

Database and table sizes.

Currently running queries (PostgreSQL only — pg_stat_activity).

Run EXPLAIN ANALYZE on a query and return the plan.

Create a database backup.

• PostgreSQL: uses pg_dump

• MySQL: uses mysqldump

• SQLite: uses .backup via sqlite3 CLI

Paths are sandboxed to BERTH_BACKUP_DIR (default: cwd).

Restore a database from a backup file.

Requires admin mode and a confirmation token (destructive operation). Paths are sandboxed to BERTH_BACKUP_DIR (default: cwd).

Generate migration SQL by comparing two schemas.

Two modes of operation:

Mode 1 — Compare live database against target DDL:

• connection_id: source database connection

• target_sql: CREATE TABLE statements describing the desired schema

Mode 2 — Compare two live databases:

• from_connection: source database connection_id

• to_connection: target database connection_id

Returns dialect-aware ALTER statements to migrate source -> target. Destructive operations (DROP TABLE, DROP COLUMN) are commented out for safety.