otty / apps

All apps/Dolt

Dolt

dolt

Dolt is Git for data.

Runs as dolt|macOS, Linux, Windows|www.dolthub.com

Open form in Otty otty.toml

Command form

ai-draft · 6 tasks · 31 fields

Common Dolt jobs: clone a database, run SQL, commit and read the log. Remotes, branches, merges and the SQL server are not covered.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui dolt

`dolt clone`

Clone a database

Clone a databaseExample values, fixed in this page — nothing here reaches a terminal

Basic

Remote URL*

string

New directory

`dolt sql`

Run SQL

Run SQLExample values, fixed in this page — nothing here reaches a terminal

Basic

Query*

string

Result format

5 choicesenum

TasksEach one presets the form for one job

Run a query

queryresult_format

Run a script

filecontinue_on_error

Interactive shell

ParametersOnly these flags are editable in the form

Query

Runs a single query and exits. Leave empty for the interactive shell.
string

--query-q

SQL file

Execute statements from this file.
path

--file-f

Result format

enum

--result-format-rtabularcsvjsonverticalparquet

Save query as

Used with a query: save it in the query catalog under this name.
string

--save-s

Saved query description

string

--message-m

Run saved query

string

--execute-x

List saved queries

boolean

--list-saved-l

Continue on error

boolean

--continue-c

`dolt commit`

Commit staged changes

Commit staged changesExample values, fixed in this page — nothing here reaches a terminal

Basic

Message*

string

Stage changed tables

--all

TasksEach one presets the form for one job

Commit

messageall

ParametersOnly these flags are editable in the form

Message

string

--message-m

Stage changed tables

boolean

--all-a

Stage all tables including new

boolean

--ALL-A

Skip when nothing staged

boolean

--skip-empty

Allow empty commit

boolean

--allow-empty

Amend previous commit

boolean

--amend

Author

A U Thor <author@example.com>
string

--author

Date

YYYY-MM-DD or YYYY-MM-DDTHH:MM:SS.
string

--date

Ignore foreign key warnings

boolean

--force-f

`dolt log`

Show commit log

Show commit logExample values, fixed in this page — nothing here reaches a terminal

Basic

Number of commits

10integer

Compact format

--oneline

TasksEach one presets the form for one job

Recent commits

numberoneline

ParametersOnly these flags are editable in the form

Revisions

Revision or revision range; defaults to HEAD.
string · positional 0 · repeatable

Number of commits

integer

--number-n

Compact format

boolean

--oneline

Commit graph

boolean

--graph

Diffstat per commit

boolean

--stat

Merge commits only

boolean

--merges

Show parents

boolean

--parents

All branches

boolean

--all

SourcesEvery flag above is checked against these

help

dolt clone [-remote <remote>] [-branch <branch>] [--aws-region <region>] [--aws-creds-type <creds-type>] [--aws-creds-file <file>] [--aws-creds-profile <profile>] <remote-url> <new-dir> -b, --branch: The branch to be cloned. If not specified all branches will be cloned. --depth: Clone a single branch and limit history to the given commit depth. -u, --user:…

manual2026-10-27

docs.dolthub.com

help

dolt sql dolt sql < script.sql dolt sql -q <query> [-r <result format>] [-s <name> -m <message>] [-b] -q, --query: Runs a single query and exits. -r, --result-format: How to format result output. Valid values are tabular, csv, json, vertical, and parquet. Defaults to tabular. -s, --save: Used with —query, save the query to the query catalog with the name pro…

manual2026-10-27

docs.dolthub.com

help

dolt commit [options] -m, --message: Use the given <msg> as the commit message. --allow-empty: Allow recording a commit that has the exact same data as its sole parent. --skip-empty: Only create a commit if there are staged changes. --date: Specify the date used in the commit. If not specified the current system time is used. -f, --force: Ignores any foreign…

manual2026-10-27

docs.dolthub.com

help

dolt log [-n <num_commits>] [<revision-range>] [[--] <table>] -n, --number: Limit the number of commits to output. --merges: Equivalent to min-parents == 2, this will limit the log to commits with 2 or more parents. --parents: Shows all parents of each commit in the log. --all: Automatically select every branch in database --oneline: Shows logs in a compact…

manual2026-10-27

docs.dolthub.com

Before it fills your prompt, Otty checks the installed dolt against its version. A form that does not match your version is not offered.