dkdc-md-cli 0.2.0

CLI for the MotherDuck REST API
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117

# MotherDuck CLI

CLI for the [MotherDuck REST API](https://motherduck.com/docs/sql-reference/rest-api/motherduck-rest-api/).

[![GitHub Release](https://img.shields.io/github/v/release/lostmygithubaccount/md-cli?color=blue)](https://github.com/lostmygithubaccount/md-cli/releases)
[![PyPI](https://img.shields.io/pypi/v/dkdc-md-cli?color=blue)](https://pypi.org/project/dkdc-md-cli/)
[![crates.io](https://img.shields.io/crates/v/dkdc-md-cli?color=blue)](https://crates.io/crates/dkdc-md-cli)
[![CI](https://img.shields.io/github/actions/workflow/status/lostmygithubaccount/md-cli/ci.yml?branch=main&label=CI)](https://github.com/lostmygithubaccount/md-cli/actions/workflows/ci.yml)
[![License: MIT](https://img.shields.io/badge/license-MIT-8A2BE2.svg)](https://github.com/lostmygithubaccount/md-cli/blob/main/LICENSE)

**Important**: This is a personal project. I am not affiliated with MotherDuck.

## Install

Recommended:

```bash
curl -LsSf https://dkdc.sh/md-cli/install.sh | sh
```

Pre-built binaries are available for Linux and macOS via Python (`uv`). Windows users should install via `cargo` or use macOS/Linux.

uv:

```bash
uv tool install dkdc-md-cli
```

cargo:

```bash
cargo install dkdc-md-cli
```

Either option will install the `md` command globally. You can use `uvx` to run it without installing:

```bash
uvx --from dkdc-md-cli md
```

## Authentication

Set a MotherDuck API token via environment variable:

```bash
export MOTHERDUCK_TOKEN="your-token-here"
```

Token resolution order (first non-empty wins):

1. `--token` flag (pass `-` to read from stdin)
2. `motherduck_token`
3. `MOTHERDUCK_TOKEN`
4. `motherduck_api_key`
5. `MOTHERDUCK_API_KEY`

## Usage

```
md [--output text|json] [--token TOKEN] [--yes] <command>
```

### Global flags

| Flag | Short | Description |
|------|-------|-------------|
| `--output` | `-o` | Output format: `text` (default) or `json` |
| `--token` | | API token (overrides env vars; `-` reads from stdin) |
| `--yes` | `-y` | Skip confirmation prompts |

### `service-account`

```bash
# Create a service account
md service-account create <username>

# Delete a service account (prompts for confirmation)
md service-account delete <username>
```

### `token`

```bash
# List tokens for a user
md token list <username>

# Create a new token
md token create <username> --name <name> [--ttl <seconds>] [--token-type <type>]

# Delete a token (prompts for confirmation)
md token delete <username> <token_id>
```

`--ttl`: time-to-live in seconds (300–31536000). Omit for no expiration.

`--token-type`: `read-write` (default) or `read-scaling`.

### `duckling`

```bash
# Get current duckling config
md duckling get <username>

# Set duckling config (at least one override required)
md duckling set <username> [--rw-size <size>] [--rs-size <size>] [--flock-size <n>]
```

Instance sizes: `pulse`, `standard`, `jumbo`, `mega`, `giga`.

Flock size: 0–64. `duckling set` fetches the current config and merges your overrides, so you only need to specify what you're changing.

### `account`

```bash
# List active accounts and their ducklings
md account list-active
```