Terox is an interactive CLI client designed for managing sharded PostgreSQL clusters. The tool allows developers to execute queries across multiple shards simultaneously, aggregate results into a single table, and maintain context for specific services and storage environments.
The client uses templates to define host and database configurations, supporting up to 128 shards. It includes features like fanout concurrency control to prevent overloading the infrastructure, query timeouts, and statement-level timeouts to ensure operational safety during manual tasks.
Terox provides specialized commands for diagnostics, such as finding specific records across shards, monitoring locks, and checking table sizes. It also includes a linting feature to detect potentially dangerous SQL queries, such as deletions without a WHERE clause.
For database migrations, Terox supports dry-run modes, canary deployments, and batch processing. It enforces safety measures by defaulting to read-only mode and requiring explicit authorization for write operations, while also preventing destructive commands like dropping databases.
