# db9 CLI Reference

All commands support `--json` for machine-readable output.

## Database Lifecycle

```bash
db9 db create --name <NAME> [--region <REGION>]   # Create database
db9 db list                                        # List all databases
db9 db status <ID>                                 # Get database details
db9 db delete <ID>                                 # Delete database
db9 db connect <ID>                                # Show connection info
db9 db reset-password <ID>                         # Reset admin password
```

## SQL Execution

```bash
db9 db sql <ID> -q "SELECT * FROM users"           # Inline query
db9 db sql <ID> -f query.sql                       # From file
db9 db sql <ID> -q "..." --json                    # JSON output
db9 db sql <ID> -q "..." --output csv              # CSV output
```

## Database Branching

```bash
db9 db branch create <ID> --name <BRANCH_NAME>    # Branch (schema copy)
db9 db branch list <ID>                            # List branches
db9 db branch delete <BRANCH_ID>                   # Delete branch
```

## Migrations

```bash
db9 migration new <NAME> [--dir ./migrations]     # Create migration file
db9 migration list [--dir ./migrations]            # List local migrations
db9 migration up <ID> [--dir ./migrations]         # Apply pending migrations
db9 migration status <ID> [--dir ./migrations]     # Applied vs pending
```

## Observability

```bash
db9 db inspect <ID>                                # Summary metrics
db9 db inspect <ID> queries                        # Query samples + perf
db9 db inspect <ID> report                         # Combined summary
db9 db inspect <ID> schemas                        # List schemas
db9 db inspect <ID> tables                         # List tables
db9 db inspect <ID> indexes                        # List indexes
db9 db inspect <ID> slow-queries                   # Slow queries by p99
```

## Data Operations

```bash
db9 db seed <ID> <FILE>                            # Execute seed SQL file
db9 db dump <ID> -o backup.sql                     # Export schema + data
db9 db dump <ID> --ddl-only -o schema.sql          # Export schema only
```

## Type Generation

```bash
db9 gen types <ID> --lang typescript               # TS types from schema
db9 gen types <ID> --lang python                   # Python types
db9 gen types <ID> --schema <SCHEMA>               # Specific schema
```

## User Management

```bash
db9 db users <ID> list                             # List users
db9 db users <ID> create                           # Create user
db9 db users <ID> delete                           # Delete user
```

## Token Management

```bash
db9 token list                                     # List API tokens
db9 token revoke                                   # Revoke a token
```