dolt-sql

Run SQL query

$ dolt sql -q "[SELECT * FROM table]"

$ dolt sql

$ dolt sql < [script.sql]

$ dolt sql -q "[SELECT * FROM table]" -r [csv]

$ dolt sql-server

$ dolt sql -b -q "[INSERT INTO table VALUES (1, 'a')]"

dolt sql [options] [-q query]

dolt sql provides SQL access to Dolt repositories. It supports MySQL-compatible SQL syntax for querying and modifying data in versioned tables.
The interactive shell offers tab completion and command history. Queries can read from any branch or commit using Dolt's SQL extensions, enabling time-travel queries across the repository history.
dolt sql-server starts a MySQL-compatible server allowing connections from standard MySQL clients, ORMs, and applications.

-q QUERY

SQL query to execute.

Result format: tabular, csv, json, null.

Batch mode (no formatting).

Vertical result format.

Continue on error in batch mode.

Display help information.

Some MySQL features not fully supported. Write queries modify working set (need commit). Large result sets may be slow to render. Server mode requires port availability.

dolt sql provides the primary data interaction interface for Dolt, implementing MySQL compatibility to enable use with existing SQL tools and knowledge.

dolt(1), mysql(1), sqlite3(1)