Dolt

Use this skill when the user wants a SQL database with Git-style version control — branch tables, diff schemas, merge data changes, or clone/fork datasets like a Git repository.

javimosch 1d69ac5 1.3 KB Updated

File contents

dolt Plugin

Git for data — a MySQL-compatible SQL database you can fork, clone, branch, merge, push, and pull. Version-control tabular data with familiar Git workflows.

Installation

curl -L https://github.com/dolthub/dolt/releases/latest/download/install.sh | bash
# or
brew install dolt

Basic Usage

# Initialize a new database repo
dolt init

# Start a SQL shell (MySQL-compatible)
dolt sql

# Run a query
dolt sql -q "SELECT * FROM my_table"

# Version control operations
dolt status
dolt add .
dolt commit -m "Add initial data"
dolt branch feature
dolt checkout feature
dolt diff
dolt merge main

Remote Workflows

# Clone from DoltHub
dolt clone dolthub/my-org/my-database

# Push and pull
dolt remote add origin dolthub/my-org/my-database
dolt push origin main
dolt pull origin main

Usage Examples

  • "Create a versioned SQL database for this dataset"
  • "Show me the diff between branches"
  • "Query this table and commit the changes"
  • "Clone a Dolt database from DoltHub"

SuperCLI

sc dolt _ _ sql -q "SHOW TABLES"
sc plugins learn dolt

javimosch/supercli/tree/main/plugins/dolt/skills/quickstart commit 1d69ac5958

Frequently asked questions

npx skillmds@latest add javimosch/dolt