# Altertable CLI reference

| Command                          | Description                                                                                                 | Group    |
| -------------------------------- | ----------------------------------------------------------------------------------------------------------- | -------- |
| `altertable login`               | Sign in with your browser (OAuth) and store the session.                                                    | Platform |
| `altertable logout`              | Remove stored credentials and settings for all profiles.                                                    | Platform |
| `altertable profile`             | Manage named profiles and stored credentials.                                                               | Platform |
| `altertable profile configure`   | Create or update a profile's credentials and settings                                                       | Platform |
| `altertable profile list`        | List configured profiles                                                                                    | Platform |
| `altertable profile show`        | Show a profile's stored identity, auth, and endpoints                                                       | Platform |
| `altertable profile status`      | Verify stored credentials and show the profile                                                              | Platform |
| `altertable profile switch`      | Interactively switch the active profile                                                                     | Platform |
| `altertable profile current`     | Show the active profile name                                                                                | Platform |
| `altertable profile env`         | Print shell exports for a profile                                                                           | Platform |
| `altertable profile delete`      | Delete a profile                                                                                            | Platform |
| `altertable catalog`             | Manage catalogs (databases and connections) in the current environment.                                     | Platform |
| `altertable catalog create`      | Create an Altertable catalog.                                                                               | Platform |
| `altertable api`                 | Management REST API — HTTP invoker and OpenAPI spec.                                                        | Platform |
| `altertable api route`           | List management API paths and methods from the bundled OpenAPI spec.                                        | Platform |
| `altertable api spec`            | Print the bundled management OpenAPI specification (YAML by default; JSON with --json).                     | Platform |
| `altertable doctor`              | Diagnose local configuration and Altertable connectivity.                                                   | Platform |
| `altertable app`                 | Create, develop, lint, build, and upgrade local data apps; validate, publish, and update data apps.         | Platform |
| `altertable app create`          | Create a local data app project with a live connection check.                                               | Platform |
| `altertable app dev`             | Preview a data app locally with lakehouse access.                                                           | Platform |
| `altertable app build`           | Typecheck and build a local data app without Altertable credentials.                                        | Platform |
| `altertable app lint`            | Lint a local data app project: format, lint rules, types, contracts, build, and client credential boundary. | Platform |
| `altertable app upgrade`         | Update a local data app's package to the CLI's tested version.                                              | Platform |
| `altertable app validate`        | Type-check and bundle a data app from source without saving.                                                | Platform |
| `altertable app publish`         | Create a data app from source.                                                                              | Platform |
| `altertable app update`          | Update a data app from source. Omitted fields are left unchanged.                                           | Platform |
| `altertable update`              | Update Altertable CLI to the latest release.                                                                | Platform |
| `altertable completion`          | Generate or install shell completion scripts.                                                               | Platform |
| `altertable completion generate` | Generate a shell completion script.                                                                         | Platform |
| `altertable completion install`  | Install shell completion for the current shell.                                                             | Platform |
| `altertable append`              | Append JSON rows to a table.                                                                                | Ingest   |
| `altertable append status`       | Fetch status for an append operation.                                                                       | Ingest   |
| `altertable upload`              | Upload a file to create, append to, or overwrite a table.                                                   | Ingest   |
| `altertable upsert`              | Upload a file and match existing rows by primary key.                                                       | Ingest   |
| `altertable query`               | Run SQL queries against the lakehouse.                                                                      | Query    |
| `altertable query show`          | Fetch metadata for a completed or running query.                                                            | Query    |
| `altertable query cancel`        | Cancel a running query.                                                                                     | Query    |
| `altertable schema`              | List schemas, tables, and columns for a catalog.                                                            | Query    |
| `altertable duckdb`              | Open a DuckDB shell attached to lakehouse catalogs (all of them by default).                                | Query    |